Backup Postgre server

From: AnthonyV <avequeau(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Backup Postgre server
Date: 2009-11-23 11:19:17
Message-ID: b198f9fd-6e74-47a6-9b42-bbebd1dcabc0@r31g2000vbi.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a pg8.3 server (an 8.4 upgrade is scheduled) on Windows.
I would like an other pg server in backup in case of hardware problem
on my first server.

I use read/write queries and I would like the second pg become master
without any human intervention.

I saw Slony, but it seems that the backup server is a read-only server
which is not good for me.
I also saw pgpool. Is it a good solution for me? Does it work alone or
with Slony? Is a Windows version exist?

Finally, I saw others products like pgcluster or Bucardo, but I don't
understand the differences between all those products...

Can somebody help me? :)

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2009-11-23 12:11:53 Re: Backup Postgre server
Previous Message Alexandra Roy 2009-11-23 10:57:11 Re: DBD::Pg 2.15.1 compilation failed