Re: transaction timeout

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

In response to

Browse pgsql-general by date

  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