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

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