Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_createcluster not obeying default for socket directory

pg_createcluster not obeying default for socket directory

From
"Colin 't Hart"
Date:
Hi,

Just installed 9.3b2 from the PG group's APT repository. Because I'm
upgrading from 9.3b1 I need to recreate my cluster.

I get this warning when creating the cluster:

colin@corundum:~$ sudo pg_createcluster 9.3 main --start
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale en_US.UTF-8
Warning: The socket directory for owners other than 'postgres'
defaults to /tmp. You might want to change the unix_socket_directories parameter
in postgresql.conf to a more secure directory.
  port   5432
colin@corundum:~$

Yet, acccording to pg_createcluster when run with no arguments,

colin@corundum:~$ pg_createcluster
Usage: /usr/bin/pg_createcluster [options] <version> <cluster name>
[-- <initdb options>]

Options:
  -s <dir>      socket directory (default: /var/run/postgresql for clusters
                owned by 'postgres', /tmp for other clusters)

[other options snipped]


This seems like a bug to me. I checked -- my cluster is owned by
'postgres' as is the default.

Cheers,

Colin

Re: pg_createcluster not obeying default for socket directory

From
"Colin 't Hart"
Date:
PS

For completeness:

colin@corundum:~$ grep unix_socket_dir /etc/postgresql/9.3/main/postgresql.conf
unix_socket_directories = '/tmp'    # comma-separated list of directories
colin@corundum:~$


So despite pg_createcluster claiming that the default socket directory
for clusters owned by 'postgres' is /var/run/postgresql, it has indeed
used /tmp and as a result displays a warning.

Cheers,

Colin

Re: pg_createcluster not obeying default for socket directory

From
Christoph Berg
Date:
Re: Colin 't Hart 2013-08-01 <CAMon-aRowt7ECfd1skCHL-NqRUZ50fE_FosO=-v3WecDeF3EGw@mail.gmail.com>
> Hi,
>
> Just installed 9.3b2 from the PG group's APT repository. Because I'm
> upgrading from 9.3b1 I need to recreate my cluster.
>
> I get this warning when creating the cluster:
>
> colin@corundum:~$ sudo pg_createcluster 9.3 main --start
> Creating new cluster 9.3/main ...
>   config /etc/postgresql/9.3/main
>   data   /var/lib/postgresql/9.3/main
>   locale en_US.UTF-8
> Warning: The socket directory for owners other than 'postgres'
> defaults to /tmp. You might want to change the unix_socket_directories parameter
> in postgresql.conf to a more secure directory.

Hi Colin,

can you run a few commands so we have more details about your system?

getent passwd postgres
ls -ld /var/lib/postgresql/9.3/main /var/run/postgresql
dpkg -l 'postgresql-*common'

Christoph
--
cb@df7cb.de | http://www.df7cb.de/

Re: pg_createcluster not obeying default for socket directory

From
"Colin 't Hart"
Date:
A new week, back at work:

colin@corundum:~$ getent passwd postgres
postgres:x:104:113:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash

colin@corundum:~$ ls -ld /var/lib/postgresql/9.3/main /var/run/postgresql
ls: cannot access /var/run/postgresql: No such file or directory
drwx------ 15 postgres postgres 4096 2013-08-01 10:39
/var/lib/postgresql/9.3/main

colin@corundum:~$ sudo ls -ld /var/lib/postgresql/9.3/main /var/run/postgresql
[sudo] password for colin:
ls: cannot access /var/run/postgresql: No such file or directory
drwx------ 15 postgres postgres 4096 2013-08-01 10:39
/var/lib/postgresql/9.3/main

colin@corundum:~$ dpkg -l 'postgresql-*common'
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Cfg-files/Unpacked/Failed-cfg/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name                    Version                 Description
+++-=======================-=======================-==============================================================
ii  postgresql-client-commo 147.pgdg10.4+1          manager for
multiple PostgreSQL client versions
ii  postgresql-common       147.pgdg10.4+1          PostgreSQL
database-cluster manager



Cheers,

Colin


