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.
PostgreSQL Tutorial: Check PostgreSQL Version
Summary: in this tutorial, you will learn various ways to check the PostgreSQL version on your system.
PostgreSQL Tutorial: Restart PostgreSQL on Ubuntu
Summary: in this tutorial, you will learn how to restart PostgreSQL on Ubuntu using systemctl, service command, and pg_ctl command.
pg_squeeze: Shrinks tables better than VACUUM
Summary: pg_squeeze is an PostgreSQL extension that automatically fixes table bloat without extensive table locking.
PG Collector: SQL script for PostgreSQL health inspection
Summary: PG Collector for PostgreSQL is a sql script that gathers valuable database information, and presents it in a consolidated HTML file which provides a convenient way to view and navigate between different sections of the report.
pg_auto_failover: PostgreSQL automated failover and high availability
Summary: The pg_auto_failover is a PostgreSQL extension and service for automated failover and high availability.