Answer the question
In order to leave comments, you need to log in
Why might the postgresql database not be replicated?
Set up standard replication between two postgresql 10.5.
There are some DB, everyone lies in separate tablespace/lvm.
One of the databases on the master has a size of 100GB on the slave 16GB.
The servers are connected, there are no errors in the log [related to the database.
the backlog in replication does not grow, all other databases are fully replicated
Answer the question
In order to leave comments, you need to log in
Do the \l+ and \dt+ conclusions in the problem base match on the master and replica?
With streaming replication, the replica is an exact binary copy of the master.
hypotheses:
the database is damaged, but there is no activity in it, and therefore
extra files on the master remain unnoticed
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question