On 20.02.2010 22:26, Richard O. Hammer wrote: > Hello, > Hi! > I hope someone can tell me how to recover my database tables. I > recently upgraded to a new Linux server. First I saved a copy of my > /var/lib/pgsql/data/*, which was created with PG version 7.4. On the > new Linux server I have PG version 8.1.11. > > But now, trying use my old tables, I discover that I should have saved > the tables with the pg_dumpall command before I abandoned the > version-7.4 Postgres server. Unfortunately I did not know about > pg_dumpall. > > So now I'm wondering if there is a way I can read and update my > version-7.4 data directory with my version-8.1 postmaster. > > Here is one thing I've tried: > bash-3.2$ pg_ctl start -D /var/lib/pgsql/old/data > FATAL: database files are incompatible with server > DETAIL: The data directory was initialized by PostgreSQL version > 7.4, which is not compatible with this version 8.1.1 > > Any suggestions will be appreciated. > Downgrade to 7.4 Dump Upgrade Restore -- Andrzej Zawadzki -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
