Hello, Thanks for the reply. Pg_dump might provide consistent dump at that point of time. But my question is:
We can setup pg_dump everyday at 3AM. Suppose a crash occurs at 10PM. Is there a way in Postgres for us to use the dump file from 3AM and the transaction logs since then so that we can do a point in time recovery (to recover everything till 10PM) ? With pg_dump as I understand, we can recover only from the dump made at 3AM. So we will be losing every transaction on the db which is done between pg_dumps. Thanks again for your time. -Krishna. -----Original Message----- From: Bruno Wolff III [mailto:[EMAIL PROTECTED] Sent: Monday, May 31, 2004 5:15 AM To: Krishna R Palati Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Hot backup On Wed, May 26, 2004 at 10:50:21 -0400, Krishna R Palati <[EMAIL PROTECTED]> wrote: > > I read online that Postgres 7.4.1 has the capability to do hotbackups > (equivalent to Hotbackups on Oracle). But am not able to find any > documentation which will help me set up one. Can you please point me to a > resource that I can use to set up hotbackups for Postgres 7.4.1 ? pg_dump and pg_dumpall provide consistant dumps of the database. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
