Postgresql localhost:port socket issue

09 April 2024, 23:46:14

Advance apologies for this cross-post -- i am checking out Artix for the first time, specifically Artix/dinit and posted originally in that subforum's dinit-tracker thread.. but on second consideration am not sure if this is an Artix Postgres issue in general..

--
Despite the first (dinit-tracker) post referencing Postgres, i have had no such luck with postgres/postgres-dinit.

Attempting to start postgres failed on no postgresql.conf -- /var/lib/postgres/data was empty. This may be normal -- i manually initialized /var/lib/postgres/data by running initdb.

However, after doing so, attempting to dinitctl start postgres fails on the dreaded "could not translate host name "localhost", service "5432" to address: Name or service not known" error. i noticed a user running Artix/runit also has run into this recently in my 2 days of culling the internet for solutions. My /etc/hosts file has the standard 127.0.0.1 and ::1 assignments for localhost.

What am i missing? Is there some other package dependency that postgres relies on to properly create the socket?

This is a clean install of Artix/dinit. It has been awhile since i've been on an arch based distro -- been on Alpine and Void the past few years -- and i am quite liking Artix/dinit so far but this has me stumped.

Re: Postgresql localhost:port socket issue

Reply #1 – 15 April 2024, 13:58:10

Staring too long at my /etc/hosts..

It ultimately was caused by an error further down in the file caused by a hosts file merge.