[Pgcluster-general] Recovery option -r doesn't work correct

[Düster Horst]

Since a while I'm playing with PGCluster mostly with success. But one
issue leads to a litte bit confusion. The recovery doesn't produce the
expected results.

Question: What is the reason for backing up the whole DB files with the
recovery option -R. For large DB it needs large time to recover the
Cluster and huge amount of disk space. In my opinion it doesn't make
sense to use rsync in this case because the advantage of rsync is
incremental sync. But there isn't any increment for rsync due to the
copy of all relevant directories to backup directories.

I took a look at the source and found out the -r option. Recovery
without backup. Great but in my version of PGCluster 1.5.0rc16 option -r
starts a pg_dump process. It seems to be a bug. After uncommenting all
lines which decides to backup or not in src/backend/libpq/recovery.c the
-R option doesn't produce a backup and rsync works very fast all 2
stages of recovery. 

Perhaps someone else outside has a solution for my problem?

Best regards

Dr. Horst Düster
GIS-Koordinator, Stv. Amtschef

Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
SO!GIS Koordination
Rötistrasse 4
CH-4501 Solothurn

Telefon ++41(0)32 627 25 32
Telefax ++41(0)32 627 22 14

mailto:horst.duester at bd.so.ch
http://www.agi.so.ch


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20070724/07957a29/attachment.html