Difference between revisions of "Pg ctl - Single Directory Postgres"
Jump to navigation
Jump to search
Line 2: | Line 2: | ||
- https://www.enterprisedb.com/download-postgresql-binaries | - https://www.enterprisedb.com/download-postgresql-binaries | ||
- https://sbp.enterprisedb.com/getfile.jsp?fileid=1257664&_ga=2.199661166.1318609253.1625964422-1196070153.1625964422 | - 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 | # Run |
Revision as of 01:47, 11 July 2021
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