Can't get postgres to work with drone

Drone Support
1

I’ve tried setting up a drone server using the Postgres plugin but I’m completely unable to get it working.

I’ve copied the default drone setup from the docs (adding password and sleep)

---
  kind: pipeline
  type: docker
  name: default

  steps:
    - name: test
      image: postgres:9-alpine
      commands:
        - sleep 5 #give the service some time to start
        - psql -U postgres -d test

  services:
    - name: database
      image: postgres:9-alpine
      environment:
        POSTGRES_USER: postgres
        POSTGRES_PASSWORD: password
        POSTGRES_DB: test

But I get the following error while trying to start it up

psql: 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"?

My guess is that postgres is not starting for some reason, but it’s difficult to tell.

Here is the Postgres log:

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... UTC
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
sh: locale: not found
performing post-bootstrap initialization ... No usable system locales were found.
Use the option "--debug" to see details.
ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg_ctl -D /var/lib/postgresql/data -l logfile start

waiting for server to start....LOG:  database system was shut down at 2020-05-27 08:49:09 UTC
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
 done
server started
CREATE DATABASE


/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
waiting for server to shut down....LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

LOG:  database system was shut down at 2020-05-27 08:49:11 UTC
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started

Either that or Postgres starts up fine but something kills it before other processes have the chance to connect. I’m not entirely sure though.

Any help would be appreciated.

2

One difference from the documentation [1] that jumps out is you need to provide the hostname [2] of the postgres container, otherwise the command line tools default to localhost.

  kind: pipeline
  type: docker
  name: default

  steps:
    - name: test
      image: postgres:9-alpine
      commands:
        - sleep 5 #give the service some time to start
-       - psql -U postgres -d test
+       - psql -U postgres -d test -h database

  services:
    - name: database
      image: postgres:9-alpine
      environment:
        POSTGRES_USER: postgres
        POSTGRES_PASSWORD: password
        POSTGRES_DB: test

[1] https://docs.drone.io/pipeline/docker/examples/services/postgres/
[2] https://docs.drone.io/pipeline/docker/syntax/services/#incorrect-hostname