From: Igor Neyman <ineyman@perceptron.com> To: Stephen Frost <sfrost@snowman.net>; Patrick Dung <patrick_dkt@yahoo.com.hk> Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>; Ivan Voras <ivoras@freebsd.org>; Tom Lane <tgl@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-owner@postgresql.org [mailto:pgsql-general- >> owner@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?