-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, maybe I did not understand - but what exactly happens when you do something like pg_restore -d databasename -L backup.toc backup.bak (bak -> or what ever custom format you use) Is the version you did the backup with the same like the postgres version you want to restore to? I am not sure, but maybe there are occuring some problems ... $ less test.toc | grep "^;" [...] ; Dumped from database version: 8.3.5 ; Dumped by pg_dump version: 8.3.5 [...] Cheers Andy - -- St.Pauli - Hamburg - Germany Andreas Wenk Dennis C schrieb: > Greetings: > > I already did some searches on the "pg_restore: [archiver] entry ID > -825110830 out of range -- perhaps a corrupt TOC" error and am still not > sure why my database's not restoring after upgrading the FreeBSD and > select ports such as PostGreSQL. I did see something from a long time > ago about altering the table, especially column names, quite possibly > being a problem and I have done a lot of that, but as many backups as > I've also done this past year, this' the first time I've had to use the > restore again and am now not even sure how to get my database back. If > this seems familiar and simple enough for anyone, please advise > including which details may be useful here. > > Thanks, -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJdYu7Va7znmSP9AwRAunPAKCliM90HkrNzQ51ectMmziqc7gTGwCeNrco VvYrDL/hbinlF9gaPUMau1o= =M8mK -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
