[HACKERS] PANIC on start

[Marcelo Carvalho Fernandes]

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 21


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
[EMAIL PROTECTED]
Avenida Rio Branco 181 sala 1005
tel: 55-21-2532-6335
www.smartech.com.br




---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] PANIC on start

[Tom Lane]

Marcelo Carvalho Fernandes [EMAIL PROTECTED] 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

---(end of broadcast)---
TIP 8: explain analyze is your friend