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 links and does not actually copies files. After struggling for a few hours, I found two problems; one big, one small.
The smaller issue is that even if we do not end the restore_command's value with a ' (quote), the restore process still runs just fine! The bigger issue, Postgres seems to not recognize links as valid files, even though pg_standby was successfully able to restore them! I did not dig the issue any deeper, so cannot say if it was a misbehaving stat() or Postgres in version 8.1 did not know how to handle symlinks! Just and FYI for all, and for the archives. Best regards, -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com Mail sent from my BlackLaptop device
