Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-admin by date

Next:From: Yiqun LinDate: 2004-09-14 15:38:48
Subject: adduser postgres
Previous:From: AminDate: 2004-09-14 13:27:16
Subject: Re: pg_class / missing tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group