Need help : pgsql HA issues

Поиск
Список
Период
Сортировка
От Shital A
Тема Need help : pgsql HA issues
Дата
Msg-id CAMp7vw8ocX7JLkMnAjGOAkbkTzEmOFcb1SYY_wHJ+DZzVoYpPQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-general

Hello All,

We are in process of testing a Postgres 9.6 active-passive HA cluster using streaming replication on Rhel 7.5.

We are seeing below issue with the setup :

1. When a failover is triggered  while data is being added to the primary by killing primary (killall -9 postgres), the failed node is restarted to but doesn't start streaming. It starts in disconnect mode. We checked and notice that the wal receiver process is not started. Need help in

1. To check why the wal receiver process is not stated ? Is killed -9 leaving some processes uncleaned because of which the walk receiver is not starting ?

2. How can we simulate abrupt shut down of postgresql ? We want to simulate case where primary goes down abruptly


Please share any pointers if you have.

Thanks

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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: Arrays and ANY problem
Следующее
От: Joe Horsnell
Дата:
Сообщение: Behaviour adding a column with and without a default (prior to PG11)