[ADMIN] Postgres is not closing JDBC connection .. Please help

2003-09-15 Thread Deepak Malhotra
Hello I am using POstgres 7.3 and jdbc driver org.postgresql.Driver. I am using jdbc driver for PostgreSQL to connect to the database and when I am closing the database connection using Java but it seems PostgreSQL does not close the connection actually. If the web page, which uses the database

Re: [ADMIN] Postgres is not closing JDBC connection .. Please help

2003-09-15 Thread Hornyak Laszlo
I think you should fix this in the java code, because PostgreSQL cannot say goodye for the client. For example close connection in the finally block, so it will be closed even if the code inside has a failure. On Mon, 15 Sep 2003, Deepak Malhotra wrote: Hello I am using POstgres 7.3 and

[ADMIN] upgrade of 7.2.2-1 to 7.3.4

2003-09-15 Thread S.P.Vimala
Hi, I have postgresql-7.2.2-1. I downloaded the lib, server and postgresql versions of 7.3.4. If u do an upgrade its gives a dependency error saying the library file is req for the installed version 7.2. Can i do a force install with no dependencies on all the lib,server and

Re: [ADMIN] Postgres is not closing JDBC connection .. Please help

2003-09-15 Thread Tom Lane
=?iso-8859-1?q?Deepak=20Malhotra?= [EMAIL PROTECTED] writes: I am using jdbc driver for PostgreSQL to connect to the database and when I am closing the database connection using Java but it seems PostgreSQL does not close the connection actually. You've got that backwards: Java is not closing

Re: [ADMIN] Report Generator Proposal

2003-09-15 Thread Gaetano Mendola
Must I suppose that the idea rejected ? - Original Message - From: Gaetano Mendola [EMAIL PROTECTED] Newsgroups: comp.databases.postgresql.admin Sent: Thursday, September 11, 2003 11:52 PM Subject: Re: Report Generator Proposal Nobody entusiastic ? I'm wrong about my feeling ? I

Re: [ADMIN] Report Generator Proposal

2003-09-15 Thread Matt Clark
I rather like it actually. Cisco equipment has a 'show tech-support' command that does exactly that, dumps all the config, HW/SW versions, current state, you name it. If you have a problem you run that, attach the output to yr support email, and 99% of the time there's enough info there to

Re: [ADMIN] Report Generator Proposal

2003-09-15 Thread Gaetano Mendola
Matt Clark [EMAIL PROTECTED] wrote: It'd be easy to automate all except the explain, a script that did everything else could then emit If your preoblem relates to a specific query, then run 'explain analyze query' and attach it to your message as well. Well, must be charge of psql store

Re: [ADMIN] Report Generator Proposal

2003-09-15 Thread kaolin fire
On Monday, September 15, 2003, at 02:06 PM, Gaetano Mendola wrote: Matt Clark [EMAIL PROTECTED] wrote: It'd be easy to automate all except the explain, a script that did everything else could then emit If your preoblem relates to a specific query, then run 'explain analyze query' and attach it

Re: [ADMIN] Report Generator Proposal

2003-09-15 Thread Somasekhar Bangalore
Sounds good ...it will save lot of emails floating around and time.. Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, India Ph:+91-80-235-0481 Fax:+91-80-235-0486 Email: [EMAIL