administration

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.

Continue reading

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.

Continue reading

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.

Continue reading

PostgreSQL Tutorial: PostgreSQL Administration

The PostgreSQL administration covers the most important PostgreSQL database server administration activities.

Continue reading

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.

Continue reading

PostgreSQL Tutorial: Check PostgreSQL Version

Summary: in this tutorial, you will learn various ways to check the PostgreSQL version on your system.

Continue reading

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.

Continue reading

pg_squeeze: Shrinks tables better than VACUUM

Summary: pg_squeeze is an PostgreSQL extension that automatically fixes table bloat without extensive table locking.

Continue reading

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.

Continue reading

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.

Continue reading