Re: PostgreSQL upgrade -> fails to start server - Mailing list pgsql-general

From Sander Smeenk
Subject Re: PostgreSQL upgrade -> fails to start server
Date
Msg-id 20030829141931.GE25611@freshdot.net
Whole thread Raw
In response to Re: PostgreSQL upgrade -> fails to start server  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL upgrade -> fails to start server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Quoting Tom Lane (tgl@sss.pgh.pa.us):

> > To make a long story short: i can't activate that locale again,
> Why not?  Undoing whatever you did to the locale setup seems a lot
> easier task than any other option that's open to you.

The nl_NL@euro.UTF-8 locale I used 'back then' is incorrect. It's not a
real locale, and the newer versions of libc6 and locales that I have
installed now don't support the generation of this faulty locale.

I would have to figure out what release of libc6 and locales did
generate this faulty locale, and then install that version, just HOPING
that all the other services i'm running still function with that release
of libc6. And because this situation is on my colocated machine, i'd
rather not have it crash just before the weekend :)

And seeing that nl_NL@euro.UTF-8 was an UTF-8 locale, and nl_NL.UTF-8
(which is correct) is an UTF-8 locale too, I thought that it wouldn't
really hurt much if I tried replacing that value in pg_control.

> I would *not* recommend hand-editing pg_control, even if you got the
> CRC correct.

It is a desperate attempt to get my data out.

> There is a reason why we put in code to prevent on-the-fly
> changes of locale: it corrupts your indexes.

Yes, well, it also forbids me to save my data now :)
And theres no --yes-i-know-this-is-stupid-but-please-let-me-do-this option.

Sander.
--
| Wat als je je twee keer half dood schrikt ?
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8  9BDB D463 7E41 08CE C94D

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cannot drop table ordre because other objects depend on it
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Fast Table Replication / Mirroring