Postgres Pro
Downloads
Home   >   mailing lists

Re: after using pg_resetxlog, db lost - Mailing list pgsql-general

From Richard Huxton
Subject Re: after using pg_resetxlog, db lost
Date
Msg-id 40BC7970.3000500@archonet.com
Whole thread Raw
In response to after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Responses Re: after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Re: after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
List pgsql-general
Tree view 
zhicheng wang wrote:
> dear all
> after we shutdown the rh_postgres-server 7.3.6, rhdb
> could not start. we tried
>
> pg_resetxlog -f PGDATA
>
> then the server can be started, but only template0 and
> template1 db available.
>
> our database not listed.

Was there a crash?
What do your logs say?
How much disk space does your /data/base directory use and is that
enough for your data?
Do you have your backups available?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Levan, Jerry"
Date:
Subject: Running Totals and other stuff....
Next
From: zhicheng wang
Date:
Subject: Re: after using pg_resetxlog, db lost