Re: after using pg_resetxlog, db lost

From: zhicheng wang <wang_zc(at)yahoo(dot)co(dot)uk>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: after using pg_resetxlog, db lost
Date: 2004-06-01 12:53:22
Message-ID: 20040601125322.41298.qmail@web51006.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

following my last email:

disk only 50% used

cheng

--- Richard Huxton <dev(at)archonet(dot)com> wrote: >
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

=====
Best wishes
Z C Wang




____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message btober 2004-06-01 13:05:56 Re: confused by superuser-definition
Previous Message zhicheng wang 2004-06-01 12:49:36 Re: after using pg_resetxlog, db lost