Thanks for the response, Tom. Looks like the problem was a bad
directory given to pg_ctl for my start script. It was pointing to
/usr/local/pgsql/data, not /var/lib/pgsql/data. I think I might've had
two identical databases in different directories... Seems to be fixed
now, though.
I appreciate your time! :-)
Rgds,
Bret
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, February 03, 2005 11:29 AM
> To: Schuhmacher, Bret
> Cc: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] Can't change LC_CTYPE/locale
>
> "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
>