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