PostgreSQL doesn't stop propley when --slot option is specified with pg_receivexlog.
От | |
---|---|
Тема | PostgreSQL doesn't stop propley when --slot option is specified with pg_receivexlog. |
Дата | |
Msg-id | A9C510524E235E44AE909CD4027AE196BF7D6FB274@MBX-MSG-SV03.msg.nttdata.co.jp обсуждение исходный текст |
Ответы |
Re: PostgreSQL doesn't stop propley when --slot option is
specified with pg_receivexlog.
|
Список | pgsql-hackers |
Hi, "pg_ctl stop" does't work propley, if --slot option is specified when WAL is flushed only it has switched. These processes still continue even after the posmaster failed:pg_receivexlog, walsender and logger. How to reproduce: 1.Start PostgreSQL 2.Create slot 3.Specify --slot option to pg_receivexlog and start it 4.Stop PostgreSQL Example commands for reproduce: 1.pg_ctl start 2.psql -c "select pg_create_physical_replication_slot('test');" 3.pg_receivexlog --slot='test' -D ./testdir 4.pg_ctl stop This happen cause --slot option set a flush location to feedback messages, but it only flush when wal has switched, so walsender wait for the WAL have been replicated forever. When --slot option is not specified, 'invalid' is set to flush location and it use write location to check replication soit can stop the process propley. So I thought set 'invalid' to flush location as well in this case, this problem will be solved. Does --slot option need to set flush location? Thought? Regards, -- Furuya Osamu
В списке pgsql-hackers по дате отправления: