Postgres 8.1 doesn't like pg_standby's -l option

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "PGSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Postgres 8.1 doesn't like pg_standby's -l option
Date: 2008-07-11 04:23:17
Message-ID: 65937bea0807102123g1503b14ck635f3d437aff5f8d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Urbański 2008-07-11 06:18:25 Re: gsoc, text search selectivity and dllist enhancments
Previous Message Oleg Bartunov 2008-07-10 23:12:48 Re: gsoc, text search selectivity and dllist enhancments