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
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 |