Re: [GENERAL] Critical Upgrade Instruction Bug?

On Tue, Mar 07, 2000 at 10:04:22PM -0600, Ed Loehr wrote:
> phil@Stimpy.netroedge.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@netroedge.com -- http://www.netroedge.com/~phil
 PGP F16: 01 D2 FD 01 B5 46 F4 F0  3A 8B 9D 7E 14 7F FB 7A