Re: pg_standby -l might destory the archived file

Tom Lane wrote:
> Fujii Masao <masao(dot)fujii(at)gmail(dot)com> writes:
>> pg_standby can use ln command to restore an archived file,
>> which might destroy the archived file as follows.
>
> Does it matter? pg_standby's source area wouldn't normally be an
> "archive" in the real sense of the word, it's just a temporary staging
> area between master and slave. (If it were being used as a real
> archive, keeping it on the same disk as the live slave seems pretty
> foolish anyway, so the case wouldn't arise.)

It seems perfectly sane to source pg_standby directly from the archive
to me. And we're talking about symbolic linking, so the archive
directory might well be on an NFS mount.

(I haven't looked at the issue yet)

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com