Hi,

I have a PostgreSQL (7.3) with lots of databases. I can't start it after a
power failure. Iï¿½m trying this...

NS2 - /var/lib/pgsql/data >pg_ctl start
postmaster successfully started
PANIC:  The database cluster was initialized with LC_CTYPE 'pt_BR',
        which is not recognized by setlocale().
        It looks like you need to initdb.
/usr/bin/pg_ctl: line 392:   569 Aborted                 "$po_path"
${1+"$@"} </dev/null 2>&1


But PostgreSQL doesn't start and the files /tmp/.s.PGSQL.5432,
/tmp/.s.PGSQL.5432.lock and /var/lib/pgsql/postmaster.pid are created.

Does any one could help me ?


------------------------------------
Smart Tech Consulting
Marcelo Carvalho Fernandes
Diretor de Sistemas
mcf@smartech.com.br
Avenida Rio Branco 181 sala 1005
tel: 55-21-2532-6335
www.smartech.com.br
------------------------------------



Wed, 10 Mar 2004 15:59:24 -0300
"Marcelo Carvalho Fernandes" <mcf@smartech.com.br>
PANIC on start
"Marcelo Carvalho Fernandes" <mcf@smartech.com.br> writes:
> I have a PostgreSQL (7.3) with lots of databases. I can't start it after a
> power failure. I�m trying this...

> NS2 - /var/lib/pgsql/data >pg_ctl start
> postmaster successfully started
> PANIC:  The database cluster was initialized with LC_CTYPE 'pt_BR',
>         which is not recognized by setlocale().

Kinda looks like your locale definition file has gone missing.  Probably
reinstalling the locale stuff would help.  (On Red Hat Linux I think
this is part of the glibc-common RPM ... but YMMV on other platforms.)

			regards, tom lane

Thu, 11 Mar 2004 01:53:39 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: PANIC on start 