Hi John, Thank you for the feed back. Presently it is taking around 1hr to finish the backups. We have the wal_keep_segments set to 50. Is there way to adjust the segment size to be more than 16MB? At times I notice in
the pg_xlog, there are 10-15 segments on an invocation point. Thanx, Sam From: John Scalia [mailto:jayknowsunix@xxxxxxxxx]
More than likely your keep_wal_segments setting is too low. How long is the pg_basebackup taking? Remember that segments are generated about every 5 minutes, so if the backup takes an hour, you need at least 12 segments stored. At 2 hours,
you need 24 etc., I'd set the value to about 12.2 segments/hour of backup. -- Jay
|