Pg ctl - Single Directory Postgres

From UVOO Tech Wiki
Revision as of 01:25, 11 July 2021 by Busk (talk | contribs) (Created page with "``` 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 sta...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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