Re: Postgres file structure doubt - Mailing list pgsql-general

From Simon Riggs
Subject Re: Postgres file structure doubt
Date
Msg-id 1195578022.4217.274.camel@ebony.site
Whole thread Raw
In response to Re: Postgres file structure doubt  (mailtolouis2020-postgres@yahoo.com)
List pgsql-general
On Tue, 2007-11-20 at 08:38 -0800, mailtolouis2020-postgres@yahoo.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


pgsql-general by date:

Previous
From: mailtolouis2020-postgres@yahoo.com
Date:
Subject: Re: Postgres file structure doubt
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [pgsql-advocacy] PostgreSQL Conference 08 East!