Streaming replication - unable to stop the standby

Поиск
Список
Период
Сортировка
От Stefan Kaltenbrunner
Тема Streaming replication - unable to stop the standby
Дата
Msg-id 4BDF1042.302@kaltenbrunner.cc
обсуждение исходный текст
Ответы Re: Streaming replication - unable to stop the standby  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Streaming replication - unable to stop the standby  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
I'm currently testing SR/HS in 9.0beta1 and I noticed that it seems 
quite easy to end up in a situation where you have a standby that seems 
to be stuck in:

$ psql -p 5433
psql: FATAL:  the database system is shutting down

but not not actually shuting down ever. I ran into that a few times now 
(mostly because I'm trying to chase a recovery issue I hit during 
earlier testing) by simply having the master iterate between a pgbench 
run and "idle" while simple doing pg_ctl restart in a loop on the standby.
I do vaguely recall some discussions of that but I thought the issue git 
settled somehow?


Stefan


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Show schema in COPY error CONTEXT strings
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Streaming replication - unable to stop the standby