V
V
Vladimir2019-03-06 10:37:13
linux
Vladimir, 2019-03-06 10:37:13

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

1 answer(s)
M
Melkij, 2019-03-06
@melkij

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 question

Ask a Question

731 491 924 answers to any question