Difference between revisions of "Pg ctl - Single Directory Postgres"

From UVOO Tech Wiki
Jump to navigation Jump to search
(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...")
 
Line 1: Line 1:
 +
# Download Binaries
 +
- https://www.enterprisedb.com/download-postgresql-binaries
 +
- https://sbp.enterprisedb.com/getfile.jsp?fileid=1257664&_ga=2.199661166.1318609253.1625964422-1196070153.1625964422
 +
 +
# Run
 
```
 
```
 
sudo -u postgres mkdir /pg
 
sudo -u postgres mkdir /pg

Revision as of 01:38, 11 July 2021

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