From: | Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible |
Date: | 1999-05-30 23:51:03 |
Message-ID: | 3751CEE7.8A3E0973@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've seen this problem too in 6.5 beta. I don't have a solution, but I'd
just like to add my voice to say that this problem is real.
Actually, I did have a kind of solution. If you dump proper insert
statements into the dump and then run every insert in a separate
process. Ugly but workable if the number isn't too great.
while read A
do
echo "$A" | psql databasename
done <dumpfilename
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???
From | Date | Subject | |
---|---|---|---|
Next Message | Michael A. Koerber SR | 1999-05-31 00:07:11 | Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible |
Previous Message | Bruce Momjian | 1999-05-30 23:40:55 | Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible |