Postgres Pro
Downloads
Home   >   mailing lists

Thread: locale error

locale error

From
César Eduardo Schneider
Date:

I have instaled a new system and I´m trying to restore my old database.

I get this error:

postgres@server:/usr/local/pgsql/bin$ ./postmaster -D /home/pgsql.old/
Failed to initialize lc_messages to ''
PANIC:  The database cluster was initialized with LC_CTYPE 'pt_BR',
        which is not recognized by setlocale().
        It looks like you need to initdb.
Aborted

somebody know what is happing and how can I solve this.

I need this database in production as soon as possible.

thank´s for comments.

Cesar


Busca Yahoo!
O serviço de busca mais completo da Internet. O que você pensar o Yahoo! encontra.

Re: locale error

From
Tony Grant
Date:
On Wed, 2003-02-12 at 09:15, César Eduardo Schneider wrote:

> I get this error:
>
> postgres@server:/usr/local/pgsql/bin$ ./postmaster -D /home/pgsql.old/
> Failed to initialize lc_messages to ''
> PANIC:  The database cluster was initialized with LC_CTYPE 'pt_BR',
>         which is not recognized by setlocale().
>         It looks like you need to initdb.
> Aborted
>
> somebody know what is happing and how can I solve this.

Find postgresql.conf

Go to the bottom

Remove the locale stuff

Restart

Cheers

Tony Grant

--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL

Re: locale error

From
Oliver Elphick
Date:
On Wed, 2003-02-12 at 14:15, César Eduardo Schneider wrote:
> I have instaled a new system and I´m trying to restore my old
> database.
>
> I get this error:
>
> postgres@server:/usr/local/pgsql/bin$ ./postmaster -D /home/pgsql.old/
> Failed to initialize lc_messages to ''
> PANIC:  The database cluster was initialized with LC_CTYPE 'pt_BR',
>         which is not recognized by setlocale().
>         It looks like you need to initdb.
> Aborted
>
> somebody know what is happing and how can I solve this.

It looks as though you have not enabled the use of the locale pt_BR on
that machine.  In some systems, locales must be specifically enabled.
See if you have the program locale-gen on your system.


--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "When I consider thy heavens, the work of thy fingers,
      the moon and the stars, which thou hast ordained; What
      is man, that thou art mindful of him? and the son of
      man, that thou visitest him? For thou hast made him a
      little lower than the angels, and hast crowned him
      with glory and honour."            Psalms 8:3-5

Re: locale error

From
César Eduardo Schneider
Date:

I did this...

the same error appears :(

and about this error:

> Failed to initialize lc_messages to ' '

there is something that I can install to solve this ?

thanks

Cesar

 Tony Grant <tony@tgds.net> wrote:

On Wed, 2003-02-12 at 09:15, César Eduardo Schneider wrote:

> I get this error:
>
> postgres@server:/usr/local/pgsql/bin$ ./postmaster -D /home/pgsql.old/
> Failed to initialize lc_messages to ''
> PANIC: The database cluster was initialized with LC_CTYPE 'pt_BR',
> which is not recognized by setlocale().
> It looks like you need to initdb.
> Aborted
>
> somebody know what is happing and how can I solve this.

Find postgresql.conf

Go to the bottom

Remove the locale stuff

Restart

Cheers

Tony Grant

--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


Busca Yahoo!
O serviço de busca mais completo da Internet. O que você pensar o Yahoo! encontra.