Tables and Indexes vs. HDD and SSD
Summary: In this article, we will learn how to choose storage devices for tables and indexes in PostgreSQL.
PostgreSQL Tutorial: PostgreSQL Administration
The PostgreSQL administration covers the most important PostgreSQL database server administration activities.
PostgreSQL Tutorial: Enable Data Checksums With Minimum Downtime
Summary: in this tutorial, you will learn how to enable data checksums with minimum downtime in PostgreSQL.
PostgreSQL Tutorial: Automatic failover using repmgr
Summary: In this tutorial, we will learn the open source tool repmgr (Replication Manager) and how to set up and configure it for automatic failover in PostgreSQL.
PostgreSQL Tutorial: Using pg_rewind to re-synchronize a demoted master
Summary: In this tutorial, we shall discuss how the old master that has diverged from the replication cluster can be added back to the cluster as a standby, without rebuilding it from scratch.
PostgreSQL Tutorial: Manage superusers
Summary: in this tutorial, you will learn about PostgreSQL superusers and how to create them using the CREATE ROLE statement.
PostgreSQL Tutorial: SET ROLE
Summary: in this tutorial, you will learn how to use the SET ROLE statement to temporarily change the current role within a database session.
pg-osc: Zero downtime schema changes in PostgreSQL
Summary: pg-osc is an easy command-line tool for making zero downtime schema changes and backfills in PostgreSQL.
PostgreSQL Tutorial: Altering a column with minimal downtime
Summary: in this tutorial, you will learn how to alter a column with minimal downtime in PostgreSQL.
PostgreSQL Tutorial: Restart PostgreSQL on Windows
Summary: in this tutorial, you will learn how to restart PostgreSQL on Windows using Service Manager, command line, and pg_ctl command.