Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving PostgreSQL servers to a new server - Mailing list pgsql-general

From Jason Long
Subject Re: Moving PostgreSQL servers to a new server
Date
Msg-id 1272053772.1292318.1709204279661@mail.yahoo.com
Whole thread Raw
In response to Moving PostgreSQL servers to a new server  (normandavis1990 <normandavis1990@proton.me>)
List pgsql-general
Tree view
Hello,
I have the same question. I hope someone can answer this question clearly.

On Wed, Feb 28, 2024 at 10:04 PM, normandavis1990
<normandavis1990@proton.me> wrote:
Hi,
I am new to PostgreSQL. My scenario is as follows:


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.

pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Re: SUSE repositories not longer available
Next
From: Laurenz Albe
Date:
Subject: Re: Non-Stored Generated Columns