Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(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 19:24:04
Message-ID: 2117.1347477844@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Henry C." <henka(at)cityweb(dot)co(dot)za> writes:
> Anyway, thanks for the feedback. Ok, so it's simply a case of:
> update pg_database set datcollate='C', datctype='C';
> Correct? Mine are all POSIX, so no where clause needed.

Yeah, that should do it.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2012-09-12 19:27:16 bgwriter and pg_locks
Previous Message Henry C. 2012-09-12 19:05:22 Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch