Thank you!
Tena
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Fri 11/9/2007 4:29 PM
To: Tena Sakai
Cc: Tom Lane; Scott Marlowe; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] idle in transaction...unexpected EOF on clientconnection
Tena Sakai escribió:
> Asi
Tena Sakai escribió:
> Aside from that, can this be caused by many deleted
> rows from tables (and having neglected to vacuum)?
No.
--
Alvaro Herrerahttp://www.advogato.org/person/alvherre
Major Fambrough: You wish to see the frontier?
John Dunbar: Yes sir, before it's g
Hi Tom,
Good to have you jump in.
The answer to your question (what JDBC version) is:
postgresql-8.1-404.jdbc3.jar
and the postgres version is: 8.2.4
I just downloaded postgresql-8.2-506.jdbc3.jar and
will go ahead and recompile the app over the weekend
with this one.
Aside from that, can this
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> Hmmm. Well, when you see an error like unexpected EOF on client
> connection then that means that the client "disappeared" without
> closing the connection, or the network connection went away.
More specifically, the client didn't send the expected "t
On Nov 9, 2007 4:36 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> Hi Scott,
>
>
> > Most likely what is happening is that you have a firewall between your
> > app and your db server that is closing idle connections after x minutes.
>
> Thanks for your comment.
>
> I hate to be disagreeable, but
Hi Scott,
> Most likely what is happening is that you have a firewall between your
> app and your db server that is closing idle connections after x minutes.
Thanks for your comment.
I hate to be disagreeable, but the app and postgres are running
on the same computer. The app is a java program
On Nov 9, 2007 4:29 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Campbell, Lance wrote:
> > I notice this in my log file as well. I do not have a fire wall that
> > would impact this.
>
> It could be a monitoring tool that's opening the socket to check whether
> Postgres is listening. If it co
Campbell, Lance wrote:
> I notice this in my log file as well. I do not have a fire wall that
> would impact this.
It could be a monitoring tool that's opening the socket to check whether
Postgres is listening. If it connects then closes the socket without
actually talking the PG protocol, this
I notice this in my log file as well. I do not have a fire wall that
would impact this.
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
From: [EMAIL PROTE
On Nov 9, 2007 3:58 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> Hi Everybody,
>
> I see in serverlog many entries that read:
> LOG: unexpected EOF on
> client connection
> LOG: unexpected EOF on
> client connection
> LOG: unexpected EOF on
> client connection
> LOG: unexpected EOF on
Hi Everybody,
I see in serverlog many entries that read:
LOG: unexpected EOF on
client connection
LOG: unexpected EOF on
client connection
LOG: unexpected EOF on
client connection
LOG: unexpected EOF on
client connection
This occurs regularly and frequently and I am
wondering if it is
Chander at OTG is an excellent instructor, and OTG's materials are
excellent. The PosgresQL Database Administration class does start at
the beginning, but the Performance Tuning class has more advanced
topics, and there may be another advanced administration class in the
works. I highly reco
I went to the 5 day class at OTG that Chander taught. I thought he was
really good and the price couldn't be beat. I was a total novice and
found the class challenging. I'm not sure how one might feel if they had
as much experience as you.
Campbell, Lance wrote:
I have been using PostgreSql f
Maximilian Tyrtania <[EMAIL PROTECTED]> writes:
> <%2007-11-09 14:46:42 CETFATAL: 53000: insufficient file descriptors
> available to start server process
This is not a shared-memory problem.
On my Mac, ulimit -n seems to be 256 by default, and you've got
max_connections = 240 so nearly all of t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
/)On Fri, 9 Nov 2007 09:18:04 -0600
"Campbell, Lance" <[EMAIL PROTECTED]> wrote:
> I have been using PostgreSql for four years now. I am the official
> DBA. I would like to go through a formal DBA training class. If you
> have been to formal Postgre
I have been using PostgreSql for four years now. I am the official DBA.
I would like to go through a formal DBA training class. If you have
been to formal PostgreSql training could you please send me your
recommendations? Positive and negative recommendations would both be
appreciated. I plan t
I am trying to start the server (8.2.3 on Mac OS X 10.4.10 (8R2218)
Kernel-Version:Darwin 8.10.1).
I have 3Gb Ram available.
My memory settings are:
Maximilian-Tyrtanias-Computer-2:~ maximiliantyrtania$ sysctl -a | grep shm
kern.exec: unknown type returned
kern.sysv.shmmax: 134217728
kern.sysv.s
Am Freitag, 9. November 2007 schrieb König, Monika:
> I try to configure postgresql 8.3beta with libxml by the comand:
>
> LDFLAGS=-lstdc++ ./configure --with-tcl --without-zlib --with-libxml
> -prefix=/usr/local/postgresql-8.3beta
>
> It works fine, but after make and make install I can't use the
Hey,
I try to configure postgresql 8.3beta with libxml by the comand:
LDFLAGS=-lstdc++ ./configure --with-tcl --without-zlib --with-libxml
-prefix=/usr/local/postgresql-8.3beta
It works fine, but after make and make install I can't use the
xml-functions.
The error message is:
ERROR: unsup
19 matches
Mail list logo