Re: [GENERAL] Trying to understand postgres crash

2011-12-22 Thread Hanns Hartman
On Thu, Dec 22, 2011 at 10:14 AM, Tom Lane wrote: > Hanns Hartman writes: >> On Thu, Dec 22, 2011 at 7:29 AM, Tom Lane wrote: >>> Best guess is that something sent the background writer process a >>> SIGUSR2 signal. > >> One other thought, my current setup mainly interacts with postgresql >> via

Re: [GENERAL] Trying to understand postgres crash

2011-12-22 Thread Tom Lane
Hanns Hartman writes: > On Thu, Dec 22, 2011 at 7:29 AM, Tom Lane wrote: >> Best guess is that something sent the background writer process a >> SIGUSR2 signal. > One other thought, my current setup mainly interacts with postgresql > via libpq and very rarely via psql. I have four connections o

Re: [GENERAL] Trying to understand postgres crash

2011-12-22 Thread Hanns Hartman
On Thu, Dec 22, 2011 at 7:29 AM, Tom Lane wrote: > Hanns Hartman writes: >> I'm running postgres 8.3.17 on a redhat linux mips derivative and I've >> observed a postgres crash and the subsequent messages in my postgres >> debug log. > >> 2011-12-21 19:08:49 UTC - LOG:  shutting down >> 2011-12-21

Re: [GENERAL] Trying to understand postgres crash

2011-12-22 Thread Hanns Hartman
On Wed, Dec 21, 2011 at 8:57 PM, Scott Marlowe wrote: > On Wed, Dec 21, 2011 at 5:48 PM, Hanns Hartman wrote: >> Hi, >> >> I'm running postgres 8.3.17 on a redhat linux mips derivative and I've >> observed a postgres crash and the subsequent messages in my postgres >> debug log. >> >> 2011-12-21

Re: [GENERAL] Trying to understand postgres crash

2011-12-22 Thread Tom Lane
Hanns Hartman writes: > I'm running postgres 8.3.17 on a redhat linux mips derivative and I've > observed a postgres crash and the subsequent messages in my postgres > debug log. > 2011-12-21 19:08:49 UTC - LOG: shutting down > 2011-12-21 19:08:49 UTC - PANIC: concurrent transaction log activit

Re: [GENERAL] Trying to understand postgres crash

2011-12-21 Thread Scott Marlowe
On Wed, Dec 21, 2011 at 5:48 PM, Hanns Hartman wrote: > Hi, > > I'm running postgres 8.3.17 on a redhat linux mips derivative and I've > observed a postgres crash and the subsequent messages in my postgres > debug log. > > 2011-12-21 19:08:49 UTC - LOG:  shutting down > 2011-12-21 19:08:49 UTC -s

[GENERAL] Trying to understand postgres crash

2011-12-21 Thread Hanns Hartman
Hi, I'm running postgres 8.3.17 on a redhat linux mips derivative and I've observed a postgres crash and the subsequent messages in my postgres debug log. 2011-12-21 19:08:49 UTC - LOG: shutting down 2011-12-21 19:08:49 UTC - PANIC: concurrent transaction log activity while database system is s