Re: Problems Restarting PostgreSQL Daemon

Поиск
Список
Период
Сортировка
От Jeff Soules
Тема Re: Problems Restarting PostgreSQL Daemon
Дата
Msg-id c956da920807220926w7904f6c4y75e2d3f5cc121bb2@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problems Restarting PostgreSQL Daemon  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
>  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@appl-ecosys.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

В списке pgsql-general по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Problems Restarting PostgreSQL Daemon
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: Using ISpell dictionary - headaches...