Thread: Unix sockets permissions problem
Does anyone know what the problem with the permissions for Unix sockets with PostgreSQL and Cygwin? The socket file /tmp/.s.PGSQL.5432 is always created with 700 permissions. This means that it is not accessible to normal users. It is possible to change the permissions with the chmod command: chmod a+rwx /tmp/.s.PGSQL.5432 Is this a bug in Cygwin? Cygipc? PostgreSQL? What needs to be done to get it fixed? - Ian
Ian Burrell writes: > Does anyone know what the problem with the permissions for Unix sockets > with PostgreSQL and Cygwin? The socket file /tmp/.s.PGSQL.5432 is > always created with 700 permissions. This means that it is not > accessible to normal users. Change unix_socket_permissions in postgresql.conf (and possibly check the system umask). -- Peter Eisentraut peter_e@gmx.net
Unsubscribe remove
-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of Peter Eisentraut
Sent: 21 July 2003 08:58
To: Ian Burrell
Cc: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] Unix sockets permissions problem
Ian Burrell writes:
> Does anyone know what the problem with the permissions for Unix
sockets
> with PostgreSQL and Cygwin? The socket file /tmp/.s.PGSQL.5432 is
> always created with 700 permissions. This means that it is not
> accessible to normal users.
Change unix_socket_permissions in postgresql.conf (and possibly check
the
system umask).
--
Peter Eisentraut peter_e@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Ian, On Fri, Jul 18, 2003 at 03:18:38PM -0700, Ian Burrell wrote: > Is this a bug in Cygwin? Yes. > What needs to be done to get it fixed? Upgrade to Cygwin 1.5.0. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Jason Tishler wrote: > On Fri, Jul 18, 2003 at 03:18:38PM -0700, Ian Burrell wrote: > >>Is this a bug in Cygwin? > > Yes. > >>What needs to be done to get it fixed? > > > Upgrade to Cygwin 1.5.0. > I upgraded to Cygwin 1.5.0 and that fixed the problem. For other people, Cygwin 1.5.0 is currently marked as experimental. You can either switch the installer to install experimental packages. Or select the version of the cygwin package by clicking on it. - Ian