On Mon, Oct 10, 2011 at 1:13 PM, Akash Kodibail <[email protected]> wrote: > I was hopeful of restoring the data from data files in $PGDATA path. I read > this article about PITR using the recovery.conf, But I am not aware of the > pre-requisites and not entirely sure about the concept beneath this.
With PITR you set up the system ahead of time to do this. It is not a rescue / recovery procedure for a broken database. I like Kevin fear that by starting it back up with an old pg_Controldata you may have made matters much worse, depending on what autovacuum might have done. Once you have a backup it's time to start experimenting, and I think pg_resetxlog is the best place to start. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
