Search Postgresql Archives

Question correct Way to switch Slave to master

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux