Re: [GENERAL] Hot Backup

From: "Sandeep Chadha" <sandeep(at)newnetco(dot)com>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, <shridhar_daithankar(at)persistent(dot)co(dot)in>
Cc: <pgsql-hackers(at)postgresql(dot)org>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Hot Backup
Date: 2002-10-09 13:42:56
Message-ID: 4AFE42D73ED1F345A576D3290FF8421C17674D@exchange.nnco.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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(at)candle(dot)pha(dot)pa(dot)us]
Sent: Tuesday, October 08, 2002 8:27 PM
To: shridhar_daithankar(at)persistent(dot)co(dot)in
Cc: pgsql-hackers(at)postgresql(dot)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(at)newnetco(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff MacDonald 2002-10-09 14:41:49
Previous Message Shridhar Daithankar 2002-10-09 13:41:09 Re: [pgsql-performance] Large databases, performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-10-09 14:14:54 Re: pgsql 7.2.3 crash
Previous Message Shridhar Daithankar 2002-10-09 13:41:09 Re: [pgsql-performance] Large databases, performance