| From: | "Adam Wyard" <adam(at)candela(dot)com(dot)au> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Recover v6.5 database |
| Date: | 2002-03-13 23:49:00 |
| Message-ID: | 013801c1cae9$a67bb380$0100a8c0@nsw.bigpond.net.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-03-14 01:18:32 | Re: Order by clause in 'select distinct'? |
| Previous Message | Peter Eisentraut | 2002-03-13 23:42:40 | Re: Postgre 7.1.3 and Solaris Install Problems |