On 2 August 2013 10:43, Christoph Berg <cb@df7cb.de> wrote:
> Re: Colin 't Hart 2013-08-01 <CAMon-aRowt7ECfd1skCHL-NqRUZ50fE_FosO=-v3WecDeF3EGw@mail.gmail.com>
>> Hi,
>>
>> Just installed 9.3b2 from the PG group's APT repository. Because I'm
>> upgrading from 9.3b1 I need to recreate my cluster.
>>
>> I get this warning when creating the cluster:
>>
>> colin@corundum:~$ sudo pg_createcluster 9.3 main --start
>> Creating new cluster 9.3/main ...
>>   config /etc/postgresql/9.3/main
>>   data   /var/lib/postgresql/9.3/main
>>   locale en_US.UTF-8
>> Warning: The socket directory for owners other than 'postgres'
>> defaults to /tmp. You might want to change the unix_socket_directories parameter
>> in postgresql.conf to a more secure directory.
>
> Hi Colin,
>
> can you run a few commands so we have more details about your system?
>
> getent passwd postgres
> ls -ld /var/lib/postgresql/9.3/main /var/run/postgresql
> dpkg -l 'postgresql-*common'
>
> Christoph
> --
> cb@df7cb.de | http://www.df7cb.de/

Re: pg_createcluster not obeying default for socket directory

From
"Colin 't Hart"
Date:
OK, so for some weird reason /var/run/postgresql doesn't exist. I've
not created it or deleted it manually, all packages have been
installed via APT.

On 5 August 2013 10:09, Colin 't Hart <colinthart@gmail.com> wrote:
> A new week, back at work:
>
> colin@corundum:~$ getent passwd postgres
> postgres:x:104:113:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash
>
> colin@corundum:~$ ls -ld /var/lib/postgresql/9.3/main /var/run/postgresql
> ls: cannot access /var/run/postgresql: No such file or directory
> drwx------ 15 postgres postgres 4096 2013-08-01 10:39
> /var/lib/postgresql/9.3/main
>
> colin@corundum:~$ sudo ls -ld /var/lib/postgresql/9.3/main /var/run/postgresql
> [sudo] password for colin:
> ls: cannot access /var/run/postgresql: No such file or directory
> drwx------ 15 postgres postgres 4096 2013-08-01 10:39
> /var/lib/postgresql/9.3/main
>
> colin@corundum:~$ dpkg -l 'postgresql-*common'
> Desired=Unknown/Install/Remove/Purge/Hold
> | Status=Not/Inst/Cfg-files/Unpacked/Failed-cfg/Half-inst/trig-aWait/Trig-pend
> |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
> ||/ Name                    Version                 Description
> +++-=======================-=======================-==============================================================
> ii  postgresql-client-commo 147.pgdg10.4+1          manager for
> multiple PostgreSQL client versions
> ii  postgresql-common       147.pgdg10.4+1          PostgreSQL
> database-cluster manager
>
>
>
> Cheers,
>
> Colin
>
>
> On 2 August 2013 10:43, Christoph Berg <cb@df7cb.de> wrote:
>> Re: Colin 't Hart 2013-08-01 <CAMon-aRowt7ECfd1skCHL-NqRUZ50fE_FosO=-v3WecDeF3EGw@mail.gmail.com>
>>> Hi,
>>>
>>> Just installed 9.3b2 from the PG group's APT repository. Because I'm
>>> upgrading from 9.3b1 I need to recreate my cluster.
>>>
>>> I get this warning when creating the cluster:
>>>
>>> colin@corundum:~$ sudo pg_createcluster 9.3 main --start
>>> Creating new cluster 9.3/main ...
>>>   config /etc/postgresql/9.3/main
>>>   data   /var/lib/postgresql/9.3/main
>>>   locale en_US.UTF-8
>>> Warning: The socket directory for owners other than 'postgres'
>>> defaults to /tmp. You might want to change the unix_socket_directories parameter
>>> in postgresql.conf to a more secure directory.
>>
>> Hi Colin,
>>
>> can you run a few commands so we have more details about your system?
>>
>> getent passwd postgres
>> ls -ld /var/lib/postgresql/9.3/main /var/run/postgresql
>> dpkg -l 'postgresql-*common'
>>
>> Christoph
>> --
>> cb@df7cb.de | http://www.df7cb.de/