Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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.marlowe@xxxxxxxxx
> <mailto:scott.marlowe@xxxxxxxxx>> wrote:
> 
>     On Tue, Jan 20, 2009 at 11:15 AM, Dennis C <dcswest@xxxxxxxxx
>     <mailto:dcswest@xxxxxxxxx>> 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-----

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux