PostgreSQL Multi-instance run

Create a new instance, (the 9.1 version used below, if it is a different version, you can replace 9.1 with the version number)

sudo/usr/bin/Pg_createcluster

-U postgres # #系统用户

-D/VAR/LIB/POSTGRESQL/9.1/D1 # #实例目录, version

-S/VAR/RUN/PGD1 # #

--local ZH_CN. UTF-8

-E UTF8 #

-P 5433 #端口

--start--start-conf Auto 9.1 #默认加入到pg的启动服务, service PostgreSQL start-or-stop will start or close all instances

PgD1 #实例名字

After the instance is created,pg_lsclusters to view the newly created instance details

When using Psql to link an instance, psql-h/var/run/pgd1-p 5433 Specifies the database port path (-S line selection in Pg_createcluster ) and the port number.

Close or open the instance separately Pg_ctlcluster 9.1 pgD1 Start|stop|restart.