Sign inSign up

toshelp/postgresql_playground

By toshelp

•Updated almost 6 years ago

Image
0

186

toshelp/postgresql_playground repository overview

⁠PostgreSQL build & playground environment

⁠PostgreSQL version

13.0

⁠Step1: pull & exec /bin/bash

$ docker run -it --name pgplayground toshelp/postgresql_playground /bin/bash

⁠Step2: configure, make, make install.

sudo password is "postgres"

postgres@postgres:~$ mkdir build
postgres@postgres:~$ cd build
postgres@postgres:~/build$ ../postgresql-13.0/configure
postgres@postgres:~/build$ make
postgres@postgres:~/build$ sudo make install

⁠Step3: prepare PostgreSQL

postgres@postgres:~/build$ export PATH=$PATH:/usr/local/pgsql/bin/
postgres@postgres:~/build$ export PGDATABASE=postgres
postgres@postgres:~/build$ export PGDATA=$HOME/data
postgres@postgres:~/build$ initdb --encoding=UTF8 --no-locale

⁠Step4: start PostgreSQL & connect

postgres@postgres:~/build$ pg_ctl -D /home/postgres/data -l logfile start
postgres@postgres:~/build$ psql

Tag summary

Content type

Image

Digest

Size

205 MB

Last updated

almost 6 years ago

docker pull toshelp/postgresql_playground