Home > How To > PostgreSQL Setup – Configuration

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.

First in this blog post, I will just cover.

  • Setting up two virtual machines (MASTER / SLAVE).
  • Getting both the VMs to have postgreSQL 9.1 installed and configured.
Information about the VM Machines
Master : 172.16.167.130
Slave : 172.16.167.129
Now Lets Start.

First, Lets setup VMWare setup to.
Installing VMware Player on Ubuntu 11.10.
Install required packages build-essential and linux-headers
sudo apt-get install build-essential linux-headers-$(uname -r)
Download the latest VMware player and execute below command.
$ gksudo bash ~/Downloads/VMware-Player-3.1.4-385536.i386.bundle
This will bring up the installer interface and you can continue after that.
Note: this assumes the location of your Downloads folder is ~/Downloads.


Now lets install PostgreSQL 9.1 on Ubuntu 11.10 (MASTER / SLAVE)
Lets Install PostgreSQL 9.1
ahmed@ahmed-work-horse:~$ sudo apt-get install postgresql-9.1*
This will install all the required components


ahmed@ahmed-work-horse:~$ sudo apt-get install pgadmin3
This is required for admin console.
Once we have done installing lets configure the Server.
ahmed@ubuntu:~$ sudo vim /etc/postgresql/9.1/main/postgresql.conf
In the file change (# is commented)
#listen_addresses = ‘localhost’
to this (uncomment) – for MASTER is ‘172.16.167.130’ SLAVE is ‘172.16.167.129’
listen_addresses = ‘172.16.167.130’
or
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)

This will allow IP 172.16.167.130 to access 172.16.167.129 (on Slave)
# IPv4 local connections:
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)

Advertisements
Categories: How To
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: