Pg ctl - Single Directory Postgres
Jump to navigation
Jump to search
Download Binaries
- https://www.enterprisedb.com/download-postgresql-binaries
- https://sbp.enterprisedb.com/getfile.jsp?fileid=1257664&_ga=2.199661166.1318609253.1625964422-1196070153.1625964422
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