Replication Across Two Servers?

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Replication Across Two Servers?
Date: 2011-11-04 15:47:00
Message-ID: CAAQLLO7d6hk-qaOXb8Dk=9AONZMJj_=JVb9rm_+-CPo4stQ3YA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We had a 8.4.8 production server of PostgreSQL on a Dell blade server
which ran for 3 years fine. The server housed all our database needs
perfectly but sadly the entire machine died. The drives were dead and
the motherboard was fried but we did have daily full backups of the
entire machine. Today I received our new blade servers which will run
VMware & I get to create two new PostgreSQL servers. I wanted to make
a master database server and a slave in case the master dies. My
question is does PostgreSQL 8.4 or 9.1support synchronization between
two physical machines over Ethernet? I've never replicated any kind of
database before so I don't know if that's possible and the more I
search this on my own, the more confused I am. It appears in
PostgreSQL, the word "replication" has several different meanings.

If you had to stand up two individual Debian Linux servers running a
specific version of PostgreSQL, could / would you be able to have the
master also synchronize all data to a slave server?

Thanks for any info!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Phelps 2011-11-04 15:52:36 Re: Replication Across Two Servers?
Previous Message Hannes Erven 2011-11-04 15:46:15 Re: 9.1 replication on different arch