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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment