Sqitch cannot connect to a running Postgres instance

Question

I have a Postgres 9.6 instance on OSX that is up and running, but Sqitch throws the following error when I try sqitch status in a working directory with a sqitch.conf:

$ sqitch status
# On database db:pg:my_db
could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

This is odd because I have already checked that Postgres is running by checking its status and logging in directly:

$ pg_isready 
/tmp:5432 - accepting connections

$ psql -U postgres
psql (9.6.19)
Type "help" for help.
postgres=#

This seems to be just a problem with sqitch.

For more detail, this Postgres was installed via brew install [email protected] and is located in the default directory:

$ which psql
/usr/local/opt/[email protected]/bin/psql

Regarding Sqitch, I have tried both installing with Homebrew and using Docker (my current approach). The docker install is based on the official instructions:

docker pull sqitch/sqitch
curl -L https://git.io/JJKCn -o sqitch && chmod +x sqitch
./sqitch status

I tried setting psql explicitly as well with sqitch config --user engine.pg.client /usr/local/opt/[email protected]/bin/psql

Regardless, I still get the following with any sqitch command:

$ sqitch status
# On database db:pg:my_db
could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

I'm not sure what I'm missing and could use some input. Thanks in advance.

See connections on Unix domain socket /var/run/postgresql/.s.PGSQL.5432 vs /tmp:5432 - accepting connections. That usually happens when programs are compiled or linked against different versions of libpq. I would try changing your connection to point at localhost instead of a socket(local). — Adrian Klaver
– Adrian Klaver, Commented Oct 27, 2020 at 20:52

theory · Accepted Answer · 2021-01-09 18:22:46Z

2

I don't know what's up with the Brew-installed Sqitch, but when you run it from the Docker image, that container does not have Postgres running inside it, so connections to localhost will fail. You instead need to connect to Postgres outside the container. If you're running it on your Mac, this is straightforward to do: Make sure Postgres is listening on the IP ports, not just a Unix domain socket, and specify host.docker.internal as the host name, like so:

sqitch status db:pg://host.docker.internal/my_db

answered Jan 9, 2021 at 18:22

theory

9,96912 gold badges68 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sqitch cannot connect to a running Postgres instance

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related