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
Show quoted text
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> 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.sampaio@gmail.com>
wrote:
Show quoted text
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 thefollowed
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.sampaio@gmail.com>
wrote:
Show quoted text
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 thefollowed
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