From: | Santiago DIEZ <santiago(dot)diez(at)caoba(dot)fr> |
---|---|
To: | PostgreSQL LIST <pgsql-admin(at)postgresql(dot)org> |
Subject: | |
Date: | 2017-03-21 22:05:13 |
Message-ID: | CAJh8RqVB3RwxwMS2QAjLngJVy8O-Xct6Fu_mUrbUsxydXs4TXg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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*
<http://www.google.com/url?q=http%3A%2F%2Fsantiago.news.free.fr%2Flogo.png&sa=D&sntz=1&usg=AFrqEzfmW2Io3OI5IqEGiVeDRebZgD4TaQ>
-------------------------
*Quark Systems & CAOBA*
*23 rue du Buisson Saint-Louis, 75010 Paris*-------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-03-22 03:12:48 | Re: upgrade path from PG 8.3 to PG 9.5 |
Previous Message | srilinux | 2017-03-21 22:03:02 | unable to find data folder postgres9.4 |