Обсуждение: Could not start server

Hi all,
I had a postgresql 8.4 running under a Freebsd 8.0 since this morning.
I rebooted the machine this morning and then, it can't start postgresql.
I tried to run it manually but it doesn't (the error message is just :
Could not start server)
I tried to rebuilt from the ports but still nothing, always the same error.
What could I do ?
Thanks in advance


--
Sometimes the light at the end of the tunnel is an oncoming train

On 07/15/2010 02:46 PM, Luiz Eduardo Cantanhede Neri wrote:
> You may check the logs and see what happened.
>
Thanks for the reply,
I did and in /var/log/message I have :

Jul 15 14:49:24 mgeeph08 postgres[16044]: [6-1]  -  - PANIC:  XX000:
could not locate a valid checkpoint record
Jul 15 14:49:24 mgeeph08 postgres[16044]: [6-2]  -  - LOCATION:
StartupXLOG, xlog.c:5367
Jul 15 14:49:24 mgeeph08 kernel: pid 16044 (postgres), uid 70: exited on
signal 6 (core dumped)

What does it mean ?


--
Tovo J. RABEMANANTSOA
INRA - UR1263 EPHYSE
71, Av. Edouard Bourlaux
F-33140 Villenave d'Ornon - France
Téléphone : +33 5 57 12 24 09

On 07/15/2010 02:51 PM, Tovo J. RABEMANANTSOA wrote:
> On 07/15/2010 02:46 PM, Luiz Eduardo Cantanhede Neri wrote:
>> You may check the logs and see what happened.
>>
> Thanks for the reply,
> I did and in /var/log/message I have :
>
> Jul 15 14:49:24 mgeeph08 postgres[16044]: [6-1]  -  - PANIC:  XX000:
> could not locate a valid checkpoint record
> Jul 15 14:49:24 mgeeph08 postgres[16044]: [6-2]  -  - LOCATION:
> StartupXLOG, xlog.c:5367
> Jul 15 14:49:24 mgeeph08 kernel: pid 16044 (postgres), uid 70: exited on
> signal 6 (core dumped)
>
> What does it mean ?
>
>
Thank you very much,
I ran the pg_resetxlog command. Apparently, it solved my problem

Note for later : always RTFM before asking :-)
--
Tovo J. RABEMANANTSOA
INRA - UR1263 EPHYSE
71, Av. Edouard Bourlaux
F-33140 Villenave d'Ornon - France
Téléphone : +33 5 57 12 24 09