Re: transaction timeout - Mailing list pgsql-general

From Frank L. Parks
Subject Re: transaction timeout
Date
Msg-id 42E66AFB.9040802@ezbizpartner.com
Whole thread Raw
In response to Re: transaction timeout  (Dr NoName <spamacct11@yahoo.com>)
List pgsql-general
TIP 2: Don't 'kill -9' the postmaster



Dr NoName wrote:

>>The common view on this kind of thing is that if
>>your client is broken,
>>you need to fix it.
>>
>>
>
>The problem is, we can't fix the users, nor can we fix
>other software that our client has to interact with.
>There will always be occasional situations when a
>client gets stuck.
>
>
>
>>That said, I have seen some folks post about writing
>>a perl or shell
>>script that runs every x minutes looking for
>>connections that have been
>>idle for > a certain amount of time and kill the
>>backend associated with
>>it (sigterm, not -9...)
>>
>>
>
>what are the implications of killing a postmaster
>process?
>
>thanks,
>
>Eugene
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings
>
>
>
>
>


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: transaction timeout
Next
From: Richard Huxton
Date:
Subject: Budget battery-backed ramdisk (Gigabyte i-RAM)