Re: recreating tables from global files - Mailing list pgsql-novice

From Tom Lane
Subject Re: recreating tables from global files
Date
Msg-id 29858.1211463566@sss.pgh.pa.us
Whole thread Raw
In response to recreating tables from global files  ("G. J. Walsh" <gjwalsh@dscdirectionalservices.com>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: Bruce Hyatt
Date:
Subject: Re: recreating tables from global files
Next
From: "A B"
Date:
Subject: Re: get id of insert in plpgsql function