Question correct Way to switch Slave to master

Поиск
Список
Период
Сортировка
От Hauke Homburg
Тема Question correct Way to switch Slave to master
Дата
Msg-id f0becdf7-b523-f054-8086-7a255b831fdc@w3-creative.de
обсуждение исходный текст
Список pgsql-general
Hello,

I actually work on a Master Slave Server with postgresql 11 on redhat 8. 
Ich am Building the Server with Ansible.

When i need to restore the Master Server i want to build it as Slave, 
connect it to the actually master to sync the Data, and then build the 
postgres Server itself with Ansible new and start the Server with the 
synct slave data.

I don't know f i can do this without data loss?

I have read https://www.postgresql.org/docs/11/standby-settings.html so 
i think the only differenz between master and slave is the recover.conf. 
Postgres makes noch changes in the Database itself. Is this correct?

Many thanks

Hauke

-- 
www.compi-creative.net


www.libre-chat.net




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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: AutoVacuum and growing transaction XID's
Следующее
От: github kran
Дата:
Сообщение: Re: AutoVacuum and growing transaction XID's