Re: Updating default PostgreSQL server encoding from SQL_ASCII to UTF8

[Greg Troxel <gdt%lexort.com@localhost>]

Luis Falcon <falcon%gnuhealth.org@localhost> writes:

> I noticed that NetBSD 11 initializes postgreSQL cluster with SQL_ASCII as
> the default encoding.
>
> I think it would be good to use unicode UTF8 encoding by default.
> Although we can always overwrite the encoding when creating a new db,
> it's easy to forget and many times the SQL_ASCII encoding will take us
> to trouble.
>
> Just to test, I updated two lines in /etc/rc.d/pgsql
>
> Added:
> args_init="-o '--encoding=UTF8'"

My first question would be:

  If you build postgresql from sources on NetBSD, and you follow their
  instructions, what do you end up with?

and if that's not how you think it should be, that should be addressed
with upstream.