Thread

1. Buffer Sizes

   Michael Yeung <michaely@alphanet.net.au> — 1999-07-22T23:47:22Z

   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
   
   
   
   

2. Re: [GENERAL] Buffer Sizes

   Marc G. Fournier <scrappy@hub.org> — 1999-07-23T00:16:38Z

   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 
   
   
   

3. Re: [GENERAL] Buffer Sizes

   Michael Yeung <michaely@alphanet.net.au> — 1999-07-23T00:25:04Z

   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
   
   
   

4. Re: [GENERAL] Buffer Sizes

   Bruce Momjian <maillist@candle.pha.pa.us> — 1999-07-23T00:27:41Z

   [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
   
   

5. Re: [GENERAL] Buffer Sizes

   Michael Yeung <michaely@alphanet.net.au> — 1999-07-23T01:23:01Z

   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
   
   
   

6. Re: [GENERAL] Buffer Sizes

   Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu> — 1999-07-23T02:34:13Z

   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