Re: Replication mode

Поиск
Список
Период
Сортировка
От Azimuddin Mohammed
Тема Re: Replication mode
Дата
Msg-id CAKUuFd72Daabtt4Hyyd7Nr_vUEVkN82Q8wJpdCkCBwC63ZS4yQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication mode  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Ответы Re: Replication mode  (scott ribe <scott_ribe@elevated-dev.com>)
Re: Replication mode  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-admin
Thanks! 
But with hot standby my slave will be in read-only mode ...how can I just use my slave as a backup and not do any read operation and let my primary server do all read and write operation. If my primary fails I will do manual failover. The whole idea is to remove any 3rd party open source tools as we are not sure how well they behave and avoid any single point of failure. 

On Jan 10, 2018 4:11 PM, "Mark Kirkwood" <mark.kirkwood@catalyst.net.nz> wrote:
On 11/01/18 11:00, Peter Eisentraut wrote:

On 1/10/18 15:24, Azimuddin Mohammed wrote:
May I know what is the core difference between HOT standby. Warm Stand by ?
In PostgreSQL, "hot standby" is a mode for an instance in recovery that
allows read-only commands to be executed on it.  The term "warm standby"
is not used by PostgreSQL, but you could think of a server in recovery
that does not allow queries to be a warm standby, if you wish.


We do talk about 'warm standby' in the docs:

https://www.postgresql.org/docs/10/static/warm-standby.html

...altho we do not precisely say how to setup this up as opposed to the 'hot' variant. In fact it is pretty easy to (accidentally) get a warm standby by forgetting to set :

standby_mode = 'on'

in recovery.conf

Cheers

Mark

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Replication mode
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Replication mode