Re: recover from base directory?

hi tom,

thank you for your answer! i am very happy that i will not need the global
directory cause i really don't have it (too many bad sectors).

is the problem of having no relations founds with psql mydb1 \d related to
setting the next oid, next transaction id and WAL starting address with
pg_resetxlog?

pat

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "patrick" <patrick(at)11h11(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, April 04, 2006 3:58 PM
Subject: Re: [GENERAL] recover from base directory?

> "patrick" <patrick(at)11h11(dot)com> writes:
>> some update... but still not working. so to resume i have base / pg_xlog
>> (2
>> files and archives dir.) / pg_clog - BUT no global. i reinstalled
>> postgresql
>> 8.0.4 (same version of my backup data/). initdb, createdb mydb1, mydb2
>> mydb3
>> and move pg_xlog and _clog over the data. rename my base to fit the oid.
>
>> starting postmaster is working fine, but i had to do a pg_resetxlog and
>> now
>> it start like normal. but the problem is when i pgsql mydb1 \d no
>> relations
>> founds...
>
> You probably need to do a pg_resetxlog to move the transaction ID
> counter up to where it was before. Too bad you didn't find the old
> global directory --- the pg_control file would have been good to reuse.
> In its absence, look at the pg_resetxlog manual page concerning how to
> determine a reasonable XID setting from the pg_clog file names.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>