Re: Can't change LC_CTYPE/locale

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Schuhmacher, Bret" <Bret(dot)Schuhmacher(at)Aspect(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Can't change LC_CTYPE/locale
Date: 2005-02-03 16:29:04
Message-ID: 16741.1107448144@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Schuhmacher, Bret" <Bret(dot)Schuhmacher(at)Aspect(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Schuhmacher, Bret 2005-02-03 16:44:57 Re: Can't change LC_CTYPE/locale
Previous Message Rodolfo J. Paiz 2005-02-03 15:38:25 Re: DB Error: connect failed [SOLVED]