Re: [GENERAL] Hot Backup - Mailing list pgsql-hackers

From Sandeep Chadha
Subject Re: [GENERAL] Hot Backup
Date
Msg-id 4AFE42D73ED1F345A576D3290FF8421C17674D@exchange.nnco.net
Whole thread Raw
Responses Re: [GENERAL] Hot Backup  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: [pgsql-performance] [GENERAL] Large databases, performance
Next
From: Tom Lane
Date:
Subject: Re: pgsql 7.2.3 crash