Re: Unable to recover tables

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"G. J. Walsh" <gjwalsh(at)dscdirectionalservices(dot)com> writes:
> 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.

Do you see any rows at all in pg_class in that database?

Also, where did /bup/previous/var/lib/pgsql come from?  If this was
a filesystem-level backup that was taken while the postmaster was
running, you may have consistency problems in it.

			regards, tom lane