pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
warm/hot backup of Postgresql
2+ messages / 2 participants
[nested] [flat]

* warm/hot backup of Postgresql
@ 2007-10-07 16:37  Faber Fedor <faber@linuxnj.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Faber Fedor @ 2007-10-07 16:37 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I've been tasked with the problem of creating hot/warm backup server
of 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!

--

Faber



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: warm/hot backup of Postgresql
@ 2007-10-10 15:09  Decibel! <decibel@decibel.org>
  parent: Faber Fedor <faber@linuxnj.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Decibel! @ 2007-10-10 15:09 UTC (permalink / raw)
  To: Faber Fedor <faber@linuxnj.com>; +Cc: pgsql-admin

On Oct 7, 2007, at 11:37 AM, Faber Fedor wrote:
> Is SLONY/replication my only choice?  Remember, I can't/don't want to
> rebuild the existing servers.

Slony is. As an added benefit, it will allow you to perform a  
migration with effectively zero downtime.
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-10-10 15:09 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-07 16:37 warm/hot backup of Postgresql Faber Fedor <faber@linuxnj.com>
2007-10-10 15:09 ` Decibel! <decibel@decibel.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox