From: | Bruce Hyatt <brucejhyatt(at)yahoo(dot)com> |
---|---|
To: | "G(dot) J(dot) Walsh" <gjwalsh(at)dscdirectionalservices(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: recreating tables from global files |
Date: | 2008-05-22 13:36:36 |
Message-ID: | 279183.42384.qm@web34401.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
--- "G. J. Walsh" <gjwalsh(at)dscdirectionalservices(dot)com> wrote:
> 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.
>
> I am sure there must be a way to recreate the tables from the
> files in
> the data/global directory but I don't know what that is.
> Further, of
> course, the files representing the tables are identified by
> numbers, not
> their table names.
I assume you already consulted the documentation:
http://www.postgresql.org/docs/8.3/interactive/backup.html
Bruce
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-05-22 13:39:26 | Re: recreating tables from global files |
Previous Message | A. Kretschmer | 2008-05-22 08:03:57 | Re: get id of insert in plpgsql function |