## Hamid M. (spam....@gmail.com): > postfix/trivial-rewrite[8119]: warning: connect to pgsql server > /var/run/postgresql: could not connect to server: No such file or > directory??Is the server running locally and accepting??connections on Unix > domain socket "/var/run/postgresql/.s.PGSQL.5432"??
That message is straight from libpq (PostgreSQL client library) - if you had authentication problems (password etc.) you'd get different error messages. > 2- Is there a way of achieving this authentication method that I am > missing? I can make it work if I add a password for the database user and > provide that in "virtual_alias_maps.cf" files but I was wondering if this > can be done without password since I am using local/socket-based connection? Downthread I saw that you already found the solution (moving the PostgreSQL socket inside the chroot). Let me add (for the benefit of future readers of this) that the PostgreSQL parameter setting the location of the database servers unix socket - "unix_socket_directories" - is in fact plural, that is, you can give multiple socket directories, seperated by comma, and have multiple unix sockets on your system. (That parameter became plural in PostgreSQL 9.3 (before, it was singular "unix_socket_directory"), so it's in all supported PostgreSQL releases). Regards, Christoph -- Spare Space
