Thread: Re: [GENERAL] Hot Backup

Re: [GENERAL] Hot Backup

From
"Sandeep Chadha"
Date:
I'd say yes replication can solve lot of issues, but is there a way to do replication in postgres(active-active or
active-passive)

-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Tuesday, October 08, 2002 8:27 PM
To: shridhar_daithankar@persistent.co.in
Cc: pgsql-hackers@postgresql.org; pgsql-general
Subject: Re: [GENERAL] [HACKERS] Hot Backup


Shridhar Daithankar wrote:
> On 7 Oct 2002 at 13:48, Neil Conway wrote:
>
> > "Sandeep Chadha" <sandeep@newnetco.com> writes:
> > > Postgresql has been lacking this all along. I've installed postgres
> > > 7.3b2 and still don't see any archive's flushed to any other
> > > place. Please let me know how is hot backup procedure implemented in
> > > current 7.3 beta(2) release.
> > AFAIK no such hot backup feature has been implemented for 7.3 -- you
> > appear to have been misinformed.
>
> Is replication an answer to hot backup?

We already allow hot backups using pg_dump.  If you mean point-in-time
recovery, we have a patch for that ready for 7.4.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073 

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


Re: [GENERAL] Hot Backup

From
Andrew Sullivan
Date:
On Wed, Oct 09, 2002 at 09:42:56AM -0400, Sandeep Chadha wrote:
> I'd say yes replication can solve lot of issues, but is there a way
> to do replication in postgres(active-active or active-passive)

Yes.  Check out the rserv code in contrib/, the (?) dbmirror code in
contrib/, or contact PostgreSQL, Inc for a commercial version of the
rserv code.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110