From: | "Frank L(dot) Parks" <fparks(at)ezbizpartner(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: transaction timeout |
Date: | 2005-07-26 16:55:23 |
Message-ID: | 42E66AFB.9040802@ezbizpartner.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | mark reid | 2005-07-26 17:22:50 | Re: dropping non-existent tables |
Previous Message | Scott Marlowe | 2005-07-26 16:39:08 | Re: transaction timeout |