Cherry Servers

PostgreSQL

Explore PostgreSQL tutorials and guides to build secure systems with persistent storage. Learn everything from installation to advanced database management.

Articles on this topic

PostgreSQL
How to install PostgreSQL on Ubuntu 24.04 LTS

How to install PostgreSQL on Ubuntu 24.04 LTS

Oct 24, 2024 by Oltjano Terpollari

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.

PostgreSQL
How to Create a Superuser in Postgres?

How to Create a Superuser in Postgres?

Feb 25, 2024 by Winnie Ondara

This tutorial demonstrates how to create a superuser in PostgreSQL and briefly explains what a Postgres superuser is.

PostgreSQL
How to Create a Database in PostgreSQL [CREATE DATABASE, createdb]

How to Create a Database in PostgreSQL [CREATE DATABASE, createdb]

Jan 16, 2024 by Winnie Ondara

This step-by-step tutorial demonstrates how to create a database in PostgreSQL, using CREATE DATABASE or createdb command.

PostgreSQL
How to Install PostgreSQL on Ubuntu 22.04 | 4 Steps

How to Install PostgreSQL on Ubuntu 22.04 | 4 Steps

Dec 22, 2023 by Winnie Ondara

This step-by-step tutorial demonstrates how to install PostgreSQL on Ubuntu 22.04, including how to create a new database and tables.

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

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

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?

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?

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

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.

We use cookies to ensure seamless user experience for our website. Required cookies - technical, functional and analytical - are set automatically. Please accept the use of targeted cookies to ensure the best marketing experience for your user journey. You may revoke your consent at any time through our Cookie Policy.
build: b0376f5bd.760