Is it possible in PostgreSQL to set up the following replication scenarios?
Replication between 2 servers with different database name. For example, replicate FROM server_A (primary) database name
primary_productTO server_B (slave) database name
Replication between 2 servers which consist of several databases in Server_A, need to be transferred into single database with multiple schemas (custom schema name) on Server_B.
I have successfully setup replication using WAL but I would like guidance on implementing the above scenarios if possible.