Re: pg_restore: [archiver] entry ID -825110830 out of range -- perhaps a corrupt TOC

-----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-----