Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
| От | Alexander Farber |
|---|---|
| Тема | Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 |
| Дата | |
| Msg-id | CAADeyWiWpQmcBPKtpSrmh0ZkyE3tpX-JTSr2UcBX-gO53ZM4TQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 |
| Список | pgsql-general |
Thank you, Tom -
On Sun, Dec 1, 2024 at 8:58 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Alexander Farber <alexander.farber@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 = '*'
В списке pgsql-general по дате отправления: