homebrew-postgresql icon indicating copy to clipboard operation
homebrew-postgresql copied to clipboard

Can't set --auth-host and --auth-local in initdb_options in createcluster.conf

Open ijmorlan opened this issue 8 months ago • 0 comments

I tried to do this in createcluster.conf:

initdb_options = '--locale C --encoding UTF8 --data-checksums --auth-host=scram-sha-256 --auth-local=peer'

But the generated pg_hba.conf still use md5 (my other settings come through nicely). Looking closely at the output I realized why:

Creating new PostgreSQL cluster 16/test5 ... /usr/local/opt/postgresql@16/bin/initdb --locale C --encoding UTF8 --data-checksums --auth-host=scram-sha-256 --auth-local=peer -D /usr/local/var/lib/postgresql/16/test5 --auth-local peer --auth-host md5

Would it be possible to pass the initdb_options to initdb after the default ones so they take precedence?

ijmorlan avatar Jun 04 '24 18:06 ijmorlan