Request a Demo
Home   >   mailing lists

Re: [ADMIN] - Mailing list pgsql-admin

From Santiago DIEZ
Subject Re: [ADMIN]
Date
Msg-id CAJh8RqX9XDVULNafXQVe9E-zd3OpE0jKr=O2FdccKzdF=-v_eA@mail.gmail.com
Whole thread
In response to Re: [ADMIN]  (Santiago DIEZ <santiago.diez@caoba.fr>)
Responses Re: [ADMIN]
List pgsql-admin
Tree view
Hi,

Actually, port 5421 is open for localhost but not on eth0. What puzzles me is why psql is resolving localhost to 192.168.1.103 when nc is rightfully resolving it to 127.0.0.1:

$ nc -vz localhost 5421
localhost [127.0.0.1] 5421 (?) open

$ nc -vnz 192.168.1.103 5421
(UNKNOWN) [192.168.1.103] 5421 (?) : Connection refused

$ psql --host localhost --port 5421
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"

$ psql --host 127.0.0.1 --port 5421
psql: FATAL:  no pg_hba.conf entry for host "192.168.1.103", user "santiago", database "santiago"

-------------------------
Santiago DIEZ
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------

On Wed, Mar 22, 2017 at 9:28 AM, Santiago DIEZ <santiago.diez@caoba.fr> wrote:
Hi Tom,

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 ...

                        regards, tom lane


pgsql-admin by date:

Previous
From: Santiago DIEZ
Date:
Subject: Re: [ADMIN]
Next
From:
Date:
Subject: [ADMIN] pg_dump ERROR: missing chunk number 0 for toast value