Is it possible to replicate from 10 postgres servers to one shared server?

Question

PostgreSQL

Good afternoon.
Prompt how to perform replication more correctly.
There are 10 small postgres servers and a large powerful server. Is it possible to use docker to run separate postgres instances? Or is there a chance to ditch the data in the container? or it is more reliable to create one server and 10 clusters.
Or perhaps there are some other options to parallelize the whole thing?

Answer 1

how to replicate better

What do you want?
Regular logical replication (pg 10 and higher) or through pglogical or even triggered replication can replicate to one database. Correct introduction of DDL at your own expense.
For physical replication - replication is strictly 1:1, because different database instances. Any docker is absolutely not needed for this. You deploy replicas in different directories and on different listen ports and that's it. In ubuntu/debian, there are even regular pg_ctlcluster scripts to make it convenient to steer instances.