[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: unsupported XML feature DETAIL: This functionality requires libxml support. HINT: You need to re-compile PostgreSQL using --with-libxml. the running configuration is: BINDIR = /usr/local/postgresql-8.3beta/bin DOCDIR = /usr/local/postgresql-8.3beta/doc INCLUDEDIR = /usr/local/postgresql-8.3beta/include PKGINCLUDEDIR = /usr/local/postgresql-8.3beta/include INCLUDEDIR-SERVER = /usr/local/postgresql-8.3beta/include/server LIBDIR = /usr/local/postgresql-8.3beta/lib PKGLIBDIR = /usr/local/postgresql-8.3beta/lib LOCALEDIR = MANDIR = /usr/local/postgresql-8.3beta/man SHAREDIR = /usr/local/postgresql-8.3beta/share SYSCONFDIR = /usr/local/postgresql-8.3beta/etc PGXS = /usr/local/postgresql-8.3beta/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE = '=' '--with-tcl' '--enable-odbc' '--without-zlib' '-prefix=/usr/local/postgresql-8.3beta2' 'LDFLAGS=-lstdc++' CC = gcc CPPFLAGS = -D_GNU_SOURCE CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels -fno-strict-aliasing CFLAGS_SL = -fpic LDFLAGS = -lstdc++ -Wl,-rpath,'/usr/local/postgresql-8.3beta2/lib' LDFLAGS_SL = LIBS = -lpgport -lreadline -lcrypt -ldl -lm VERSION = PostgreSQL 8.3beta2 does anybody knows what goes wrong?? thanks Monika ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
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 xml-functions. the running configuration is: Note that the configuration doesn't mention the libxml switch, so you forgot something somewhere. Did you do a make distclean before rebuilding, and did you install the new build? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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 to attend training somewhere within the US. Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu
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 training could you please send me your recommendations? Positive and negative recommendations would both be appreciated. I plan to attend training somewhere within the US. For a classroom setting I would suggest OTG (http://www.otg-nc.com/), they are a known contributor and I have heard very good things about their classes from my smaller customers (my bigger customers use us ;)). Sincerely, Joshua D. Drake Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHNIbSATb/zqfZUUQRAphbAKCk5JSktQ9uSLZK+keCooyfa8gGrQCdHOOR MOZZ8Yt5xwVfyOthqNOMgdw= =cdPA -END PGP SIGNATURE- ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
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 will be eaten by semaphores. You could change the ulimit setting, back off max_connections, or apply this patch: http://archives.postgresql.org/pgsql-committers/2007-09/msg00399.php BTW, if you're really hoping to have 240 connections, you're gonna need to do something about ulimit -u too. $ ulimit -a core file size(blocks, -c) 0 data seg size (kbytes, -d) 6144 file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files(-n) 256 pipe size (512 bytes, -p) 1 stack size(kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes(-u) 100 virtual memory(kbytes, -v) unlimited regards, tom lane ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
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 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 to attend training somewhere within the US. Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
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 recommend him. Mija Lee wrote: 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 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 to attend training somewhere within the US. Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings -- Emilie R. Steele Programmer/Analyst College of Continuing Education-IT University of Oklahoma (405) 325-7161 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[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: unexpected EOF on client connection gadb 2007-11-09 13:25:42 PST idle in transactionLOG: unexpected EOF on client connection This occurs regularly and frequently and I am wondering if it is indicative of any underlying issue(s). Would you please let me know what you know? Thank you. Tena Sakai [EMAIL PROTECTED]
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 connection gadb 2007-11-09 13:23:44 PST idle in transactionLOG: unexpected EOF on client connection gadb 2007-11-09 13:25:42 PST idle in transactionLOG: unexpected EOF on client connection This occurs regularly and frequently and I am wondering if it is indicative of any underlying issue(s). Would you please let me know what you know? 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. Could be other things, like crashing clients, etc... Hard to say without more evidence. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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 PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tena Sakai Sent: Friday, November 09, 2007 3:58 PM To: pgsql-admin@postgresql.org Subject: [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: unexpected EOF on client connection gadb 2007-11-09 13:25:42 PST idle in transactionLOG: unexpected EOF on client connection This occurs regularly and frequently and I am wondering if it is indicative of any underlying issue(s). Would you please let me know what you know? Thank you. Tena Sakai [EMAIL PROTECTED]
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 is exactly what you would see. Is there any reason you're so fond of top-posting? -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J Escucha y olvidarás; ve y recordarás; haz y entenderás (Confucio) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
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 then closes the socket without actually talking the PG protocol, this is exactly what you would see. That might explain Lance's problem but not Tena's, since his (hers?) are idle in transaction, which means the connection at least did a begin; after connecting. Also possible for Lance's is an application that isn't properly closing its connections. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
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 using jdbc to issue postgres commands. However, I see the same message via psql (on the same machine). Tena Sakai [EMAIL PROTECTED] -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Fri 11/9/2007 2:11 PM To: Tena Sakai Cc: pgsql-admin@postgresql.org Subject: 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 connection gadb 2007-11-09 13:23:44 PST idle in transactionLOG: unexpected EOF on client connection gadb 2007-11-09 13:25:42 PST idle in transactionLOG: unexpected EOF on client connection This occurs regularly and frequently and I am wondering if it is indicative of any underlying issue(s). Would you please let me know what you know? 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. Could be other things, like crashing clients, etc... Hard to say without more evidence.
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 session message before dropping the network connection. I seem to recall that old versions of the JDBC driver had a bad habit of not sending Terminate --- what JDBC version are you using? regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
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 postgres are running on the same computer. The app is a java program using jdbc to issue postgres commands. However, I see the same message via psql (on the same machine). 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. Either way, the pgsql backend was still alive, and tried to send something to the client, and the client wasn't there. I.e. the problem isn't generally a postgresql problem, it's a client problem. So, the more info about the client app the better chance of fixing it. Note that if you've got a lot of idle in transactions connections, that's a bad thing because it prevents postgresql from being properly vacuumed. Most connection managers can be set to NOT issue a begin as part of a connection reset when returning it to the pool. ---(end of broadcast)--- TIP 6: explain analyze is your friend
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 be caused by many deleted rows from tables (and having neglected to vacuum)? Tena Sakai ([EMAIL PROTECTED]) -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Fri 11/9/2007 3:03 PM To: Scott Marlowe Cc: Tena Sakai; pgsql-admin@postgresql.org Subject: 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 session message before dropping the network connection. I seem to recall that old versions of the JDBC driver had a bad habit of not sending Terminate --- what JDBC version are you using? regards, tom lane
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 gone. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
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ó: 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 gone.