On Tue, 2007-11-20 at 08:38 -0800, [EMAIL PROTECTED]
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
ROTECTED]>
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Monday, November 19, 2007 5:38:12 PM
Subject: Re: [GENERAL] Postgres file structure doubt
On Nov 19, 2007 11:24 AM, <[EMAIL PROTECTED]> wrote:
>
> Hi everyone,
>
> Got a doubt in my setup, please correct m
On Nov 19, 2007 11:24 AM, <[EMAIL PROTECTED]> wrote:
>
> Hi everyone,
>
> Got a doubt in my setup, please correct me if I'm wrong.
>
> In my postgres setup,
> /usr/local/pgsql (where postgres install)
> /usr/local/pgsql/data (PGDATA)
> /database/pg/mydata (tablespace which use for all the table I
Hi everyone,
Got a doubt in my setup, please correct me if I'm wrong.
In my postgres setup,
/usr/local/pgsql (where postgres install)
/usr/local/pgsql/data (PGDATA)
/database/pg/mydata (tablespace which use for all the table I create)
/database/pg/myindex (index which use for all the table I cre
