[no subject]

[Santiago DIEZ <santiago.diez@xxxxxxxx>]

Hi,

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
2017-03-21 22:34:03 CET WARNING:  autovacuum not started because of misconfiguration
2017-03-21 22:34:03 CET HINT:  Enable the "track_counts" option.
2017-03-21 22:34:03 CET LOG:  database system was shut down at 2017-03-21 22:34:03 CET
2017-03-21 22:34:04 CET LOG:  database system is ready to accept connections

Note that outside the chroot, the server is not showing any error :
2017-03-21 17:51:58 CET LOG:  database system was shut down at 2017-03-21 17:51:58 CET
2017-03-21 17:51:58 CET LOG:  database system is ready to accept connections
2017-03-21 17:51:58 CET LOG:  autovacuum launcher started

What is necessary to run statistic collector?

How should I configure my chroot?

How can I debug? (apart from setting log_min_messages to debug1 which does not help me much because I can't interpret the output).

Regards

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