Re: PostgreSQL upgrade -> fails to start server

From: "Miquel van Smoorenburg" <miquels(at)cistron(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL upgrade -> fails to start server
Date: 2003-08-29 14:52:29
Message-ID: binpbd$p8v$1@news.cistron.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <20030829095837(dot)GA24442(at)freshdot(dot)net>,
Sander Smeenk <ssm+pgsql(at)freshdot(dot)net> wrote:
>Hi,
>
>After a very recent postgresql update, the postmaster failed to start
>because of this:
>
>| PANIC: The database cluster was initialized with LC_CTYPE
>| 'nl_NL(at)euro(dot)UTF-8', which is not recognized by setlocale().
>| It looks like you need to initdb.
>
>Is there some way that I can get to my precious databases?

You have the source. Find where it prints this, make it not panic
but continue, recompile, run that server, run psql, drop the indexes,
dump the database.

Mike.
--
RAND USR 16514

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francois Suter 2003-08-29 15:12:42 Re: Visual database structure browser for postgresql?
Previous Message Jonathan Bartlett 2003-08-29 14:51:47 Re: left outer join terrible slow compared to inner join