Re: PostgreSQL Guard

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: PostgreSQL Guard
Дата
Msg-id CANzqJaBe8wfOdBsYTEyNaXgdUdUsyeT0GU1OsNAC1YS6Cks7kw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Guard  (Jason Long <hack3rcon@yahoo.com>)
Ответы Re: PostgreSQL Guard
Список pgsql-general
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

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@yahoo.com> wrote:
Hi,

On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver
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.klaver@aklaver.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Dominique Devienne
Дата:
Сообщение: Re: PQftype(copy_rset) returns zero OIDs???
Следующее
От: Greg Sabino Mullane
Дата:
Сообщение: Re: PostgreSQL Guard