Thread: Buffer Sizes
Hi all, Does anybody know how to adjust the BUFFER size ?? Because I want to reload the database but it fails to write !! ( I dump the database from 6.3 and try to reload in a 6.4 version) Thanks !! MICHAEL
On Fri, 23 Jul 1999, Michael Yeung wrote:
> Hi all,
>
> Does anybody know how to adjust the BUFFER size ?? Because I want to reload
> the database but it fails to write !!
What sort of error are you getting? which buffer size?
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
Hi,
The Error when reloading the database is :
"query buffer max length of 20000 exceeded"
"query line ignored"
and the tables cannot reload !!
Regards,
MIC
----- Original Message -----
From: The Hermit Hacker <scrappy@hub.org>
To: Michael Yeung <michaely@alphanet.net.au>
Cc: <pgsql-general@postgreSQL.org>
Sent: Friday, July 23, 1999 10:16 AM
Subject: Re: [GENERAL] Buffer Sizes
> On Fri, 23 Jul 1999, Michael Yeung wrote:
>
> > Hi all,
> >
> > Does anybody know how to adjust the BUFFER size ?? Because I want to
reload
> > the database but it fails to write !!
>
> What sort of error are you getting? which buffer size?
>
> Marc G. Fournier ICQ#7615664 IRC Nick:
Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org secondary:
scrappy@{freebsd|postgresql}.org
[Charset iso-8859-1 unsupported, filtering to ASCII...] > Hi all, > > Does anybody know how to adjust the BUFFER size ?? Because I want to reload > the database but it fails to write !! > > ( I dump the database from 6.3 and try to reload in a 6.4 version) > > Thanks !! Edit include/config.h. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Hi, How to Edit ? What to Edit ? Regards, MIC ----- Original Message ----- From: Bruce Momjian <maillist@candle.pha.pa.us> To: Michael Yeung <michaely@alphanet.net.au> Cc: <pgsql-general@postgreSQL.org> Sent: Friday, July 23, 1999 10:27 AM Subject: Re: [GENERAL] Buffer Sizes > [Charset iso-8859-1 unsupported, filtering to ASCII...] > > Hi all, > > > > Does anybody know how to adjust the BUFFER size ?? Because I want to reload > > the database but it fails to write !! > > > > ( I dump the database from 6.3 and try to reload in a 6.4 version) > > > > Thanks !! > > Edit include/config.h. > > -- > Bruce Momjian | http://www.op.net/~candle > maillist@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
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@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005