Re: Solaris/Sparc: Regression test fails

"Stefan Brozinski" <Stefan.Brozinski@materna.de> writes:
> Reviewing the files in ./src/test/regress/results shows that tests
> (timestamp,interval,abstime) displayed the same symptom:

> psql: connectDBStart() -- connect() failed: Connection refused
>         Is the postmaster running locally
>         and accepting connections on Unix socket '/tmp/.s.PGSQL.65432'?

Solaris is known to have problems with the parallel regression tests
when running them via Unix-socket connections.  If you tweak the
pg_regress.sh script to use TCP connections (there is already a case
statement that does that for some other platforms that haven't got Unix
sockets at all), you should find that it passes.

The underlying difficulty seems to be that Solaris rigidly enforces the
listen-queue limit for Unix sockets, and the postmaster isn't able to
shuffle off connections to child processes fast enough when the
regression script hits it with 20 nigh-simultaneous connection requests.
This should be alleviated in 7.2, which both increases the listen()
parameter and has the postmaster fork almost immediately.

You could try increasing the value passed to listen() in
src/backend/libpq/pqcomm.c if you want to verify this theory.
Or install 7.2rc2.

            regards, tom lane