Re: Postmaster failed to start and/or accept connexion

Поиск
Список
Период
Сортировка
От Laurent Ballester
Тема Re: Postmaster failed to start and/or accept connexion
Дата
Msg-id 000901c3fb8e$0d0cb410$3f21fdc1@fleche
обсуждение исходный текст
Ответ на Postmaster failed to start and/or accept connexion  ("Laurent Ballester" <postgresql.ballester@wanadoo.fr>)
Ответы Re: Postmaster failed to start and/or accept connexion
Список pgsql-hackers-win32
> You need to specify '-i' (not '-I'), then it works (for me). You could
also do
> this in postgresql.conf, IMHO.
>
> Do you also see the backends claiming more and more memory until crashing?
I
> can't yet put my fingers on the reason.
>

Hi,



First, thank you for your help.



I launch postmaster with -i, it was a typo error in my previous mail.



To summarize, I have two different errors types:



1)      postmaster crash at start up because it "could not attach to proper
memory at fixed address: shmget(key=5432001, addr=014D0000) failed: No such
file or directory"



I update postgresql.conf with max_connections = 5 and now this error does
not appear too much.



2)      If I launch postmaster again, it start and listen to port 5432, I
have only a warning "select() failed in statistics collector"  before
"database system is ready". After a quick reading of source code, it doesn't
seem too important.



On a client side, "psql template1" or "createdb mydb" failed to connect to
postmaster. The error was "server closed the connection unexpectedly..."
while the server said "could not receive data from client: No such file or
directory, incomplete startup packet".



I continue to investigate.



Regards,

Laurent Ballester


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

Предыдущее
От: Joerg Hessdoerfer
Дата:
Сообщение: Re: Postmaster failed to start and/or accept connexion
Следующее
От: Joerg Hessdoerfer
Дата:
Сообщение: Re: Postmaster failed to start and/or accept connexion