From: | Jason Long <hack3rcon(at)yahoo(dot)com> |
---|---|
To: | normandavis1990(at)proton(dot)me, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Moving PostgreSQL servers to a new server |
Date: | 2024-02-29 10:57:59 |
Message-ID: | 1272053772.1292318.1709204279661@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)proton(dot)me> wrote: 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2024-02-29 10:58:31 | Re: Non-Stored Generated Columns |
Previous Message | Matthias Apitz | 2024-02-29 10:46:25 | Re: SUSE repositories not longer available |