set initdb encoding for postgres

Question

When I try to call pg_ctl with init[db] the option for setting the encoding is not recognized:

pg_ctl init -D=D:\testdata -E=UTF8 -U=postgres
pg_ctl: illegal option -- E

Has this changed? I used latest PostgreSQL 9.6 (zip download, x64). When I don't use the -E switch everything works but the database cluster is initialized with the wrong encoding.

toraritte · Accepted Answer · 2023-04-19 21:41:31Z

7

pg_ctl does not have an option -E. If you want to run initdb through pg_ctl, you need to pass the initdb options using -o e.g. pg_ctl initdb -D ... -o "-E=UTF8"

But it's a lot easier to call initdb directly:

initdb -D=D:\testdata -E=UTF8 -U=postgres

edited Apr 19, 2023 at 21:41

toraritte

8,7054 gold badges66 silver badges101 bronze badges

answered Oct 12, 2016 at 14:31

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

set initdb encoding for postgres

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related