Re: Serious trouble with my postgresql - Mailing list pgsql-admin

From Tom Lane
Subject Re: Serious trouble with my postgresql
Date
Msg-id 7000.1095172297@sss.pgh.pa.us
Whole thread Raw
In response to Serious trouble with my postgresql  (Mário Gamito <gamito@netual.pt>)
List pgsql-admin
=?ISO-8859-1?Q?M=E1rio_Gamito?= <gamito@netual.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

pgsql-admin by date:

Previous
From: "Amin"
Date:
Subject: Re: pg_class / missing tables
Next
From: "Lee Wu"
Date:
Subject: Re: pg_class / missing tables