Re: Help with Database Recovery

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: "Hancock, David (DHANCOCK)" <DHANCOCK(at)arinc(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help with Database Recovery
Date: 2000-11-30 17:23:25
Message-ID: 3A268D0D.5EE59BCF@wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Hancock, David (DHANCOCK)" wrote:
> Please--I have searched everywhere I can think of and have found no guidance
> for recovering databases where the /var/lib/pgsql/base directories are
> intact but there's no pg_dump file to work from. I need to do this because
> I stupidly but inadvertently uninstalled PostgreSQL and then had to
> reinstall it.

> 1. just copy the old base/* directories into the newly created
> /var/lib/pgsql/base directory. psql was not aware of the databases.
> 2. use createdb to create a database, and then copy the old data files into
> the corresponding base/<db> directory. psql said "couldn't open cache for
> user 40" or something similar.
> 3. modified uid for postgres user to 40, reinstalled PostgreSQL, did "2"
> again, similar result.

If the two PostgreSQL installations are the same major version, then you
copy the entire /var/lib/pgsql tree over. Not just the base/* trees.

What version, what OS?
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2000-11-30 17:33:11 Re: Can PostGreSQL handle 100 user database?
Previous Message Gordan Bobic 2000-11-30 17:17:44 Re: Unanswered questions about Postgre