Re: Postmaster failed to start and/or accept connexion

> 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