Re: Understanding the behaviour of hostname in psql
| От | Marco Craveiro |
|---|---|
| Тема | Re: Understanding the behaviour of hostname in psql |
| Дата | |
| Msg-id | AANLkTinVGTnCJ8AkjbHues3KeSwg-qTqSkiHaFDpfAuq@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Understanding the behaviour of hostname in psql (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-novice |
> It looks to me like "localhost" is getting resolved as the IPv6 > loopback address (::1), which for some reason you've configured > differently than the IPv4 loopback address in your pg_hba.conf: > >> host all all 127.0.0.1/32 trust >> host all all ::1/128 md5 ah yes, good point - i was just ignoring IPv6 altogether. school boy error! > I'm not sure why your "ping" example doesn't reflect that --- maybe you > have an IPv4-only version of ping? But if you're unconvinced you could > turn on log_connections and see where the server sees the connection as > coming from. well, setting IPv6 to trust too fixed my problem. i'll keep log_connections in mind for future problems though. thanks a lot for your time. cheers -- The key to Understanding complicated things is to know what not to look at, and what not to compute, and what not to think. -- Abelson & Sussman, SICP blog: http://mcraveiro.blogspot.com
В списке pgsql-novice по дате отправления: