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

Responses

  • Re: at 2017-03-22 03:23:41 from Tom Lane

Browse pgsql-admin by date

  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