Skip site navigation (1) Skip section navigation (2)

Re: startup subprocess hangs

From: "Anjan Dave" <adave(at)vantage(dot)com>
To: "Andrew Janian" <ajanian(at)scottrade(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: startup subprocess hangs
Date: 2005-06-17 20:32:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Probably some kind of a hardware issue (you lost a path to the array for
e.g.), or someone may have issued a kill -9 to postmaster?


Open another terminal and check the system log (/var/log/messages) if
you are not redirecting logs anywhere.


Can you paste the console messages on the list so people can see what
exactly might be going on?





From: Andrew Janian [mailto:ajanian(at)scottrade(dot)com] 
Sent: Friday, June 17, 2005 4:21 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] startup subprocess hangs


I am running Postgres 7.4.5 and I have recently run into a problem.  My
database was running fine for days and then today in the middle of the
day it seems that the startup subprocess kicked in and started
recovering.  I am not sure from what, and I am not sure how it started,
but nothing was allowed to connect and it has been running for quite
some time (30 minutes).  The process said it was starting to recover,
but how long am I to wait?


Is there a way to get the status?


Can I just skip the recovery and get it going?


The environment is RH EL 3 2.4.21-4.ELsmp, with and EMC SAN for storage
and QLogix cards for fibre access.





pgsql-admin by date

Next:From: Andrew JanianDate: 2005-06-17 20:36:45
Subject: Re: startup subprocess hangs
Previous:From: Andrew JanianDate: 2005-06-17 20:21:05
Subject: startup subprocess hangs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group