Re: [NOVICE] recreating tables from global files

"G. J. Walsh" <gjwalsh@dscdirectionalservices.com> writes:
> I suffered a major server crash.
> Everything is fully reinstalled now EXCEPT postgresql8.3

> There was no way I could see to get postgres running except by
> removing /var/lib/pgsql/data. That was, I assumed, okay, because I have
> a full backup of all the files.

> So ... I reinstalled postgresql binaries following the same procedure as
> for the initial installation. I then restored the data/global files, but
> postgresql, while finding the database, sees no tables whatever.

You need the *entire* data directory tree, not just /global.

regards, tom lane

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice