> "ps" is not a reliable guide to the locale settings being used by
> Postgres.
Maybe it's RedHat related, I don't know.
When I had en_US in /etc/sysconfig/i18n and cs_CZ in
~postgres/.bash_profile and when I did (as root) `su - postgres -s /bin/sh
-c "echo $LANG"' I saw LANG=en_US (!!!), when I
Martin Edlman <[EMAIL PROTECTED]> writes:
> finally the problem is solved. The problem was with locales.
> I installed and initialised the database under cs_CZ, so Pg
> recorded cs_CZ in all its configurations and startup scripts.
> After that I changed /etc/sysconfig/i18n to us
Hello,
finally the problem is solved. The problem was with locales.
I installed and initialised the database under cs_CZ, so Pg
recorded cs_CZ in all its configurations and startup scripts.
After that I changed /etc/sysconfig/i18n to use en_US locale as
system default.
On Nov-04 2003, Tue, 09:24 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Tomas Szepe <[EMAIL PROTECTED]> writes:
> > Martin, you can probably rule out the cs_CZ (LATIN2) locale as the cause
> > of your problems -- I've been using that one for years on many production
> > postgres systems (often huge
Tomas Szepe <[EMAIL PROTECTED]> writes:
> Martin, you can probably rule out the cs_CZ (LATIN2) locale as the cause
> of your problems -- I've been using that one for years on many production
> postgres systems (often huge and constantly loaded) and have never observed
> the problems you're describi
On Nov-04 2003, Tue, 07:07 +0100
Martin Edlman <[EMAIL PROTECTED]> wrote:
> I use cs_CZ locale. But any of indexes we are talking about doesn't use
> czech chars, furthermore even any of these tables doesn't contain czech
> chars.
Martin, you can probably rule out the cs_CZ (LATIN2) locale as t
On Mon, 3 Nov 2003, Tom Lane wrote:
> Martin Edlman <[EMAIL PROTECTED]> writes:
> > [ unstable index behavior ]
>
> I'm wondering about hardware problems --- how sure are you that you
> don't have flaky RAM or a bad disk drive?
I'll check this, the RAID controller reports this. RAM should be OK.
Martin Edlman <[EMAIL PROTECTED]> writes:
> [ unstable index behavior ]
I'm wondering about hardware problems --- how sure are you that you
don't have flaky RAM or a bad disk drive?
Also, what locale settings are you using in the database (use
pg_controldata to verify this)? It seems possible th
