Re: after using pg_resetxlog, db lost

From: Richard Huxton <dev(at)archonet(dot)com>
To: wang_zc(at)yahoo(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: after using pg_resetxlog, db lost
Date: 2004-06-01 12:41:20
Message-ID: 40BC7970.3000500@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stijn Vanroye 2004-06-01 12:47:19 Re: Large table search question[Scanned]
Previous Message Levan, Jerry 2004-06-01 12:40:19 Running Totals and other stuff....