| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Bernhard Schrader <bernhard(dot)schrader(at)innogames(dot)de> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: LC_COLLATE and pg_upgrade |
| Date: | 2011-02-16 13:06:45 |
| Message-ID: | 1297861605.8578.3.camel@fsopti579.F-Secure.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On ons, 2011-02-16 at 13:14 +0100, Bernhard Schrader wrote:
> If i reinitialize the database cluster, won't i have to pg_dump restore
> my data? In this case the downtime would be to big. Therefore I'm
> searching for a faster way.
I said reinitialize your new database cluster. Since you're running
pg_upgrade, I assume your new cluster has no data in it worth keeping.
> utf8 and UTF-8, should be the same in my opinion, so i think there must
> be a way to just change this value, so that pg_upgrade can do his work,
> or is this impossible?
No, you can't change it with any reasonable effort. (You can manually
edit pg_control and recalculate the checksum, if you must. Don't do
that, though.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Gibson (DB Administrator) | 2011-02-16 18:01:47 | Re: Moving the data directory |
| Previous Message | Greg Smith | 2011-02-16 12:51:46 | Re: Moving the data directory |