I am trying to recover some database from a crashed
server which had Postgres v6.5 - after plenty of mucking about I've found
another server with the old version which I can use to dump the
databases.
However, when I copy all the files over only the
system tables are visible in psql. The \d command gives:
Couldn't find any tables, sequences or
indices!
select * from pg_class; just gives the system
tables, but when I view the actual pg_class file I can see the other tables
in there (amongst all the binary data).
Is there something else which needs to be done
before the tables can be used?
Thanks
|