Thank you, Tom - On Sun, Dec 1, 2024 at 8:58 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Alexander Farber <alexander.far...@gmail.com> writes: > > TLDR "psql words_de" works, but "psql -h localhost words_de" does not > > I'd try connecting the first way and seeing what "show > listen_addresses" gives. Per your report it should be "*", > but maybe something is overriding that. > > If it is "*", then it seems like something is interfering with > expanding that. Maybe try explicitly setting it to "localhost"? > it is empty in my docker container (but "localhost" on my prod server), so I probably need to investigate that... $ psql words_de psql (17.2) Type "help" for help. words_de=> show listen_addresses; listen_addresses ------------------ (1 row) words_de=> set listen_addresses='localhost'; ERROR: parameter "listen_addresses" cannot be changed without restarting the server # grep listen_addresses $PGDATA/postgresql.conf listen_addresses = '*'
