PANIC on start

Started by Marcelo Carvalho Fernandesabout 22 years ago2 messageshackers
Jump to latest
#1Marcelo Carvalho Fernandes
mcf@smartech.com.br

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
------------------------------------

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Marcelo Carvalho Fernandes (#1)
Re: 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