BUG #13143: Cannot stop and restart a streaming server with a replication slot

Поиск
Список
Период
Сортировка
От pdrolet@infodata.ca
Тема BUG #13143: Cannot stop and restart a streaming server with a replication slot
Дата
Msg-id 20150424101006.2556.60897@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      13143
Logged by:          Patrice Drolet
Email address:      pdrolet@infodata.ca
PostgreSQL version: 9.4.1
Operating system:   Windows 2008r2
Description:

I have experienced it many times. The master streams to the slave for days
and no problem (using a replication slot). If I stop the master, it does not
want to restart and I have this error in the log:

2015-04-24 04:47:12 EDT LOG:  le système de bases de données a été arrêté à
2015-04-24 04:44:37 EDT
2015-04-24 04:47:12 EDT PANIC:  n'a pas pu synchroniser sur disque (fsync)
le fichier « pg_replslot/node_win2012sec/state » : Bad file descriptor
2015-04-24 04:47:12 EDT LOG:  processus de lancement (PID 23180) quitte avec
le code de sortie 3
2015-04-24 04:47:12 EDT LOG:  annulation du démarrage à cause d'un échec
dans le processus de lancement

To restart the server, I have to manually delete the folder in pg_replslot.
But then I need to re build the slave. Not very practical for a multi
gigabyte database.

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