From: | "G(dot) J(dot) Walsh" <gjwalsh(at)dscdirectionalservices(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Unable to recover tables |
Date: | 2008-05-22 20:54:54 |
Message-ID: | 1211489694.6583.23.camel@www.dscdirectionalservices.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks for your earlier reply, Tom.
What I did was:
Stop the server: service postgresql stop
Remove the directory tree completely: rm -rf /var/lib/pgsql
Restore the full tree:
/bin/cp -r /bup/previous/var/lib/pgsql /var/lib/pgsql
Ensure postgres owns all:
chown postgres:postgres -R /var/lib/pgsql
Restart the server: service postgresql restart
At this point I can once again access the original data base
and \l shows it correctly, but \d shows no relations.
I can create a new table, but I am not at all confident that I can have
it present in the routine directory/file backups.
Don't understand why that is, nor where to focus my search to find the
problem.
George
From | Date | Subject | |
---|---|---|---|
Next Message | Mag Gam | 2008-05-25 19:03:20 | socket versus 127.0.0.1 |
Previous Message | guillaume.yziquel | 2008-05-22 20:19:05 | Re: How to connect to the database server |