Thanks for your advice. I'm indeed only able to connect to the cluster from outside the chroot using unix sockets like:
$ psql --host /jail/tmp --port 5421 mydb
If I try and force a TCP/IP connexion, it fails with: $ psql --host localhost --port 5421 mydb psql: could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5421? FATAL: no pg_hba.conf entry for host "192.168.1.103", user "santiago", database "santiago"
I have mounted /dev, /proc and /sys inside the chroot. What else could be necessary to allow TCP/IP connections to postgresql?
Regards
------------------------- Santiago DIEZ +33 6 37 90 81 98 ------------------------- ------------------------- Quark Systems & CAOBA 23 rue du Buisson Saint-Louis, 75010 Paris -------------------------
On Wed, Mar 22, 2017 at 4:23 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Santiago DIEZ <santiago.diez@caoba.fr> writes: > I'm trying to execute postgresql inside a chroot environment. > initdb runs OK > pg_ctl runs OK and server can be queried.
> But, the logs show : > 2017-03-21 22:34:03 CET LOG: could not receive test message on socket for > statistics collector: Connection refused > 2017-03-21 22:34:03 CET LOG: disabling statistics collector for lack of > working socket
Apparently there's some aspect of your chroot setup that breaks TCP connections to "localhost". You need to fix that ...