Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible

Gregory Maxwell wrote:
>
>AHH! The pgsql v6.3 backend has begun crashing horribly on me since I've
>added a few more database backed webpages (with messages like 'backend
>cache invalidation...').. I figured that upgrading to 6.4.2 would solve my
>problems.. But I can't upgrade! Things I've tried:
>
>* Using old pg_dumpall -z > file and psql -e template1 < file (after
> install and initdb)
>* Using the pg_dumpall from the new version.
>* Using pg_upgrade
>* Rereading the docs dozens of times
>* having a friend try it.
>* all of the above with both 6.4.2 and 6.5beta
>
>Every time I start loading, it chokes up on the dump output and falls into
>a constant stream of parse errors and messages like "PQsendQuery() --
>query is too long. Maximum length is 8191"
>
>Argh!!! I've got websites constantly crashing and coustomers ready to
>revolt, what can I do???

edit the dump file; change every line to an insert command. Run that
so that you can see what it is objecting to.

6.3's dump did not cover everything, so you are likely to have to edit the
dump file to make it reloadable.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Do all things without murmurings and disputings;
that ye may be blameless and harmless, the sons of
God, without rebuke, in the midst of a crooked and
perverse nation, among whom ye shine as lights in the
world." Philippians 2:14,15