Scot Kreienkamp wrote:
>> You could try to "strace" the postmaster during a connection attempt
>> and see what happens. Maybe that helps to spot the place where
>> things go wrong.
> [Scot Kreienkamp]
> I'm willing to give it a try, but I've never done it before. What do
I need to do?
"man strace" is your friend. Assuming you are on Linux.
Find out the process ID of the postmaster process
(the parent of the other PostgreSQL processes),
then try
strace -f -o /some/large/directory/tracefile -p process_id
The connect to PostgreSQL and see what gets logged.
Press Ctrl+C to stop strace.
Yours,
Laurenz Albe