Thread: PANIC on start

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().
Itlooks 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
------------------------------------

"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