"patrick" <patrick@xxxxxxxxx> writes: >> Only part of it. Can you find the pg_clog and pg_xlog directories? > [root@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@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
