Thank you, Tom -
On Sun, Dec 1, 2024 at 8:58 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Alexander Farber <alexander.farber@xxxxxxxxx> 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 = '*'