This guide covers configuring continuous integration pipelines for projects that have a Postgres dependency. If you’re new to Drone please read our Tutorial and build configuration guides first.
In the below example we demonstrate a pipeline that launches a Postgres service container. The database server will be available at
database:5432, where the hostname matches the service container name.
The official Postgres image provides environment variables used at startup to create the default username, password, database and more. Please see the official image documentation for more details.
If you are unable to connect to the Postgres container please make sure you are giving Postgres adequate time to initialize and begin accepting connections.
You cannot use
localhost to connect with the Postgres container. If you are unable to connect to the Postgres container please verify you are using the correct hostname, corresponding with the name of the postgres service container.
steps: - name: test image: postgres commands: - sleep 15 - psql -U postgres -d test -h localhost
steps: - name: test image: postgres commands: - sleep 15 - psql -U postgres -d test -h database