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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dennis C schrieb:
> OK that was it! Wow, thank you so very much! Nice to know it was just
> plpython tracking such an obsolete version of postgresql much to my
> dismay now (especially even going backwards, which didn't even occur to
> me), as opposed to postgresql itself being less reliable than I've come
> to expect over the years! Thanks for all your great work with that too
> in the first place!

cool that it's working now ;-)

>
> On Tue, Jan 20, 2009 at 10:40 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com
> <mailto:scott(dot)marlowe(at)gmail(dot)com>> wrote:
>
> On Tue, Jan 20, 2009 at 11:15 AM, Dennis C <dcswest(at)gmail(dot)com
> <mailto:dcswest(at)gmail(dot)com>> wrote:
> > Greetings;
> > And thanks for your reply! I tried the following:
> > less xaa | grep "^;"
> > "xaa" may be a binary file. See it anyway? y
> > Binary file (standard input) matches
> >
> > And so am not sure which version I did the following from:
> > pg_dump -c -F c -Z 9 [databasename]
>
> It's kind of important, but... PostgreSQL's dump and restore commands
> are designed to work from the same versions or going a new version
> from an older version. Going backwards is not supported.

That was what I head in mind asking you about the version ;-) Thank's to Scott for
bringing it to the point ;-)

> > But I installed it about a year ago, so whichever was the release
> then.
> > Am trying to restore to the following:
>
> 8.2 or 8.3. Unless you were using a version supplied by a distro,
> which could go further back.
>
> > postgresql-client-7.4.21 PostgreSQL database (client)
> > postgresql-plpython-7.4.21_1 A module for using Python to write SQL
> > functions
> > postgresql-server-7.4.21 The most advanced open-source database
> available
> > anywhere
>
> Now's the time to upgrade. 7.4 is the oldest supported version, which
> means it's next for the chopping block. It's also A LOT slower than
> 8.3. Can you get and install a newer version of pgsql, preferably 8.3
> and try restoring there?
> > cat * | pg_restore -d [databasename]
>
> The normal way to run it is to use the -f switch for the file
>
> pg_restore -d dbname -f filename
>
> Not sure there's anything wrong with your way, but I've never used
> pg_restore like that.
>
>

Cheers

Andy
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJdvxAVa7znmSP9AwRAqqhAKCswD9ioSbJuIwiBLZLfTdTaW+jVwCgy3d7
IQiwmaLkNoxs7zbSZcH1+5E=
=i/ZQ
-----END PGP SIGNATURE-----