Pg ctl - Single Directory Postgres - Revision history

Busk at 16:57, 11 July 2021

2021-07-11T16:57:40Z

Busk at 02:54, 11 July 2021

2021-07-11T02:54:22Z

Busk at 02:16, 11 July 2021

2021-07-11T02:16:03Z

Busk at 01:58, 11 July 2021

2021-07-11T01:58:53Z

Busk at 01:57, 11 July 2021

2021-07-11T01:57:04Z

Busk at 01:47, 11 July 2021

2021-07-11T01:47:04Z

Busk at 01:38, 11 July 2021

2021-07-11T01:38:07Z

Busk: 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..."

2021-07-11T01:25:55Z

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..."

New page

```
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
```

@@ Line 4: / Line 4: @@
 - https://www.postgresql.org/ftp/source/v13.3/
 - https://wiki.postgresql.org/wiki/Compile_and_Install_from_source_code
 ```
-sudo apt-get install build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt-dev libssl-dev libxml2-utils xsltproc
+download(){
-curl -LO https://ftp.postgresql.org/pub/source/v13.3/postgresql-13.3.tar.gz
+  sudo apt-get install build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt-dev libssl-dev libxml2-utils xsltproc
-tar xf postgresql-13.3.tar.gz
+  curl -LO https://ftp.postgresql.org/pub/source/v13.3/postgresql-13.3.tar.gz
-cd postgresql-13.3/
+  tar xf postgresql-13.3.tar.gz
-    ./configure
+  install_prefix=/pgtest1/pgsql
-    make
+  mkdir -p $install_prefix
-    su
-    make install
-    adduser postgres
+compile(){
-    mkdir /usr/local/pgsql/data
+  ./configure
-    chown postgres /usr/local/pgsql/data
+  make
-    su - postgres
-    /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
-    /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
+install(){
-    /usr/local/pgsql/bin/createdb test
+  su
-    /usr/local/pgsql/bin/psql test
+  make install prefix=$install_prefix
 ```

@@ Line 3: / Line 3: @@
 or source
 - https://www.postgresql.org/ftp/source/v13.3/
 ```
 curl -LO https://ftp.postgresql.org/pub/source/v13.3/postgresql-13.3.tar.gz
 tar xf postgresql-13.3.tar.gz

@@ Line 4: / Line 4: @@
 - https://www.postgresql.org/ftp/source/v13.3/
 ```
      ./configure
      make

@@ 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
+or source
 # Download and init from binaries on Linux

@@ Line 2: / Line 2: @@
 - https://www.enterprisedb.com/download-postgresql-binaries
 - https://sbp.enterprisedb.com/getfile.jsp?fileid=1257664&_ga=2.199661166.1318609253.1625964422-1196070153.1625964422
 # Run

@@ Line 76: / Line 76: @@
 psql -U postgres -h 127.0.0.1 -p 5433
 pg_dumpall -U postgres -h 127.0.0.1 -p 5433
 ```

← Older revision		Revision as of 01:38, 11 July 2021
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