Postgres 8.1 doesn't like pg_standby's -l option
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,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device