Hitoshi Harada wrote:
> The problem isn't in libpq, since it is that the server doesn't listen
> on startup as above. No /tmp/.s.PGSQL.5432, nor LISTENING entry in
> netstat.
I find this somewhat implausible. The postmaster has this code that
makes it die if it can't open a listening socket:
if (ListenSocket[0] == PGINVALID_SOCKET) ereport(FATAL, (errmsg("no socket created
forlistening")));
Perhaps you could strace the execution.
Of course, pg_regress doesn't usually run on port 5432, IIRC, so maybe
you're looking for the wrong thing.
Another question worth asking is whether or not either SELinux or
firewall settings on your CentOS box are interfering with connectivity.
cheers
andrew