Sometimes we might see postgres DB between the nodes in the cluster not initiated properly.

It is expected to sync itself during restart operation once its up but sometime it may not sync completely.

So we have to manually sync it through Patroini

dbstatus command will show you the status of the DB sync status between the nodes

"docker ps" command will list the services run in the docker container, find the container ID of the postgres service

E.g

Then login to the postgres DB

Now reinit the postgres service through patroini one by one for the postgres DB to which you see unknown in the table.

Here we see postgres2,3,4 and 5 are in unknown state, so we need to apply this command 4 times for each postgres DB

When it asks for the reinitialization, just enter one postgres DB at a time and repeat this command "patronictl reinit versaecp" until you applied this command for all the postgres DBs which are in unknown state

E.g

Now the DB state is going to reconvene and the TimeLag is going to get adjusted

Now the timeLag will be in sync with the leader and all the postgres will be in running state

Note the above operation is supposed to be performed in one of the nodes but not in all the nodes