Question correct Way to switch Slave to master - Mailing list pgsql-general

From Hauke Homburg
Subject Question correct Way to switch Slave to master
Date
Msg-id f0becdf7-b523-f054-8086-7a255b831fdc@w3-creative.de
Whole thread Raw
List 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 by date:

Previous
From: David Rowley
Date:
Subject: Re: AutoVacuum and growing transaction XID's
Next
From: github kran
Date:
Subject: Re: AutoVacuum and growing transaction XID's