Re: pg respawning too fast

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