From: | Janet S Jacobsen <JSJacobsen(at)lbl(dot)gov> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: "could not read block 0... " error followed by "database does not exist" |
Date: | 2010-02-13 18:58:10 |
Message-ID: | f26d778b4a41.4b7685c2@lbl.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks, Tom. I will give this a try and let you know what happens.
I don't see anything in the logfile prior to the first "could not read
block 0..." error.
Thanks,
Janet
Janet S Jacobsen <JSJacobsen(at)lbl(dot)gov> writes:
> > Hi. What I see when I do ls on the current (corrupt)
> > $PGDATA/global is
> > ...
> > - rw------- 1 jsjacobs deepsky 0 Feb 8 18:51 1262
> > ...
> > -rw------- 1 jsjacobs deepsky 602 Feb 12 17:42 pg_auth
> > -rw------- 1 jsjacobs deepsky 8192 Feb 12 17:42 pg_control
> > -rw------- 1 jsjacobs deepsky 0 Feb 12 17:42 pg_database
> > -rw------- 1 jsjacobs deepsky 10927 Feb 12 21:57 pgstat.stat
Looks about as I'd expect from your description. Something clobbered
1262, and then the "flat" file pg_database got updated from that.
You might want to look around at what was happening Feb 8 18:51.
> > I have a pgdump from a month ago. Are you saying to restore
> > that to a different location and then copy over
> > $PGDATA/global/1262? Do I also need to copy over
> > $PGDATA/global/pg_database?
Right on both. Of course, it'd be a good idea to first make a backup of
what you have in $PGDATA now (all of it) --- you want to be able to get
back to where you are if this makes things worse.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Andre Lopes | 2010-02-13 21:09:10 | Hosting Account with PostgreSQL and PHP? |
Previous Message | Greg Smith | 2010-02-13 18:17:25 | Re: Memory Usage and OpenBSD |