Команда IT специалистов выполнит подготовку инфраструктуры для вашего бизнеса.
Внедрение самых передовых решений и технологий.
Поддержка и сопровождение ваших сервисов.
Выполнение работ под "ключ", от покупки сервера, до настройки автоматизации процессов. 8(977)608-78-62 adm@nixm.ru
Внедрение самых передовых решений и технологий.
Поддержка и сопровождение ваших сервисов.
Выполнение работ под "ключ", от покупки сервера, до настройки автоматизации процессов. 8(977)608-78-62 adm@nixm.ru
проблемма с pgbouncer
проблемма с pgbouncer
Добрый день!
при запуске - service pgbouncer start
Redirecting to /bin/systemctl start pgbouncer.service
Job for pgbouncer.service failed because the control process exited with error code. See "systemctl status pgbouncer.service" and "journalctl -xe" for details.
systemctl status pgbouncer.service -l
● pgbouncer.service - A lightweight connection pooler for PostgreSQL
Loaded: loaded (/usr/lib/systemd/system/pgbouncer.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Tue 2016-11-29 13:01:34 EST; 1min 43s ago
Process: 4641 ExecStart=/usr/bin/pgbouncer -d -q ${BOUNCERCONF} (code=exited, status=1/FAILURE)
Nov 29 13:01:34 localhost.localdomain systemd[1]: Starting A lightweight connection pooler for PostgreSQL...
Nov 29 13:01:34 localhost.localdomain systemd[1]: pgbouncer.service: control process exited, code=exited status=1
Nov 29 13:01:34 localhost.localdomain systemd[1]: Failed to start A lightweight connection pooler for PostgreSQL.
Nov 29 13:01:34 localhost.localdomain systemd[1]: Unit pgbouncer.service entered failed state.
Nov 29 13:01:34 localhost.localdomain systemd[1]: pgbouncer.service failed.
journalctl -xe
-- Unit systemd-hostnamed.service has finished starting up.
--
-- The start-up result is done.
Nov 29 13:01:34 localhost.localdomain polkitd[823]: Registered Authentication Ag
Nov 29 13:01:34 localhost.localdomain systemd[1]: Starting A lightweight connect
-- Subject: Unit pgbouncer.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit pgbouncer.service has begun starting up.
Nov 29 13:01:34 localhost.localdomain pgbouncer[4641]: 2016-11-29 13:01:34.634 4
Nov 29 13:01:34 localhost.localdomain systemd[1]: pgbouncer.service: control pro
Nov 29 13:01:34 localhost.localdomain systemd[1]: Failed to start A lightweight
-- Subject: Unit pgbouncer.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit pgbouncer.service has failed.
--
-- The result is failed.
Nov 29 13:01:34 localhost.localdomain systemd[1]: Unit pgbouncer.service entered
Nov 29 13:01:34 localhost.localdomain systemd[1]: pgbouncer.service failed.
Nov 29 13:01:34 localhost.localdomain polkitd[823]: Unregistered Authentication
За ране спосиба за помощь
при запуске - service pgbouncer start
Redirecting to /bin/systemctl start pgbouncer.service
Job for pgbouncer.service failed because the control process exited with error code. See "systemctl status pgbouncer.service" and "journalctl -xe" for details.
systemctl status pgbouncer.service -l
● pgbouncer.service - A lightweight connection pooler for PostgreSQL
Loaded: loaded (/usr/lib/systemd/system/pgbouncer.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Tue 2016-11-29 13:01:34 EST; 1min 43s ago
Process: 4641 ExecStart=/usr/bin/pgbouncer -d -q ${BOUNCERCONF} (code=exited, status=1/FAILURE)
Nov 29 13:01:34 localhost.localdomain systemd[1]: Starting A lightweight connection pooler for PostgreSQL...
Nov 29 13:01:34 localhost.localdomain systemd[1]: pgbouncer.service: control process exited, code=exited status=1
Nov 29 13:01:34 localhost.localdomain systemd[1]: Failed to start A lightweight connection pooler for PostgreSQL.
Nov 29 13:01:34 localhost.localdomain systemd[1]: Unit pgbouncer.service entered failed state.
Nov 29 13:01:34 localhost.localdomain systemd[1]: pgbouncer.service failed.
journalctl -xe
-- Unit systemd-hostnamed.service has finished starting up.
--
-- The start-up result is done.
Nov 29 13:01:34 localhost.localdomain polkitd[823]: Registered Authentication Ag
Nov 29 13:01:34 localhost.localdomain systemd[1]: Starting A lightweight connect
-- Subject: Unit pgbouncer.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit pgbouncer.service has begun starting up.
Nov 29 13:01:34 localhost.localdomain pgbouncer[4641]: 2016-11-29 13:01:34.634 4
Nov 29 13:01:34 localhost.localdomain systemd[1]: pgbouncer.service: control pro
Nov 29 13:01:34 localhost.localdomain systemd[1]: Failed to start A lightweight
-- Subject: Unit pgbouncer.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li ... temd-devel
--
-- Unit pgbouncer.service has failed.
--
-- The result is failed.
Nov 29 13:01:34 localhost.localdomain systemd[1]: Unit pgbouncer.service entered
Nov 29 13:01:34 localhost.localdomain systemd[1]: pgbouncer.service failed.
Nov 29 13:01:34 localhost.localdomain polkitd[823]: Unregistered Authentication
За ране спосиба за помощь
Re: проблемма с pgbouncer
Не подскажите что дает опция -l в этой строчке? В мане все расплывчато,miamit писал(а): systemctl status pgbouncer.service -l
а на собственных примерах не понятно, вроде вывод один и тот же, хоть с опцией хоть без?
"I invented the term Object-Oriented and I can tell you I did not have C++ in mind." - Alan Kay
- Oleg65
- Местный говорун
- Сообщения: 859
- Зарегистрирован: 18 янв 2015, 10:56
- Откуда: г.Коломна Моск.обл.
Re: проблемма с pgbouncer
-l, --full - ну, короче, чуть более подробный вывод, без сокращенийnezabudka писал(а):Не подскажите что дает опция -l в этой строчке? В мане все расплывчато,miamit писал(а): systemctl status pgbouncer.service -l
а на собственных примерах не понятно, вроде вывод один и тот же, хоть с опцией хоть без?
-
- Местный говорун
- Сообщения: 579
- Зарегистрирован: 19 янв 2015, 15:56
- Откуда: Russian_federation, какой то
Re: проблемма с pgbouncer
кидай сюда journalctl --unit=pgbouncer, journalctl --unit=postgresql и выводы текстовых логов, что касается постгреса и pool. А ещё настройки pgbouncer, потому что ты должен запускать systemctl start $config_name@pgbouncer