RE: [ADMIN] query buffer max length of 16384 exceeded

Well, I fixed my problem. I'm sure everyone already knows this but if you use the -d flag to pg_dump (Dump data as proper insert strings) then it doesn't use the COPY command to insert data. Hence no HUGE strings to exceed the buffer. Using this flag helped. --Rainer

[ADMIN] Who should own pg_hba.conf?

Should pg_hba.conf be owned by root or by postgres? I'd think that root would be a little more secure. -Tony

Re: [ADMIN] multi processor

Loïc TREGOUËT writes: > Is Postgresql , can use more than one processor for one request or is > depend of something else ? Not if your operating system doesn't support multiple processors per one (single-thread) process. Most don't. What you'll most likely end up with is one processor per proces

Re: [ADMIN] Importing table from mysql

On Fre, 02 Jun 2000, Anthony E. Greene wrote: >At 11:17 2000-06-02 +0530, Pragati Sagar wrote: >>I already have a database created in mysql. But now I want to shift from >>mysql to postgresql but my problem is how to convert mysql database to >>postgresql. How will I import the tables from mysql?

[ADMIN] Sending e-mail from a trigger

I haven't paid much attention to the discussions of SPI, but I remember seeing questions about the server-side system tasks in the trigger context, among which sending mail was the most frequent. I am not aware whether such questions were sufficiently answered in the lists, so when I had to writ

[ADMIN] Re: case senesitive

HENAFF Mari-mai FTRD/DMI/LAN writes: > And is it possible to make a query containing an ORDER BY that is not case > sensitive ? Option 1: SELECT * FROM table ORDER BY upper(field); Option 2: Build with --enable-locale. Most locales sort a, A, b, B, etc. -- Peter Eisentraut

[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 wi

Re: [ADMIN] multi processor

Loïc TREGOUËT writes: > Is Postgresql , can use more than one processor for one request or is > depend of something else ? PostgreSQL is at the mercy of your operating system regarding SMP. In many cases this means that the smallest granularity is at the process level, so one connection per proc

[ADMIN] RE: multi processor

I think Postgres won't do anything to handle multiple processors. Since you have one Postgres process per DB connection, multiples active connections will be spread around your processors, and the overall speed will be increased, just like any other software on an SMP machine with an SMP system

RE: [ADMIN] query buffer max length of 16384 exceeded

Title: RE: [ADMIN] query buffer max length of 16384 exceeded 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..