[ADMIN] configure using libxml

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:

Re: [ADMIN] configure using libxml

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

[ADMIN] Has anyone attended PostgreSql classes

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

Re: [ADMIN] Has anyone attended PostgreSql classes

-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 PostgreSql

Re: [ADMIN] insufficient file descriptors on Mac OS X

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 those

Re: [ADMIN] Has anyone attended PostgreSql classes

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

Re: [ADMIN] Has anyone attended PostgreSql classes

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

[ADMIN] idle in transaction...unexpected EOF on client connection

Hi Everybody, I see in serverlog many entries that read: gadb 2007-11-09 13:13:47 PST idle in transactionLOG: unexpected EOF on client connection gadb 2007-11-09 13:23:08 PST idle in transactionLOG: unexpected EOF on client connection gadb 2007-11-09 13:23:44 PST idle in transactionLOG:

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

On Nov 9, 2007 3:58 PM, Tena Sakai [EMAIL PROTECTED] wrote: Hi Everybody, I see in serverlog many entries that read: gadb 2007-11-09 13:13:47 PST idle in transactionLOG: unexpected EOF on client connection gadb 2007-11-09 13:23:08 PST idle in transactionLOG: unexpected EOF on client

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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 connects

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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 terminate

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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 the app and

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

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

Re: [ADMIN] idle in transaction...unexpected EOF on clientconnection

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ó: