I recently updated my OS to RedHat 5.2 with the 2.2 Kernel. I was last
using Postgres 6.4.2 with my database. I re-installed Postgres 6.4.2
into the new operating system and tried to copy the contents of the
database directory over to the newly installed directory.
I am able to select and update from the database, but when I try '/d',
the psql comes back with "Can't find any tables or indicies". I know
that it is better to restore from a previous pg_dump, but shouldn't I be
able to simply copy the files over to the new directory and have the
thing working? Is there some sort of "table of the tables" file that
didn't copy over correctly? Any way to get things back to normal?
Any suggestions?
Thanks.
-Tony