RSSPostgreSQL 9.0.3 Binary Replication in Test Environment
Feb 23
PostgreSQL, Ubuntu PostgreSQL, Ubuntu 2 Comments
I need to deploy/implement the system for my client with heartbeat and database replication. So i decided to make a test environment with my lenovo thinkpad and HP workstation as (Master – Standby) before i do it to the live production server environment.
Btw, PostgreSQL in maverick right now does not come with the 9.0.3 packages. So i use Martin Pitt’s PPA , thanks for back porting the package for maverick.
$sudo apt-add-repository ppa:pitti/postgresql
$sudo apt-get update
$sudo apt-get install postgresql-9.0 postgresql-client-9.0 postgresql-contrib-9.0
Thanks to PostgreSQL community because they have build the wiki with a simple / less step to get it done. So U guys just follow this wiki after finish installing postgresql 9.0
Here are the result :
Database has been replicate to standby server
Nov 29, 2011 @ 11:17:25
Bro,
When you done with the replication and HA (heartbeat). Please share with the world on how you configure the solution. We would also like to know how is the output when you put all things together. Can the failover be done automatically (service auto start on the slave server) or does is still require human intervention. Are you using DRBD in this environment? Thank You.