From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | Jason Long <hack3rcon(at)yahoo(dot)com> |
Cc: | Pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL Guard |
Date: | 2024-02-28 05:59:20 |
Message-ID: | CANzqJaBBojWfNkLvog8gL2ik=TQchjk+N3G8dEyPMTruLDtx8Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
As before, I encourage you to read
https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/
.
On Tue, Feb 27, 2024 at 3:48 PM Jason Long <hack3rcon(at)yahoo(dot)com> wrote:
> Hi,
> Do I have to run this command on the server where the main database is
> located?
>
> Suppose you want to transfer the database of a website like Amazon.com to
> a new server and delete the old one. Many users are buying and selling on
> this website at the same time and it is not possible to turn off the
> server. What do you do to move a database to another server?
>
> On Tue, Feb 27, 2024 at 9:30 PM, Ron Johnson
> <ronljohnsonjr(at)gmail(dot)com> wrote:
> I used this web page to implement hot standby via physical streaming.
> This command sets up everything for you:
> pg_basebackup \
> --pgdata=$PGDATA \
> --dbname=service=basebackup \
> --verbose --progress \
> --checkpoint=fast \
> --write-recovery-conf \
> --wal-method=stream \
> --create-slot --slot=pgstandby1 \
> --compress=server-zstd
> I got it from
> https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/,
> which I encourage you to read.
>
> For guarding, and situations with a minimal RTO SLA, I use PgPool-II to
> manage the cluster, automatic failover and Virtual IP address. Note that
> only two database servers are needed. Install PgPool on the two DB
> servers, and a third, smaller system.
>
> There are other products which do the same thing as PgPool, and you might
> find them better.
>
> On Tue, Feb 27, 2024 at 12:00 PM Jason Long <hack3rcon(at)yahoo(dot)com> wrote:
>
> Hi,
> Should I read
> https://www.postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP
> for question number 2?
>
> On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> On 2/27/24 07:08, Jason Long wrote:
>
> > Hi,
> > 1- Both split-brain protection and security. Any tool?
> >
> > 2- Consider a database related to a website, which data is regularly
> > entered. Now you want to transfer this database to another server.
> > What's the solution?
>
>
> https://www.postgresql.org/docs/current/high-availability.html
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kyotaro Horiguchi | 2024-02-28 06:09:16 | Re: walreceiver fails on asynchronous replica [EXTERNAL] [SEC=UNOFFICIAL] |
Previous Message | veem v | 2024-02-28 04:22:53 | Re: Aligning grants and privileges |