[ADMIN] [admin]unsubscribe

2003-09-15 Thread shilpi jain
unsubscribe psql-admin __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PR

Re: [ADMIN] Report Generator Proposal

2003-09-15 Thread skennedy
Oracle have something similar: RDA which generates  HTML reports for the hardware, SO, and database. It doesn't do explains but does show which SQLs are the most expensive, etc. It could be worth having a look at that for ideas on what and how to report it. Stephen. Somasekhar Bangalore wrot

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

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 ' and attach it

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 ' and attach it to your message as well". Well, must be charge of psql store som

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 solv

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

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 cl

[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 posgre

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