Pg ctl - Single Directory Postgres

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

Download Binaries

Download and init from binaries on Linux

curl --output pgsql.tar.gz -L https://sbp.enterprisedb.com/getfile.jsp?fileid=1257664&_ga=2.131528655.1318609253.1625964422-1196070153.1625964422
tar xf pgsql.tar.gz
sudo mkdir /pg2
cp -rp pgsql /pg2/
sudo chown -R postgres:postgres /pg2
cd /pg2
sudo -u postgres pgsql/bin/pg_ctl -D busk init
sudo -u postgres pgsql/bin/pg_ctl -D busk -l logfile start -o "-F -p 5434"
pgsql/bin/pg_dumpall -U postgres -h 127.0.0.1 -p 5434
pgsql/bin/psql -U postgres -h 127.0.0.1 -p 5434

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