PostgreSQL Setup – Configuration
My friend wanted to setup PostGreSQL with Replication. (Master / Slave Setup). So I agreed to help him out.
Since I have not done anything on PostgreSQL before, so though to document it as I go.
- Setting up two virtual machines (MASTER / SLAVE).
- Getting both the VMs to have postgreSQL 9.1 installed and configured.
Master : 172.16.167.130
Slave : 172.16.167.129
Now lets install PostgreSQL 9.1 on Ubuntu 11.10 (MASTER / SLAVE)
ahmed@ahmed-work-horse:~$ sudo apt-get install pgadmin3
#listen_addresses = ‘localhost’
listen_addresses = ‘<your_ip_address>’
Next Lets change the pg_hba.conf file.
ahmed@ubuntu:~$ sudo vim /etc/postgresql/9.1/main/pg_hba.conf
Add these as required lines in the IPv4 Section.
This will allow IP 172.16.167.129 to access 172.16.167.130 (on Master)
host all all 127.0.0.1/32 md5
host all all 172.16.167.129/32 md5
host all all 172.16.167.130/32 md5
Now lets check our connection.
ahmed@ubuntu:~$ pgadmin3 &
This will bring up the pgadmin interface.
Follow the images below to check connection.
Replication, I will add once I have completed that.(In Progress)