Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg respawning too fast

pg respawning too fast

From
"James L. Hall"
Date:
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

My setup is redhat 5.2, kernel 2.2.2, postgres 6.5

Is this ~really~ a problem, i.e. can I just pipe the errors to /dev/null
and forget about it, or is there some way to correct this? I have seen a
post similar to this on the list, but if I recall that error was in the
syntax.

All info is greatly appreciated!
T.I.A.-
Jim

Re: pg respawning too fast

From
Thomas Good
Date:
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
--------------------------------------------------------------------

Re: pg respawning too fast

From
Jesus Aneiros
Date:
Why don't you use the script in /etc/rc.d/init.d/postgresql
It is a topic in the Linux FAQ, I think you should read it.

Jesus.

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
>
> My setup is redhat 5.2, kernel 2.2.2, postgres 6.5
>
> Is this ~really~ a problem, i.e. can I just pipe the errors to /dev/null
> and forget about it, or is there some way to correct this? I have seen a
> post similar to this on the list, but if I recall that error was in the
> syntax.
>
> All info is greatly appreciated!
> T.I.A.-
> Jim
>