I was trying to set up warm standby for an 8.1.11 instance, and was using pg_standby's -l option so that it creates
linksand does not actually copies files. After struggling for a few hours, I found two problems; one big, one small.<br
/><br/>The smaller issue is that even if we do not end the restore_command's value with a ' (quote), the restore
processstill runs just fine!<br /><br />The bigger issue, Postgres seems to not recognize links as valid files, even
thoughpg_standby was successfully able to restore them! I did not dig the issue any deeper, so cannot say if it was a
misbehavingstat() or Postgres in version 8.1 did not know how to handle symlinks!<br /><br />Just and FYI for all, and
forthe archives.<br /><br />Best regards,<br />-- <br />gurjeet[.singh]@EnterpriseDB.com<br />singh.gurjeet@{ gmail |
hotmail| indiatimes | yahoo }.com<br /><br />EnterpriseDB <a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br/><br />Mail sent from my BlackLaptop device