Subject: Re: pg_upgrade --link on Windows
To: Bruce Momjian <bruce@momjian.us>, "Arnaud L." <arnaud.listes@codata.eu>
Cc: PG-General Mailing List <pgsql-general@postgresql.org>
References: <8da3dbd9-7daf-5589-0cc8-0eede930a492@codata.eu>
 <20170609140724.GB21215@momjian.us>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <6a638c60-90bb-4921-8ee4-5fdad68f8b09@aklaver.com>
Date: Fri, 9 Jun 2017 07:24:03 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.1.1
MIME-Version: 1.0
In-Reply-To: <20170609140724.GB21215@momjian.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

On 06/09/2017 07:07 AM, Bruce Momjian wrote:
> On Fri, Jun  9, 2017 at 12:00:56PM +0200, Arnaud L. wrote:
>> Hi
>>
>> The pg_upgrade documentation for PostgreSQL 9.6 states that --link will use
>> junction points on Windows.
>> Shouldn't it rather user hard-links ?
>> If I'm not mistaken, with junction points (i.e. soft-links to directories),
>> the old data dir cannot be removed.
>> With hard-links to file, we can get rid of the old data dir once we are sure
>> that the upgrade is fine.
> 
> I was told junction points on Windows were hard links and no one has
> ever complained about not being able to remove them.
> 

https://msdn.microsoft.com/en-us/library/windows/desktop/aa365006(v=vs.85).aspx

Seems to me the difference is hard links point to file, junctions to 
directories.

So if I am following:

https://en.wikipedia.org/wiki/NTFS_junction_point#Creating_or_deleting_a_junction_point

You remove the junction and then the directory it points to.

-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general