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
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 |