Hi,
I have a strange problem when using PostgreSQL in my multithreaded
(using pthreads) application under Solaris/SPARC 8. I use PostgreSQL
7.1.3. My program has 7 different threads, each connecting to the same
database in PostgreSQL. It works most of the times, but sometimes,
connecting fails with this:
error=connectDBStart() -- connect() failed: Inappropriate ioctl for device
Is the postmaster running (with -i) at 'localhost'
and accepting connections on TCP/IP port 5432?
PostgreSQL is accepting TCP/IP on port 5432, since it does work
sometimes. The errno message (Inappropriate ioctl for device) is not
always the same.
With the same version of PostgreSQL and my program, running in Linux,
everything always works as it should.
I have edited /etc/system to raise the shared memory variables, so
that's not the problem.
Has anyone else seen this in Solaris? I have no idea how I can find
out more about it, or what to do to avoid it.
Please help,
Tomas