Re: pgsql: Enable Unix-domain sockets support on Windows

On Sun, Jun 28, 2020 at 2:03 PM Peter Eisentraut
<peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
>
> On 2020-06-27 13:57, Amit Kapila wrote:
> > BTW, in which
> > format the path needs to be specified for unix_socket_directories? I
> > tried with '/c/tmp', 'c:/tmp', 'tmp' but nothing seems to be working,
> > it gives me errors like: "could not create lock file
> > "/c/tmp/.s.PGSQL.5432.lock": No such file or directory" on server
> > start. I am trying this on Win7 just to check what is the behavior of
> > this feature on it.
>
> Hmm, the only thing I remember about this now is that you need to use
> native Windows paths, meaning you can't just use /tmp under MSYS, but it
> needs to be something like C:\something.
>

I have tried it by giving something like that.
After giving path as unix_socket_directories = 'C:\\akapila', I get
below errors on server start:
2020-06-29 08:19:13.174 IST [4460] LOG: could not create Unix socket
for address "C:/akapila/.s.PGSQL.5432": An address incompatible with
the request
ed protocol was used.
2020-06-29 08:19:13.205 IST [4460] WARNING: could not create
Unix-domain socket in directory "C:/akapila"
2020-06-29 08:19:13.205 IST [4460] FATAL: could not create any
Unix-domain sockets
2020-06-29 08:19:13.221 IST [4460] LOG: database system is shut down

After giving path as unix_socket_directories = 'C:\akapila', I get
below errors on server start:
2020-06-29 08:24:11.861 IST [4808] FATAL: could not create lock file
"C:akapila/.s.PGSQL.5432.lock": No such file or directory
2020-06-29 08:24:11.877 IST [4808] LOG: database system is shut down

> But the error you have there
> is not even about the socket file but about the lock file, which is a
> normal file, so if that goes wrong, it might be an unrelated problem.
>

Yeah, but as I am trying this on Win7 machine, I was expecting an
error similar to what you were saying: "unsupported address family
...". It seems this error occurred after passing that phase. I am not
sure what is going on here and maybe it is not important as well
because we don't support this feature on Win7 but probably an
appropriate error message would have been good.

--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com