Re: PostgreSQL upgrade -> fails to start server

Quoting Sander Smeenk (ssm+pgsql@freshdot.net):

> > Postgres already has a -P option to disable system indexes. Would it be
> > feasable to have a safe mode so that if your locale is broken it sets that
> > flag and also sets enable_indexscan to false. This would at least give you
> > enough to pg_dump things.
> Also see my post to Miquel on this list. I'd really like to see such an
> option. Even though i'll try hard not to have this problem ever again.
> So. I'll be hacking postgresql sources today ;)

Well, not really that day, but today I hacked postgresql :)

Line 2261 in src/backend/access/transam/xlog.c changed from

-    if (setlocale(LC_CTYPE, ControlFile->lc_collate) == NULL)

to

+    if (setlocale(LC_CTYPE, "nl_NL.UTF-8") == NULL)

rebuilt the debian package, made backups, installed it and:

-rw-r--r--    1 postgres postgres  8461201 Sep  3 22:38 db.all.sql

The dump looks all normal! Guess I was lucky that the 'wrong' locale the
db was initialised with was also 100% nl_NL.UTF-8 aparently :)

I'll go re-create the database then, and try to import the dump.

Thanks everyone for all the ideas!
Sander.
--
| I must consider my sins...
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8  9BDB D463 7E41 08CE C94D