Re: [GENERAL] Critical Upgrade Instruction Bug?

On Tue, Mar 07, 2000 at 10:04:22PM -0600, Ed Loehr wrote:
> phil(at)Stimpy(dot)netroedge(dot)com wrote:
> >
> > [...]
> > query buffer max length of 16384 exceeded
> > query line ignored
> > \smod
>
> IIRC, that usually happens when a string delimiter is missing. Maybe
> look for embedded apostrophes or something wonky with pgdump?
>
> Regards,
> Ed Loehr

I eventually got things working mostly with:

bash ./pg_dumpall -d -z > /tmp/dbnight.txt

At least this preserved permissions. I still had some tables
mysteriously be empty. So dumping those specific tables and
re-importing those seemed to do the trick. I'm hoping that this mess
is a result of bugs in the old version I was running (further
justifying the upgrade). I *think* I was running 6.3.0... my old
src/include/version.h said:

[...]
#define PG_RELEASE 6
#define PG_VERSION 3
#define PG_VERFILE "PG_VERSION"
[...]

This was prompted when a DB mysteriously corrupted it's self last
night after a year or so of use. (yikes!) But, I managed to dump it
and re-import it - saving most of the data, but I thought a better
permenent solution was to upgrade.

Anyways, things seems to work as they were, although a *LOT* faster
(about 5x?). :')

Thanks!

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