Re: pg respawning too fast

From: Thomas Good <tomg(at)admin(dot)nrnet(dot)org>
To: james(dot)hall(at)radioshack(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg respawning too fast
Date: 2000-07-05 14:51:15
Message-ID: Pine.LNX.4.05.10007051050030.31174-100000@admin.nrnet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 5 Jul 2000, James L. Hall wrote:

> I receive the following error continuously daily:
>
> --
> INIT: Id "pg" respawning too fast: disabled for 5 minutes
> --
>
> The line in my inittab is as follows:
>
> # Running the SQL postmaster for postgres
>
> pg:2345:respawn:/bin/su postgres -c "/usr/bin/postmaster -i -D
> /data/pgsql/data/>>/data/pgsql/server.log 2>&1" /dev/null

Remove the stale lock in /tmp ( it will be hidden: .s.PGSQL.5432)
you could add a line to rc.local or whatever to zap any stale locks
on reboot so this doesn't happen again.

--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
IS Coordinator / DBA Phone: 718-354-5528
Fax: 718-354-5056
--------------------------------------------------------------------
Powered by: PostgreSQL s l a c k w a r e FreeBSD:
RDBMS |---------- linux The Power To Serve
--------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryan Willett 2000-07-05 15:07:01 Vacuum and 24 hour availability
Previous Message Thomas Lockhart 2000-07-05 14:38:08 Re: How to lock a table