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

From Tom Lane
Subject Re: PostgreSQL upgrade -> fails to start server
Date
Msg-id 16866.1062166155@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL upgrade -> fails to start server  (Sander Smeenk <ssm+pgsql@freshdot.net>)
Responses Re: PostgreSQL upgrade -> fails to start server  (Sander Smeenk <ssm+pgsql@freshdot.net>)
Re: PostgreSQL upgrade -> fails to start server  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Sander Smeenk <ssm+pgsql@freshdot.net> writes:
> 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.

I would *not* recommend hand-editing pg_control, even if you got the
CRC correct.  There is a reason why we put in code to prevent on-the-fly
changes of locale: it corrupts your indexes.  You might be able to get
the postmaster to start, but that wouldn't mean you could trust the
output of pg_dump.

            regards, tom lane

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: mysql's last_insert_id
Next
From: Tom Lane
Date:
Subject: Re: Cannot drop table ordre because other objects depend on it