Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade link mode - Mailing list pgsql-general

From AI Rumman
Subject Re: pg_upgrade link mode
Date
Msg-id CAGoODpcCmzNfvzRd17a6a4u0F+xYa_6JceVDOBivjzj0bBAcsA@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade link mode  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: pg_upgrade link mode  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Tree view
I told you I would never go for a production with link mode. However, I was working with pg_upgrade copy mode and in the middle I got an error saying missing some extensions. I rollback and start the operation after setting everything up.
I don't know how it will behave in link mode if you fail in the middle.


On Thu, May 16, 2013 at 2:03 PM, Igor Neyman <ineyman@perceptron.com> wrote:

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of AI Rumman
Sent: Thursday, May 16, 2013 1:56 PM
To: Fabio Rueda Carrascosa
Cc: pgsql-general
Subject: Re: [GENERAL] pg_upgrade link mode

I always think its a bit risky to use link instead of copying. However, I'd suggest to try the  --check at first of pg_upgrade.

--------------------------------------------------------------

Why?
Do you have specific experience, when link mode caused any problems?
Could you share?

Regards,
Igor Neyman

pgsql-general by date:

Previous
From: Oscar Calderon
Date:
Subject: About replacing PostgreSQL instance
Next
From: Lonni J Friedman
Date:
Subject: Re: pg_upgrade link mode