Example Postgres Configuration
Updated 2 years ago
by
Admin
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.
Basic Example
In the below example we demonstrate a pipeline that launches a Postgres service container. The server will be available at localhost:5432
1 kind: pipeline
2 type: kubernetes
3 name: default
4
5 steps:
6 - name: test
7 image: postgres:9-alpine
8 commands:
9 - psql -U postgres -d test
10
11 services:
12 - name: database
13 image: postgres:9-alpine
14 environment:
15 POSTGRES_USER: postgres
16 POSTGRES_DB: test
Database Settings
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.
1 services:
2 - name: database
3 image: postgres
4 environment:
5 POSTGRES_USER: postgres
6 POSTGRES_DB: test
Common Problems
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.
1 kind: pipeline
2 type: kubernetes
3 name: default
4
5 steps:
6 - name: test
7 image: postgres
8 commands:
9 - sleep 15
10 - psql -U postgres -d test
