PostgreSQL: psql: error: could not connect to server: No such file or directory

Languages Java
1

Hello,

I’m trying to get a PostgreSQL 12 Database for my build. I’ve been trying for four hours. I’ve looked at the other threads here and on StackOverFlow. But I’ve made no progress and it keeps failing.

I’m using focal so it has PostgreSQL 12.2. So I don’t need to mess with addons: postgres: '12' and apt: ...
The psql --version command works, but the psql -c 'create database ... command does not.
If I remove the psql -c 'create database ... command, my application fails to start due to the missing Database, with Caused by: org.postgresql.util.PSQLException at ConnectionFactoryImpl.java:303 Caused by: java.net.ConnectException at Net.java:-2.

Yes, I’ve read the Database Setup Documentation.
The link to the build is: lukegjpotter/pokemon-team-building-tools/jobs/480144598.
Please Help.

The relevant lines in my travis.yml file is as follows:

language: java
os: linux
dist: focal
jdk:  oraclejdk13
services:
  - postgresql
before_script:
  - cp config/database.yml.travis config/database.yml
  - psql --version
  - psql -c 'create database travis_ci_test;' -U postgres
env: DATABASE_URL=postgres://postgres:@localhost:5432/travis_ci_test

The relevant lines in my build output is as follows:

$ psql --version
psql (PostgreSQL) 12.5 (Ubuntu 12.5-0ubuntu0.20.04.1)

$ psql -c 'create database travis_ci_test;' -U postgres
psql: error: 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"?
The command "psql -c 'create database travis_ci_test;' -U postgres" failed and exited with 2 during .

Regards,
Luke

2

Are you sure it’s preinstalled?
I reckon you need to install an appropriate Apt package(s) and then configure the server if the default configuration created by Apt is not sufficient. That’s what the stock logic hangling the addons: postgresql: <number> clause does.

3

The issues is the Port Number in the error message.

connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

On some distros and postgres versions, Postgres runs on port 5432.
On dist: focal and services: postgresql the port is 5433. The psql command uses port 5432.
To solve this, you need to add the -p 5433 to the psql command:

$ psql -c 'CREATE DATABASE travis_ci_test;' -U postgres -p 5433

This will then give a new error;

psql: error: FATAL:  Peer authentication failed for user "postgres"
The command "psql -c 'CREATE DATABASE travis_ci_test;' -U postgres -p 5433" failed and exited with 2 during .

But that is an error for another day.

2 Likes