Re: Hot backup

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:bruno@wolff.to]
Sent: Monday, May 31, 2004 5:15 AM
To: Krishna R Palati
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Hot backup

On Wed, May 26, 2004 at 10:50:21 -0400,
  Krishna R Palati <krishna@hedgehoghosting.com> 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.