Thread: Buffer Sizes

Buffer Sizes

From
"Michael Yeung"
Date:
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



Re: [GENERAL] Buffer Sizes

From
The Hermit Hacker
Date:
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


Re: [GENERAL] Buffer Sizes

From
"Michael Yeung"
Date:
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


Re: [GENERAL] Buffer Sizes

From
Bruce Momjian
Date:
[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

Re: [GENERAL] Buffer Sizes

From
"Michael Yeung"
Date:
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


Re: [GENERAL] Buffer Sizes

From
"Ross J. Reedstrom"
Date:
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