Hi everyone,
My name is Ken working in Tokyo,Japan. Please forgive my
poor English.
We have been using PostgreSQL7.3.4 on a Map GIS engine
since last year.To tune the system, I need to get the log
from PostgreSQL7.3.4 and analyze it.
Here comes the problem. When a long SQL is excuted. I got
the
> The best guess I have is that this is a failure in
> Solaris' syslog.
> There is certainly no such message anywhere in the
> Postgres backend
> code. Try changing your syslog setting to 0 (log
> only to stderr)
> and see if logging to a plain file works better.
>
> BTW, PG 7.3.4 is pretty darn
> Possibly the folks on pgsql-jdbc could help you with
> that.
>
> regards, tom lane
sincere thanks to you tom lane
I checked all the shell programs in the system which
running standalone from SUN application server. Finally
find the answer. One of those shell programs uses