From: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
---|---|
To: | Michael Yeung <michaely(at)alphanet(dot)net(dot)au> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Buffer Sizes |
Date: | 1999-07-23 02:34:13 |
Message-ID: | 19990722213413.A7152@wallace.ece.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jul 23, 1999 at 10:25:04AM +1000, Michael Yeung wrote:
> Hi,
>
> The Error when reloading the database is :
>
> "query buffer max length of 20000 exceeded"
> "query line ignored"
>
Ah, if I remember correctly, the 6.3->6.4 upgrade required dumping the old db
with the _new_ pg_dumpall, otherwise it'd throw and error while reloading.
What usually happens to me when I do something like that is the error flys by,
then the rest of the file gets taken as a really long, badly formed query.
I assume your doing something like:
psql template1 <dump_all_6.3.sql
try something like (this is for a bash shell: season to taste for csh)
psql -e template1 <dump_all_6.3.sql | less 2>&1
then in the pager, search for ERROR
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
From | Date | Subject | |
---|---|---|---|
Next Message | Hub.Org News Admin | 1999-07-23 05:57:43 | |
Previous Message | Michael Yeung | 1999-07-23 01:23:01 | Re: [GENERAL] Buffer Sizes |