Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Henry C(dot)" <henka(at)cityweb(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
Date: 2012-09-12 20:03:10
Message-ID: 20120912200310.GA32353@momjian.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 12, 2012 at 09:54:57PM +0200, Henry C. wrote:
>
> Thanks to all who responded - upgrade was successful!
>
> One final note, when using pg_upgrade ... --link, it finally recommends
> use of delete_old_cluster.sh to remove the old data files. I'm tempted,
> but --link re-uses old data files,... bit of a contradiction there, if you
> follow my meaning?
>
> Is use of delete_old_cluster.sh ok if --link used with pg_upgrade?

Link creates hard links between the old and new cluster. Removing the
old cluster just changes the file link count from 2 to 1. Is there a
way to make that clearer?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2012-09-12 20:24:21 how long to wait on 9.2 bitrock installer?
Previous Message Henry C. 2012-09-12 19:54:57 Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch