I'm trying to set up a replication server that shall handle synchronized commits. I stopped my master database, copied
allthe files to the slave, added a recovery.conf, started the master with synchronized_commit = on and then started the
slave.
I would prusume because the slave is nearly up to date, that the catching up would run in a few seconds.
Now it's been half a day and I still see WAL sender and WAL receiver transfering data if I hit the linux ps command
(TheWAL id only changes every few minutes, is that normal?). The last entry in the logfiles of the slave says "redo
startsat XYZ"
Does the master resend the hole database in WAL format? For tests I started a delte command for one sigle entry, but it
justdoesn't come to an end. Through the ps command I can also see other transactions waiting for ages.
My question: Is this normal? Or did I do something wrong? Is there a change of speeding things up? I guess it must be a
generalmistake I did, because between taking the copy and restarting the instances no or only a few tiny transactions
wherecommited.
I don't use any WAL archives.
Maybe a side question: Can the slave catch up without any base backup or some really old one when no WAL archive
exists?Does the master translate its current state into some fake WAL to transfer via TCP?
--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de