Обсуждение: Recover v6.5 database

Поиск
Список
Период
Сортировка

Recover v6.5 database

От
"Adam Wyard"
Дата:
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