In this post, I am going to create three postgreSQL instance on the same host. I can not seem to find right twiki for how to do it therefore I create this article in case if other people may want to do the same.
Install Centos 7
use ip addr to check the networking
Post configuration for Centos 7
I encounter the issue for install the vmware-tools. It seems to be the issue on the VMWare-tools that can not work in the Centos7 but I can not find the solutions.
Add user : postsqldba and create .screenrc
Login as postsqldba. Here is my .screenrc
Install PostgreSQL 9.3
The yum repository does not have the latest postgre 9.3. Therefore we have to manually install from postgresql.org.
Post install : initdb
Create service file
create /etc/systemd/system/postgresql-*.service for each instance.
Register new instance with systemctl