Moving PostgreSQL servers to a new server

From: normandavis1990 <normandavis1990(at)proton(dot)me>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Moving PostgreSQL servers to a new server
Date: 2024-02-28 18:32:48
Message-ID: QtNsYvqZb67mXfuY4JeC_u5YkXoaRSDOjXw0xRzS3QprBHWcwAaSXjnXS8wdb9TKqjQaq4M5eMOr8tP_IpXfi3g1mfvvXEOjQwVthwibzLg=@proton.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I am new to PostgreSQL. My scenario is as follows:

https://cdn.bloghunch.com/uploads/uNxNoi5uVKeDibd5.webp

I have a Master server and two Replica (Replica-1 and Replica-2) servers. One of these Replica servers is in read-only mode and a report is prepared from it using Microsoft PowerBI. Due to a series of issues, I want to transfer the Master server and one of the Replica servers to other servers in two steps, but I don't want to have any interruptions.
A) Assuming PostgreSQL is installed on the new server, what should I do first to migrate the Master? Please show me a tutorial and share your experiences.

B) After transferring the Master, I want to transfer one of the Replica servers. What should I do to transfer this server?

Cheers.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2024-02-28 18:35:05 Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working
Previous Message Matthew Dennison 2024-02-28 18:27:47 Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working