Re: PostgreSQL Guard

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