Articles on this topic
How to install PostgreSQL on Ubuntu 24.04 LTS
Learn how to install PostgreSQL 16 on Ubuntu 24.04 LTS, configure users and databases, manage permissions, and interact with your database using psql, pgAdmin, and Python.
Read More
How to Create a Superuser in Postgres?
This tutorial demonstrates how to create a superuser in PostgreSQL and briefly explains what a Postgres superuser is.
Read More
How to Create a Database in PostgreSQL [CREATE DATABASE, createdb]
This step-by-step tutorial demonstrates how to create a database in PostgreSQL, using CREATE DATABASE or createdb command.
Read More
How to Install PostgreSQL on Ubuntu 22.04 | 4 Steps
This step-by-step tutorial demonstrates how to install PostgreSQL on Ubuntu 22.04, including how to create a new database and tables.
Read More
How to Create a Stored Procedure in PostgreSQL | Step-by-Step
In this tutorial, we will first explain what a PostgreSQL stored procedure is and then show how to create and list stored procedures.
Read More
How to Create a User in PostgreSQL | Step-by-Step
This tutorial will teach you how to create a user in PostgreSQL and install a PostgreSQL server on Ubuntu using Docker.
Read More
How to Secure Your PostgreSQL Server?
Learn different measures that you can implement to fortify the security of the PostgreSQL server and establish a safeguard against potential breaches.
Read More
How to Set Up ZFS File System for PostgreSQL on Ubuntu 22.04?
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
Read More
How to Configure SSL on PostgreSQL
PostgreSQL supports SSL connections to ensure that client-server communication stays encrypted and safe. Learn how to use SSL encryption for your database.
Read More