Pg ctl - Single Directory Postgres

From UVOO Tech Wiki
Revision as of 01:38, 11 July 2021 by Busk (talk | contribs)
Jump to navigation Jump to search

Download Binaries

Run

sudo -u postgres mkdir /pg
cd /pg
sudo -u postgres /usr/lib/postgresql/12/bin/pg_ctl -D busk init
sudo -u postgres /usr/lib/postgresql/12/bin/pg_ctl -D busk -l logfile start -o "-F -p 5433"
psql -U postgres -h 127.0.0.1 -p 5433
pg_dumpall -U postgres -h 127.0.0.1 -p 5433