I
I
IDepresnakI2020-01-27 08:09:37
PostgreSQL
IDepresnakI, 2020-01-27 08:09:37

How to replicate databases with the same name in Postgres?

Hello, there are several servers with the same database names on Postgres, is it possible to organize replication of these databases on one slave server and will there be a conflict due to the identical database name?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2020-01-27
@melkij

Physical replication: it is impossible to
replicate several masters into one slave;
you can run the required number of replicas on different ports of one system. Base names are accordingly indifferent.
Logical replication:
I would be very surprised if different base names would be a problem for some of the implementations of logical replication. But logical replication is logical replication. It will be necessary to remember about DDL operations and make them accordingly.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question