Re: Serious trouble with my postgresql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mário Gamito <gamito(at)netual(dot)pt>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Serious trouble with my postgresql
Date: 2004-09-14 14:31:37
Message-ID: 7000.1095172297@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

=?ISO-8859-1?Q?M=E1rio_Gamito?= <gamito(at)netual(dot)pt> writes:
> Meanwhile, i guess i've screwed up :( and erased two files with 0 bytes,
> something like 0000000000000001, i can't remember quite well.

That was a bad move. Start over, and next time don't assume that you
can remove random pieces of the database without consequence.

(You could possibly try pg_resetxlog, but given that you were having
problems before you did that, I wouldn't care to assume that you'll get
a consistent database that way.)

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Yiqun Lin 2004-09-14 15:38:48 adduser postgres
Previous Message Amin 2004-09-14 13:27:16 Re: pg_class / missing tables