Reuse an existing slot with a new initdb

Поиск
Список
Период
Сортировка
От Support
Тема Reuse an existing slot with a new initdb
Дата
Msg-id 5f198805-8fd4-b49b-4046-e98fb80dea74@e-blokos.com
обсуждение исходный текст
Ответы Re: Reuse an existing slot with a new initdb
Список pgsql-general
I normalized my replislots with the name of my nodes.
I have 2 options in my recovery script that tries first pg_basebackup
to recover and sync the hot standby, but unfortunately big DB fails 
sometimes due
to very slow or unstable network. So my second option is to completely 
make a new inidb and import an sql file from pg_dumpall master as it 
takes less bytes once compressed. But I'm facing an issue with the slot 
complaining (obviously) about the ho standby node that does not match 
the slot identifier. So my question is simple, is there a way to 
reinitialize the slot to not renew the identifier with the new hot 
standby initdb?

Thanks

David



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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Thoughts on how to avoid a massive integer update.
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Thoughts on how to avoid a massive integer update.