Re: Cygwin PostgreSQL CVS Patch

Jason Tishler <Jason.Tishler@dothill.com> writes:
>> You should be able to do something like just creating an unconnected
>> socket file and then trying to cat(1) from it ...

> I just tried the above on Linux (just to eliminate the Cygwin factor) and
> I get the following whether or not postmaster is running:

>     $ cat /tmp/.s.PGSQL.5432
>     cat: /tmp/.s.PGSQL.5432: Invalid argument

> What am I missing?

Nothing ... I hadn't actually tried that, but now that I do, I get

$ cat /tmp/.s.PGSQL.5432
cat: Cannot open /tmp/.s.PGSQL.5432: Operation not supported

so apparently you can't open a socket file except by using bind()
and so forth.  Sorry for the misinformation.

> 2. A second postmaster will exit as appropriate but will not display the
> above error message.  Instead it displays the following:

>     $ postmaster
>     Lock file "/usr/local/pgsql/data/postmaster.pid" already exists.
>     Is another postmaster (pid 385) running in "/usr/local/pgsql/data"?

That does not look like a bug; the data directory lockfile is created
first.  To test this properly, you'll need two data directories set up
so that you can start two postmasters (use the -D switch to direct each
one to the right place; you'll also need -D for initdb).  They should
start if given different port numbers (-p) or fail if the same port.
Might want to try different combinations of -i and not -i while you are
at it.

            regards, tom lane