Pgsql_use

Refer to : https://shecannotsee.github.io/postgresql14-1%E5%9C%A8ubuntu%E4%B8%8B%E7%9A%84%E7%BC%96%E8%AF%91%E4%B8%8E%E5%AE%89%E8%A3%85.html

download

# get source code from : https://www.postgresql.org/ftp/source/
# The selected version is: 11.13 or 14.1

build and install

before configure and make

$ sudo apt install libreadline-dev
$ sudo apt-get install zlib1g-dev
$ sudo apt-get install bison
$ sudo apt-get install flex

common build

$ cd postgresql-14.1/
$ mkdir build
$ cd build
# ${install_path} means install path
$ ../configure --prefix=${install_path}
$ make -j8
$ make install

libpq,Client-only installation

$ make -C src/bin install
$ make -C src/include install
$ make -C src/interfaces install
$ make -C doc install

start to use

0.init

Using initdb in the generated bin to init data store

# ${install_path} means install path
$ ${install_path}/bin/initdb \
	-D ${install_path}/data_store

1.start and stop

start

# ${install_path} means install path
# -l: set log file
# -d: set store dir
$ ${install_path}/bin/pg_ctl \
	start \
	-l ${install_path}/log/log.log \
	-D ${install_path}/data_store

stop

# ${install_path} means install path
$ kill -INT `head -1 ${install_path}/data_store/postmaster.pid`

2.other use

create db

# ${install_path} means install path
# ${dbname} means db name
$ ${install_path}/bin/createdb ${dbname}