Question correct Way to switch Slave to master

From: Hauke Homburg <hhomburg(at)w3-creative(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Question correct Way to switch Slave to master
Date: 2020-05-08 04:47:34
Message-ID: f0becdf7-b523-f054-8086-7a255b831fdc@w3-creative.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message github kran 2020-05-08 06:06:55 Re: AutoVacuum and growing transaction XID's
Previous Message David Rowley 2020-05-08 04:04:19 Re: AutoVacuum and growing transaction XID's