PostgreSQL

Articles and tutorials about PostgreSQL database to help you build better and more secure systems with persistent storage.

Articles on this topic

PostgreSQL

How to Create a Stored Procedure in PostgreSQL | Step-by-Step

Sep 4, 2023 by Mantas Levinas

In this tutorial, we will first explain what a PostgreSQL stored procedure is and then show how to create and list stored procedures.

PostgreSQL

How to Create a User in PostgreSQL | Step-by-Step

Aug 23, 2023 by Didier Joomun

This tutorial will teach you how to create a user in PostgreSQL and install a PostgreSQL server on Ubuntu using Docker.

PostgreSQL

How to Secure Your PostgreSQL Server?

Mar 1, 2023 by Winnie Ondara

Learn different measures that you can implement to fortify the security of the PostgreSQL server and establish a safeguard against potential breaches.

PostgreSQL

How to Set Up ZFS File System for PostgreSQL on Ubuntu 22.04?

Dec 12, 2022 by Mantas Levinas

Learn how to use ZFS with PostgreSQL to build a performant and easily scalable database that is a much cheaper alternative to managed cloud database services

PostgreSQL

How to Configure SSL on PostgreSQL

Oct 31, 2022 by Mantas Levinas

PostgreSQL supports SSL connections to ensure that client-server communication stays encrypted and safe. Learn how to use SSL encryption for your database.

PostgreSQL

How to Set up PostgreSQL Database Replication

Oct 10, 2022 by Mantas Levinas

Database replication is a process of copying data from a central server to multiple servers known as replicas. Learn how to replicate a PostgreSQL database.

PostgreSQL

How to Install and Setup PostgreSQL on Ubuntu 20.04 | Step-by-Step

Oct 8, 2021 by Mantas Levinas

Learn how to install, setup and start using PostgreSQL server - a fully-featured database management system (DBMS) - on Ubuntu 20.04