From: | "Colin 't Hart" <colinthart(at)gmail(dot)com> |
---|---|
To: | "pgsql-pkg-debian(at)postgresql(dot)org" <pgsql-pkg-debian(at)postgresql(dot)org> |
Subject: | Re: pg_createcluster not obeying default for socket directory |
Date: | 2013-08-05 08:16:49 |
Message-ID: | CAMon-aQCn_o2SzKE=QSTtk+T8nYsCueyJ9EdEx56x=xpQNqmAg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-pkg-debian |
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(at)gmail(dot)com> wrote:
> A new week, back at work:
>
> colin(at)corundum:~$ getent passwd postgres
> postgres:x:104:113:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash
>
> colin(at)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(at)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(at)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(at)df7cb(dot)de> wrote:
>> Re: Colin 't Hart 2013-08-01 <CAMon-aRowt7ECfd1skCHL-NqRUZ50fE_FosO=-v3WecDeF3EGw(at)mail(dot)gmail(dot)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(at)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(at)df7cb(dot)de | http://www.df7cb.de/
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2013-08-24 00:09:03 | Dependency bugs in postgresql-9.3 packages -- RC1 does not install |
Previous Message | Colin 't Hart | 2013-08-05 08:09:09 | Re: pg_createcluster not obeying default for socket directory |