RE: query buffer max length of 16384 exceeded

From: Michael Ansley <Michael(dot)Ansley(at)intecsystems(dot)co(dot)uk>
To: "'Rainer Mager'" <rmager(at)vgkk(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: RE: query buffer max length of 16384 exceeded
Date: 2000-06-12 13:18:10
Message-ID: 2D50E16224C8D311B183009027452B476AFCAC@INTEC003
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I assume that you have a version prior to 7.0. The only way to increase
this would be to increate your block size, recompile, and initdb. If you
are using 7.0 or above, this is not an issue, as the limit has been removed.

Cheers...

MikeA

>> -----Original Message-----
>> From: Rainer Mager [mailto:rmager(at)vgkk(dot)com]
>> Sent: 12 June 2000 09:26
>> To: pgsql-admin(at)postgresql(dot)org
>> Subject: [ADMIN] query buffer max length of 16384 exceeded
>>
>>
>> Hi all,
>>
>> I would expect this to be a FAQ but I can't find
>> anything in the docs or on
>> the net. I'm trying to restore a pg_dumped database (via "psql <
>> databasefile") and get this error:
>>
>> query buffer max length of 16384 exceeded
>>
>> Is there anyway to adjust this buffer (preferrably without
>> rebuilding PG)?
>> Or is there a better way to restore a database?
>>
>>
>> Thanks,
>>
>> --Rainer
>>

Browse pgsql-admin by date

  From Date Subject
Next Message John VanDyk 2000-06-12 18:50:55 ODBC and PostgreSQL 7.02
Previous Message Rainer Mager 2000-06-12 08:25:38 query buffer max length of 16384 exceeded