3 ms·

Hmm I think the default pg_hba.conf uses "trust" and so will allow passwordless connections as postgres on localhost, you just have to specify the username (psq

Hmm I think the default pg_hba.conf uses "trust" and so will allow passwordless connections as postgres on localhost, you just have to specify the username (psql will use your username by default) This is the case for the official docker image at least, and I'm fairly certain also true of distro package managers

deleted 6y ago
[deleted]
boromisp 6y ago
At least on debian / ubuntu, the default is peer auth: https://salsa.debian.org/postgresql/postgresql-common/-/blob/c1bc1fd53edb76a36c05dd71c19fad384e209041/pg_createcluster#L79 https://salsa.debian.org/postgresql/postgresql-common/-/blob...