Re: ltree installation error

Hi all,

I've got a fatal error when i try to start postgresql service.
I debugged my scripts and the error came up right after i ran the followed
ltree installation script.
It was an attempt to install ltree on my postgresql-8.2.4

Here it's the bash commmand script:
# Install ltree
su - postgres -c "cd /usr/local/src/postgresql-8.2.4/contrib/ltree && make
install"
su - postgres -c "psql -U postgres -f ltree.sql template1"

here it's the log at the server.log

LOG: database system was shut down at 2007-12-19 00:19:26 EST
LOG: checkpoint record is at 0/42C424
LOG: redo record is at 0/42C424; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/593; next OID: 10820
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: received fast shutdown request
LOG: shutting down
LOG: database system is shut down
FATAL: invalid value for parameter "lc_messages": "en_CA.UTF-8"

does anyone have any idea what could be wrong?
it seems my debian distro doesn;t suport UTF-8 messages.
my box is debian etch 4. postgresql 8.2.4

regards,
iuri

"Iuri Sampaio" <iuri(dot)sampaio(at)gmail(dot)com> writes:
> I've got a fatal error when i try to start postgresql service.
> I debugged my scripts and the error came up right after i ran the followed
> ltree installation script.

There's nothing in what you show that seems to have anything to do with
ltree. Are you sure the installation was working at all? It looks to
me that you've got a locale configuration problem.

regards, tom lane

No, I´m not sure.
Assuming i´ve got a locale problem, how do i get rid of it?
re-installing postgres??
I already tried that a couple of times and it didn´t succeed
is it an option to re-install my OS (debian etch)?
or just apt-get the respective locale support?

iuri

On Wed, 2007-12-19 at 00:29 -0500, Tom Lane wrote:
> "Iuri Sampaio" <iuri(dot)sampaio(at)gmail(dot)com> writes:
> > I've got a fatal error when i try to start postgresql service.
> > I debugged my scripts and the error came up right after i ran the followed
> > ltree installation script.
>
> There's nothing in what you show that seems to have anything to do with
> ltree. Are you sure the installation was working at all? It looks to
> me that you've got a locale configuration problem.
>
> regards, tom lane

iuri de araujo sampaio <iuri(dot)sampaio(at)gmail(dot)com> writes:
> No, Im not sure.
> Assuming ive got a locale problem, how do i get rid of it?
> re-installing postgres??
> I already tried that a couple of times and it didnt succeed
> is it an option to re-install my OS (debian etch)?
> or just apt-get the respective locale support?

You need to be sure that LANG is set to something valid (ie, something
listed by "locale -a") when you initdb.

regards, tom lane

Hi Tomm
I don;t understand how it's related with postgresql installation. I never
had this problem before.
My locale is set:

debian:~# locale -a
C
en_US.utf8
POSIX

iuri de araujo sampaio <iuri ( dot ) sampaio ( at ) gmail ( dot ) com> writes:
> No, I´m not sure.
> Assuming i´ve got a locale problem, how do i get rid of it?
> re-installing postgres??
> I already tried that a couple of times and it didn´t succeed
> is it an option to re-install my OS (debian etch)?
> or just apt-get the respective locale support?

You need to be sure that LANG is set to something valid (ie, something
listed by "locale -a") when you initdb.

regards, tom lane

On Dec 18, 2007 10:48 PM, iuri de araujo sampaio <iuri(dot)sampaio(at)gmail(dot)com>
wrote:

> No, I´m not sure.
> Assuming i´ve got a locale problem, how do i get rid of it?
> re-installing postgres??
> I already tried that a couple of times and it didn´t succeed
> is it an option to re-install my OS (debian etch)?
> or just apt-get the respective locale support?
>
>
> iuri
>
> On Wed, 2007-12-19 at 00:29 -0500, Tom Lane wrote:
> > "Iuri Sampaio" <iuri(dot)sampaio(at)gmail(dot)com> writes:
> > > I've got a fatal error when i try to start postgresql service.
> > > I debugged my scripts and the error came up right after i ran the
> followed
> > > ltree installation script.
> >
> > There's nothing in what you show that seems to have anything to do with
> > ltree. Are you sure the installation was working at all? It looks to
> > me that you've got a locale configuration problem.
> >
> > regards, tom lane
>
>

Hi Tomm
I don;t understand how it's related with postgresql installation. I never
had this problem before.
My locale is set:

debian:~# locale -a
C
en_US.utf8
POSIX

iuri de araujo sampaio <iuri ( dot ) sampaio ( at ) gmail ( dot ) com>
writes:
> No, I´m not sure.
> Assuming i´ve got a locale problem, how do i get rid of it?
> re-installing postgres??
> I already tried that a couple of times and it didn´t succeed
> is it an option to re-install my OS (debian etch)?
> or just apt-get the respective locale support?

You need to be sure that LANG is set to something valid (ie, something
listed by "locale -a") when you initdb.

regards, tom lane

On Dec 18, 2007 10:48 PM, iuri de araujo sampaio <iuri(dot)sampaio(at)gmail(dot)com>
wrote:

> No, I´m not sure.
> Assuming i´ve got a locale problem, how do i get rid of it?
> re-installing postgres??
> I already tried that a couple of times and it didn´t succeed
> is it an option to re-install my OS (debian etch)?
> or just apt-get the respective locale support?
>
>
> iuri
>
> On Wed, 2007-12-19 at 00:29 -0500, Tom Lane wrote:
> > "Iuri Sampaio" <iuri(dot)sampaio(at)gmail(dot)com> writes:
> > > I've got a fatal error when i try to start postgresql service.
> > > I debugged my scripts and the error came up right after i ran the
> followed
> > > ltree installation script.
> >
> > There's nothing in what you show that seems to have anything to do with
> > ltree. Are you sure the installation was working at all? It looks to
> > me that you've got a locale configuration problem.
> >
> > regards, tom lane
>
>