Re: Postgres file structure doubt

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: mailtolouis2020-postgres(at)yahoo(dot)com
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres file structure doubt
Date: 2007-11-20 17:00:22
Message-ID: 1195578022.4217.274.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2007-11-20 at 08:38 -0800, mailtolouis2020-postgres(at)yahoo(dot)com
wrote:
>
> For e.g, if I did a pg_dump backup a week ago, and the system crash
> today, but I'm able to get all the files
> in /usr/local/pgsql/data/pg_xlog, can I still recover my database to
> the latest state?

No, pg_dump never allows any form of Point in Time Recovery.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-11-20 17:13:37 Re: PostgreSQL Conference 08 East!
Previous Message mailtolouis2020-postgres 2007-11-20 16:38:18 Re: Postgres file structure doubt