I'm running Postgres 15 and the current CRAN RPostgres on debian 12.
When I do:
> con <- dbConnect(Postgres())
I get the following:
Error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
I confirmed via psql that the database is running and accessible with current user.
Some poking around:
$ netstat -nlp | grep 5432
shows the socket at /var/run/postgresql/.s.PGSQL.5432
I was able to get a successful dbConnect() after doing:
$ ln -s /var/run/postgresql/.s.PGSQL.5432 /tmp
I'm running Postgres 15 and the current CRAN RPostgres on debian 12.
When I do:
I get the following:
I confirmed via psql that the database is running and accessible with current user.
Some poking around:
$ netstat -nlp | grep 5432shows the socket at
/var/run/postgresql/.s.PGSQL.5432I was able to get a successful
dbConnect()after doing:$ ln -s /var/run/postgresql/.s.PGSQL.5432 /tmp