________________________________
From: Igor Neyman <iney...@perceptron.com>
To: Stephen Frost <sfr...@snowman.net>; Patrick Dung <patrick_...@yahoo.com.hk>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>; Ivan Voras
<ivo...@freebsd.org>; Tom Lane <t...@sss.pgh.pa.us>
Sent: Saturday, September 14, 2013 2:14 AM
Subject: RE: [GENERAL] Major upgrade of PostgreSQL and MySQL
Hi Igor,
>> -----Original Message-----
>> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
>> ow...@postgresql.org] On Behalf Of Stephen Frost
>> Sent: Friday, September 13, 2013 2:06 PM
>> To: Patrick Dung
>> Cc: pgsql-general@postgresql.org; Ivan Voras; Tom Lane
>> Subject: Re: [GENERAL] Major upgrade of PostgreSQL and MySQL
>>
>>
>> > 3. But the way, if users is using Windows, is the link option still works?
>>
>> Don't think so, but not sure. pg_upgrade could be made to work in a truely
>> "in-place" method if there's demand for it and someone wants to work on it.
>> It'd clearly be a bit more *dangerous*, of course..
>>
>> Thanks,
>>
>> Stephen
>
>Like I said in the other message, actually in-place upgrade using symbolic
>links work quite fine under Windows.
>I tested it carefully many times, and used it even more upgrading production
>systems.
>I don't feel it's *dangerous*, especially considering that my whole upgrade
>process always starts with backing up existing cluster.
>
For Windows, is it using symbolic links or hard links for the upgrade?
If symbolic links is used, would users have difficultly when deleting the old
cluster?
Thanks,
Patrick