From: | "Faber J(dot) Fedor" <faber(at)linuxnj(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Warm/hot backup server question |
Date: | 2007-10-07 20:22:55 |
Message-ID: | 20071007202255.GB30292@neptune.faber.nom |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I've been given the job of creating a hot/warm backup server
for a live Postgresql server. The problem is two-fold: 1) it's version
7.4.9 and an upgrade is not feasible at this time and b) there are
multiple instances of postgresql running on the box; not multiple
databases, multiple *servers*, each listening on a different port (it
was a business requirement from what I've been told).
I plan on using heartbeat and mon to monitor the primary server for
non-availability and fail over.
I thought about DRBD, but that would require repartitioning the live
server and I want to touch it as little as possible.
I've read the docs for WAL and the 8.2 version sounds perfect for what
I want but, as I said, an upgrade is out of the question for now. I
see that 7.4 has WAL, but I didn't see mention of the warm backups as
mentioned in the 8.2 docs. Can 7.4 do the same magic as 8.2 wrt to
WAL?
Is SLONY/replication my only choice? Remember, I can't/don't want to
rebuild the existing servers.
TIA!
--
Regards,
Faber Fedor
President
Linux New Jersey, Inc.
908-320-0357
800-706-0701
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Mike C | 2007-10-07 21:47:49 | Database Recovery |
Previous Message | Faber Fedor | 2007-10-07 16:37:00 | warm/hot backup of Postgresql |