Critical Upgrade Instruction Bug?

From: phil(at)Stimpy(dot)netroedge(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Critical Upgrade Instruction Bug?
Date: 2000-03-08 03:05:50
Message-ID: 20000307190550.F16066@Stimpy.netroedge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I followed the upgrade instructions carefully, and got to this step:

psql -e template1 < db.out

After a while of waiting (and a lot of stuff scrolling past), it
started producing these (after getting into a table with a lot of
entries)):

[...]
query buffer max length of 16384 exceeded
query line ignored
\smod

query buffer max length of 16384 exceeded
query line ignored
\elevant output from the syslog when the modules are inserted.
[...]

It seems that pgsql doesn't like all the info shoved down it's throat
at once. :'( I used the current (6.5.3) pgdump_all to produce the dump
from the old release, and then installed 6.5.3. I checked the drive,
and it isn't full.

I get better results with:

bash /usr/src/pgsql/src/bin/pg_dump/dg_dumpall -d > /tmp/db-backup

Instead of:

bash /usr/src/pgsql/src/bin/pg_dump/dg_dumpall > /tmp/db-backup

W/ each instance being a separate insert, things seem happier (but
slower). But, permissions on DB's are lost and mysteriously many
tables are empty.... urrrggg!!!

Ideas? I'm going from 6.3.? to 6.5.3.

Phil

--
Philip Edelbrock -- IS Manager -- Edge Design, Corvallis, OR
phil(at)netroedge(dot)com -- http://www.netroedge.com/~phil
PGP F16: 01 D2 FD 01 B5 46 F4 F0 3A 8B 9D 7E 14 7F FB 7A

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2000-03-08 04:04:22 Re: [GENERAL] Critical Upgrade Instruction Bug?
Previous Message Jeff Lomas 2000-03-08 02:53:59 put me on the mailing list, please