Search Postgresql Archives

Re: Is it possible to control the location of the lock file when starting postgres?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 7/20/2016 10:44 AM, Steve Langlois wrote:
Why is the local connection not working without having to add host ::1/128 to the pg_hba.conf file. I thought specifying local all all trust would allow any local connection.

local != localhost...  on your system localhost is resolving to the ipv6 ::1, rather than the ipv4 127.0.0.1  but these are both still tcp/ip 'host' connections.   'local' is used for unix domain socket connections, which are when you don't specify any hostname (or specify a socket path starting with /)

you never did answer my previous question, why are you messing about with manually starting postgres from the wrong user account, when it should be run as a system service with systemctl ?

    $ sudo systemctl start service.postgresql-9.1

and if you want it to auto-start on reboot,

    $ sudo systemctl enable service.postgresql-9.1


-- 
john r pierce, recycling bits in santa cruz

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux