On 04/18/2011 04:01 PM, Adarsh Sharma wrote:

Thanks Chetan,

The problem is solved by the below command :-:-)

[postgres@ws-test 8.4SS]$ bin/pg_resetxlog -f /hdd-1/PostgresPlus/8.4SS/data

It's a really good idea to pg_dump, initdb, and restore after doing that. You don't know your database is in a good state.

--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to