[ADMIN]

Поиск
Список
Период
Сортировка
От Santiago DIEZ
Тема [ADMIN]
Дата
Msg-id CAJh8RqVB3RwxwMS2QAjLngJVy8O-Xct6Fu_mUrbUsxydXs4TXg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [ADMIN]  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
 
-------------------------
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------

В списке pgsql-admin по дате отправления:

Предыдущее
От: srilinux
Дата:
Сообщение: [ADMIN] unable to find data folder postgres9.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] upgrade path from PG 8.3 to PG 9.5