| 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: | Whole Thread | Raw Message | 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
| 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 |