[GENERAL] Fwd: PostgreSQL 9.4.13 is facing issue in shutting down

Поиск
Список
Период
Сортировка
От Abhijit Gharami
Тема [GENERAL] Fwd: PostgreSQL 9.4.13 is facing issue in shutting down
Дата
Msg-id CAA5_DuD0O1XyM8OnOzhRepyPU-t8nZKLzs1pT2JpzP0NS+vVNA@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] [BUGS] Fwd: PostgreSQL 9.4.13 is facing issue in shutting down  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi,

Recently we have updated our PostgreSQL version from 9.4.12 to 9.4.13. With version 9.4.13 while trying to stop the PostgreSQL server, database is facing issues in shutting down. The problem probably occurs because of the WAL sender process not getting terminated on shutdown request. 

ps output:
postgre+  7915  0.0  1.9 589772 39528 ?        S<   09:11   0:00 /..../bin/postgres -D /.../postgresql -h 0.0.0.0 -p 5432
postgre+  8617  0.0  0.4 590760  8344 ?        S<s  09:13   0:00 postgres: wal sender process replicator xx.xx.xx.xxx(45948) streaming 0/4000090    


Sequence of events in log:
FATAL:  terminating connection due to administrator command
LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down
FATAL:  the database system is shutting down
FATAL:  the database system is shutting down
FATAL:  the database system is shutting down
FATAL:  the database system is shutting down
FATAL:  the database system is shutting down
FATAL:  the database system is shutting down
FATAL:  the database system is shutting down
FATAL:  the database system is shutting down

We are using pg_ctl fast mode to shutdown the postgres server.

Regards,
Abhijit







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

Предыдущее
От: Dylan Luong
Дата:
Сообщение: Re: [GENERAL] pg_rewind - restore new slave failed to startup duringrecovery
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [GENERAL] [BUGS] Fwd: PostgreSQL 9.4.13 is facing issue in shutting down