Re: Problems Restarting PostgreSQL Daemon

> I tried following the logic, and it appears the issue now is 'invalid data
> in PID file "/var/lib/pgsql/data/postmaster.pid" '. If I delete that file,
> is it automatically recreated?

Why not just move it and rename it? If it's recreated, great; if not,
you still have the corrupted file on hand to try to fix, no?

On Tue, Jul 22, 2008 at 11:15 AM, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
> On Tue, 22 Jul 2008, Tom Lane wrote:
>
>> The short answer is probably "don't use Slackware's startup script". Some
>> distros have PG start scripts that have had the bugs beaten out of them,
>> and others not so much.
>
> Excellent advice, Tom. I'll take it.
>
>> Have you read the script to see what condition causes it to issue the
>> mentioned error? I'd imagine that it's looking at some other lockfile
>> than you think.
>
> I tried following the logic, and it appears the issue now is 'invalid data
> in PID file "/var/lib/pgsql/data/postmaster.pid" '. If I delete that file,
> is it automatically recreated? I'm using /usr/bin/pg_ctl as user postgres.
>
> Thanks,
>
> Rich
>
> --
> Richard B. Shepard, Ph.D. | Integrity Credibility
> Applied Ecosystem Services, Inc. | Innovation
> <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>