From: | "Krishna R Palati" <krishna(at)hedgehoghosting(dot)com> |
---|---|
To: | "'Bruno Wolff III'" <bruno(at)wolff(dot)to> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Hot backup |
Date: | 2004-06-01 14:55:26 |
Message-ID: | 200406011455.i51EtUXg093018@mx1.hedgehoghosting.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)wolff(dot)to]
Sent: Monday, May 31, 2004 5:15 AM
To: Krishna R Palati
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Hot backup
On Wed, May 26, 2004 at 10:50:21 -0400,
Krishna R Palati <krishna(at)hedgehoghosting(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | David Parker | 2004-06-01 15:35:22 | Error running initdb |
Previous Message | Bill Montgomery | 2004-06-01 14:46:52 | Re: Database stat generation |