Thread: "traditional" replication - selected databases ?
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..) ?
many thanks, L.
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..) ?
many thanks, L.
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.