Re: recover from base directory?

"patrick" <patrick(at)11h11(dot)com> writes:
>> Only part of it. Can you find the pg_clog and pg_xlog directories?

> [root(at)hd-t407cl lost+found]# find . | grep pg_clog
> ./#3044578/pg_clog
> ./#3044578/pg_clog/0000
> ./#3044578/pg_clog/0001
> ./#3044578/pg_clog/0002

> (3 files)

> [root(at)hd-t407cl lost+found]# find . | grep pg_xlog
> ./#3044578/pg_xlog
> ./#3044578/pg_xlog/archive_status
> ./#3044578/pg_xlog/00000001000000000000000F
> ./#3044578/pg_xlog/00000001000000000000000E

> looks good?

Looks promising. If you've also got the "global" directory then you
should have everything you really need. Just move 'em back into the
correct data directory. You'll need to find or reconstruct the other
stuff such as the config files, but that's not too hard. (You might
want to initdb a new data directory, and then move what you can find
into it, replacing what's there.)

It kinda looks like #3044578 might actually *be* your data directory;
take a look in it ...

BTW, this is not a good time to be doing a PG version upgrade;
keep using the same version you had.

regards, tom lane