Re: Can't change LC_CTYPE/locale - Mailing list pgsql-novice

From Tom Lane
Subject Re: Can't change LC_CTYPE/locale
Date
Msg-id 16741.1107448144@sss.pgh.pa.us
Whole thread Raw
In response to Can't change LC_CTYPE/locale  ("Schuhmacher, Bret" <Bret.Schuhmacher@Aspect.com>)
List pgsql-novice
"Schuhmacher, Bret" <Bret.Schuhmacher@Aspect.com> writes:
> I decided to drop and rebuild the db, as I'd done before.  However, no
> matter what I do this time, the db comes out as en_US.UTF-8, not "C".
> I've unset LC_CTYPE and LC_COLLATE in the env, I've set them both to C,
> I've specified the encoding and ctype on the initdb command line (see
> below), but nothing changes!

This is a stupid suggestion, but since you showed your steps and didn't
mention this one: did you remember to stop and restart the postmaster
over the initdb?

            regards, tom lane

pgsql-novice by date:

Previous
From: "Rodolfo J. Paiz"
Date:
Subject: Re: DB Error: connect failed [SOLVED]
Next
From: "Schuhmacher, Bret"
Date:
Subject: Re: Can't change LC_CTYPE/locale