Re: "traditional" replication - selected databases ?

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: "traditional" replication - selected databases ?
Дата
Msg-id CAECtzeWp8OuGtWizJqe9VoLP4KU0mBKrBbrBEHS_WyVn0=Ex8A@mail.gmail.com
обсуждение исходный текст
Ответ на "traditional" replication - selected databases ?  (lejeczek <peljasz@yahoo.co.uk>)
Список pgsql-admin
Дерево обсуждения
Hi,

Le mar. 16 janv. 2024 à 09:20, lejeczek <peljasz@yahoo.co.uk> a écrit :
hi guys,

I've set up replication perhaps only a several times - and only now when I wondered I failed to sroogle a clear answer to - is possible that way to replicate only selected databases?
By "that way" I mean - nothing fixed in-between, no third-parties, pure pgSQL to pgsql.
Will it be purely & only by means of _pg_hba.conf_ (surely no..) ?


If you mean physical replication, the answer is no, you can't.

If you mean logical replication, the obvious answer is yes because you can only set it for a specific database.

Regards.


--
Guillaume.

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

Предыдущее
От: lejeczek
Дата:
Сообщение: "traditional" replication - selected databases ?
Следующее
От: Romas Kontrimas
Дата:
Сообщение: Re: failed to setup barman backup when Posgres is running in Podman Container