Cherry Servers

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 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.

PostgreSQL
How to Set up PostgreSQL Database Replication

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.

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: c9898541.721