Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Unable to recover tables



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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group