Hot synchron backup doesn't start

From: "hans wulf" <lotu1(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Hot synchron backup doesn't start
Date: 2012-04-04 20:30:33
Message-ID: 20120404203033.38200@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to set up a replication server that shall handle synchronized commits. I stopped my master database, copied all the 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 (The WAL id only changes every few minutes, is that normal?). The last entry in the logfiles of the slave says "redo starts at XYZ"

Does the master resend the hole database in WAL format? For tests I started a delte command for one sigle entry, but it just doesn'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 general mistake I did, because between taking the copy and restarting the instances no or only a few tiny transactions where commited.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jon Nelson 2012-04-04 20:58:30 Re: views, queries, and locks
Previous Message Jay Levitt 2012-04-04 20:19:08 Re: Switching to Homebrew as recommended Mac install?