Thread: 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.sampaio@gmail.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.sampaio@gmail.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.sampaio@gmail.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
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> writ=
es:
> No, I=C2=B4m not sure.
> Assuming i=C2=B4ve 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=C2=B4t 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.sampaio@gmail.com>
wrote:
> No, I=B4m not sure.
> Assuming i=B4ve 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=B4t 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.sampaio@gmail.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=C2=B4m not sure. > Assuming i=C2=B4ve 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=C2=B4t 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.sampaio@gmail.com> wrote: > No, I=B4m not sure. > Assuming i=B4ve 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=B4t 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.sampaio@gmail.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 > >