PostgreSQL 15 – Move Data Directory

PostgreSQL

The Postgres data directory, sometimes known by the environment variable $PGDATA that references it is the heart of your database cluster installation. We as Database Administrators should never touch files within the data directory (with very few exceptions), as we could harm the integrity of the database software or completely destroy the database itself. That

Read More

PostgreSQL – Enable Remote Connections

PostgreSQL

By default, PostgreSQL server does not allow inbound connections over default port 5432. This means that only connections from the local machine can connect to the database. The following steps can be used to enable clients to connect over the network to PostgreSQL. Hope this helps,Dustin

Read More