Mailing List Archive

remote connection does not work
Dear all

Scenario: I am on an apache2 server, and I would like to connect to a
remote DB on; I plan to migrate from the apache 2
server to the remote server.? On both, I run Debian linux with
postgresql 9.6

Problem: On the apache2 server, I shut down postgresql (after I imported
the cluster on the remote server).

While I can connect via

??? psql -d davical -U davical_app -w -h -p 5432

davical when run from Apache2 cannot with the following setting in the
respectice /etc/davical/<config-file>

??? $c->pg_connect[] = "dbname=davical user=davical_app port=5432";

??? the following error is reported in the apache log

[Sun Nov 29 22:00:58.426582 2020] [:error] [pid 60889] [client] Unable to connect to database: SQLSTATE[08006] [7]
could not connect to server: No such file or directory\n\tIs the server
running locally and accepting\n\tconnections on Unix domain socket

Unclear to me: if I start the postgresql server 9.6 on the apache2
server, davical is able to retrieve the data -- ignoring the
configuration settings


1. Is my local configuration ignored in /etc/davical/<config-file> on
apache2 server?
1. How can I test, if the configuration is ignored?
2. Does davical mandatorily require a local Unix domain socket -- and
does not work with a remote db server?
3. Anything which I could take care of?

Thank you.