Re: [ADMIN] pg 7.3.4 and linux box crash

2003-09-14 Thread Matt Clark
> > It is crashing the linux box. Not rebooting, not kernel panic, 
> but only stop
> > to respond.On the console if I type reboot it will not to 
> reboot and so on.
> > But it crash only if I start intensive operations on pg.

If you can type 'reboot' then surely it hasn't stopped responding?

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [ADMIN] pg 7.3.4 and linux box crash

2003-09-14 Thread pginfo
Hi,
yes I can type reboot, but the system can not reboot.
I tested the memory (it take ~20 h - the maximum test) without any problems.

I do not see any reason to think that the problem is into the HW/OS.
At the moments I install red hat 9.0 to be sure that the problem is not
by kernel.
regards,
ivan.

Matt Clark wrote:

> > > It is crashing the linux box. Not rebooting, not kernel panic,
> > but only stop
> > > to respond.On the console if I type reboot it will not to
> > reboot and so on.
> > > But it crash only if I start intensive operations on pg.
>
> If you can type 'reboot' then surely it hasn't stopped responding?
>
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster




---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [ADMIN] pg 7.3.4 and linux box crash

2003-09-14 Thread Chad R. Larson
At 06:14 AM 9/14/2003 , Matt Clark wrote:
>>It is crashing the linux box. Not rebooting, not kernel panic, but only 
>>stop to respond.On the console if I type reboot it will not to reboot and 
>>so on. But it crash only if I start intensive operations on pg.
>
>If you can type 'reboot' then surely it hasn't stopped responding?

It may be that he's got such a tight loop running somewhere that it =seems= 
to have locked up.  But if he's getting character echo on the console, some 
stuff is running.


 -crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
   Eldorado Computing, Inc.   602-604-3100
  5353 North 16th Street, Suite 400
Phoenix, Arizona   85016-3228

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is 
addressed, and may contain information that is privileged, confidential and exempt 
from disclosure under applicable law. If you are not the intended addressee, nor 
authorized to receive for the intended addressee, you are hereby notified that you may 
not use, copy, disclose or distribute to anyone the message or any information 
contained in the message. If you have received this message in error, please 
immediately advise the sender by reply email, and delete the message. Thank you.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


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

2003-09-14 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 connection, was visited
consecutively it freezes when trying to connect to the
database

Only solution is to shutdown Postgres Database and
restart it and it is not a very good solution.

Any Suggestion to clean jdbc connection in Postgres
database.

Thanks

Deepak

=
Deepak Malhotra
Phoenix, AZ

[EMAIL PROTECTED]


Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])