Обсуждение: Unix sockets permissions problem

Поиск
Список
Период
Сортировка

Unix sockets permissions problem

От
Ian Burrell
Дата:
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



Re: Unix sockets permissions problem

От
Peter Eisentraut
Дата:
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

Re: Unix sockets permissions problem

От
"Chris Timm"
Дата:
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


Re: Unix sockets permissions problem

От
Jason Tishler
Дата:
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

Re: Unix sockets permissions problem

От
Ian Burrell
Дата:
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