Installing postgresql

dnf install postgresql

dnf install postgresql-server

Enable postgres service

systemctl enable postgresql.service

Initialize postgresql Files

postgresql-setup initdb

Setup postgresql

Set METHOD of address 127.0.0.1 and ::1 to trust at the pg_hba.conf file...

Install PostgreSQL on AlmaLinux 9

Step 1 – Install

dnf install -y postgresql-server postgresql-contrib
postgresql-setup --initdb
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER appuser WITH PASSWORD 'Stro...

Install PostgreSQL on Arch Linux

Step 1 – Install

pacman -S --noconfirm postgresql
sudo -u postgres initdb --locale=en_US.UTF-8 -E UTF8 -D /var/lib/postgres/data
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE...

Installing postgresql

yum install postgresql

yum install postgresql-server

Enable postgres service

systemctl enable postgresql.service

Initialize postgresql Files

postgresql-setup initdb

Setup postgresql

Set address 127.0.0.1 and ::1 to trust at the pg_hba.conf file.

File /...

Install PostgreSQL on Debian 12

Step 1 – Install

apt update && apt upgrade -y
apt install -y postgresql postgresql-contrib
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER appuser WITH PASSWORD 'StrongPass...

Install PostgreSQL on Gentoo Linux

Step 1 – Install

emerge --ask dev-db/postgresql
emerge --config dev-db/postgresql
rc-update add postgresql-14 default && rc-service postgresql-14 start

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER app...

Install PostgreSQL on NetBSD 10

Step 1 – Install

pkgin install postgresql16-server postgresql16-client
su -l pgsql -c 'initdb -D /usr/pkg/pgsql/data'
echo 'pgsql=YES' >> /etc/rc.conf && service postgresql start

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database an

Install PostgreSQL on OpenBSD 7.5

Step 1 – Install

pkg_add postgresql-server
su -l _postgresql -c 'initdb -D /var/postgresql/data -U postgres -A md5 -W'
rcctl enable postgresql && rcctl start postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

Install PostgreSQL on RHEL 9

Step 1 – Install

dnf install -y postgresql-server postgresql-contrib
postgresql-setup --initdb
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER appuser WITH PASSWORD 'StrongPas...

Install PostgreSQL on Ubuntu 24.04

Step 1 – Install

apt update && apt upgrade -y
apt install -y postgresql postgresql-contrib
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER appuser WITH PASSWORD 'StrongP...

PostgreSQL Backup and Restore on AlmaLinux 9

Logical – pg_dump

# Single database
sudo -u postgres pg_dump -Fc appdb > /backups/appdb_$(date +%F).dump

# All databases
sudo -u postgres pg_dumpall > /backups/all_$(date +%F).sql

Restore

sudo -u postgres pg_restore -d appdb /backups/appdb_2026-0...

PostgreSQL Backup and Restore on Arch Linux

Logical – pg_dump

# Single database
sudo -u postgres pg_dump -Fc appdb > /backups/appdb_$(date +%F).dump

# All databases
sudo -u postgres pg_dumpall > /backups/all_$(date +%F).sql

Restore

sudo -u postgres pg_restore -d appdb /backups/appdb_2026-05...

PostgreSQL Backup and Restore on Debian 12

Logical – pg_dump

# Single database
sudo -u postgres pg_dump -Fc appdb > /backups/appdb_$(date +%F).dump

# All databases
sudo -u postgres pg_dumpall > /backups/all_$(date +%F).sql

Restore

sudo -u postgres pg_restore -d appdb /backups/appdb_2026-05-...

PostgreSQL Backup and Restore on Gentoo Linux

Logical – pg_dump

# Single database
sudo -u postgres pg_dump -Fc appdb > /backups/appdb_$(date +%F).dump

# All databases
sudo -u postgres pg_dumpall > /backups/all_$(date +%F).sql

Restore

sudo -u postgres pg_restore -d appdb /backups/appdb_2026-...

PostgreSQL Backup and Restore on NetBSD 10

Logical – pg_dump

# Single database
sudo -u postgres pg_dump -Fc appdb > /backups/appdb_$(date +%F).dump

# All databases
sudo -u postgres pg_dumpall > /backups/all_$(date +%F).sql

Restore

sudo -u postgres pg_restore -d appdb /backups/appdb_2026-05-...

PostgreSQL Backup and Restore on OpenBSD 7.5

Logical – pg_dump

# Single database
sudo -u postgres pg_dump -Fc appdb > /backups/appdb_$(date +%F).dump

# All databases
sudo -u postgres pg_dumpall > /backups/all_$(date +%F).sql

Restore

sudo -u postgres pg_restore -d appdb /backups/appdb_2026-0...

PostgreSQL Backup and Restore on RHEL 9

Logical – pg_dump

# Single database
sudo -u postgres pg_dump -Fc appdb > /backups/appdb_$(date +%F).dump

# All databases
sudo -u postgres pg_dumpall > /backups/all_$(date +%F).sql

Restore

sudo -u postgres pg_restore -d appdb /backups/appdb_2026-05-07....

PostgreSQL Backup and Restore on Ubuntu 24.04

Logical – pg_dump

# Single database
sudo -u postgres pg_dump -Fc appdb > /backups/appdb_$(date +%F).dump

# All databases
sudo -u postgres pg_dumpall > /backups/all_$(date +%F).sql

Restore

sudo -u postgres pg_restore -d appdb /backups/appdb_2026-...

PostgreSQL Streaming Replication on AlmaLinux 9

Primary: 192.168.1.10   Standby: 192.168.1.11

Primary – /var/lib/pgsql/data/postgresql.conf

wal_level = replica
max_wal_senders = 5
wal_keep_size = 512MB
listen_addresses = '*'

/var/lib/pgsql/data/pg_hba.conf:

host replication replicator...

PostgreSQL Streaming Replication on Arch Linux

Primary: 192.168.1.10   Standby: 192.168.1.11

Primary – /var/lib/postgres/data/postgresql.conf

wal_level = replica
max_wal_senders = 5
wal_keep_size = 512MB
listen_addresses = '*'

/var/lib/postgres/data/pg_hba.conf:

host replication repli...

PostgreSQL Streaming Replication on Debian 12

Primary: 192.168.1.10   Standby: 192.168.1.11

Primary – /var/lib/postgres/data/postgresql.conf

wal_level = replica
max_wal_senders = 5
wal_keep_size = 512MB
listen_addresses = '*'

/var/lib/postgres/data/pg_hba.conf:

host replication replic...

PostgreSQL Streaming Replication on Gentoo Linux

Primary: 192.168.1.10   Standby: 192.168.1.11

Primary – /var/lib/postgres/data/postgresql.conf

wal_level = replica
max_wal_senders = 5
wal_keep_size = 512MB
listen_addresses = '*'

/var/lib/postgres/data/pg_hba.conf:

host replication rep...

PostgreSQL Streaming Replication on NetBSD 10

Primary: 192.168.1.10   Standby: 192.168.1.11

Primary – /var/lib/postgres/data/postgresql.conf

wal_level = replica
max_wal_senders = 5
wal_keep_size = 512MB
listen_addresses = '*'

/var/lib/postgres/data/pg_hba.conf:

host replication replic...

PostgreSQL Streaming Replication on OpenBSD 7.5

Primary: 192.168.1.10   Standby: 192.168.1.11

Primary – /var/lib/postgres/data/postgresql.conf

wal_level = replica
max_wal_senders = 5
wal_keep_size = 512MB
listen_addresses = '*'

/var/lib/postgres/data/pg_hba.conf:

host replication repl...