Search Postgresql Archives

Re: Problems Restarting PostgreSQL Daemon

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>  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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux