-
-
Notifications
You must be signed in to change notification settings - Fork 3
115 lines (101 loc) · 3.12 KB
/
postgres.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
# https://docs.github.com/en/actions/guides/creating-postgresql-service-containers
name: PostgreSQL
on: push
jobs:
postgres-container:
runs-on: ubuntu-latest
container: node
services:
postgres:
image: postgres
env:
POSTGRES_PASSWORD: postgres
# Set health checks to wait until postgres has started
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
env:
PGHOST: postgres
PGUSER: postgres
PGDATABASE: postgres
PGPASSWORD: postgres
steps:
- name: Install postgresql-client
run: |
apt-get update
apt-get install --yes postgresql-client
- name: Connect to PostgreSQL with CLI
run: psql -c 'SELECT VERSION();'
- name: Show max connections
run: psql -c 'SHOW max_connections;'
- name: Install pg
run: npm install pg
- name: Connect to PostgreSQL with Node.js
run: |
cat > client.js << EOF
const pg = require('pg');
const client = new pg.Client();
client.connect();
client.query('SELECT VERSION()').then((result) => {
console.log(result.rows[0]);
client.end();
});
EOF
node client.js
postgres-service:
runs-on: ubuntu-latest
services:
postgres:
image: postgres
env:
POSTGRES_PASSWORD: postgres
# Set health checks to wait until postgres has started
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
--name postgres
ports:
# Maps tcp port 5432 on service container to the host
- 5432:5432
env:
PGHOST: localhost
PGUSER: postgres
PGDATABASE: postgres
PGPASSWORD: postgres
steps:
- name: Install postgresql-client
run: |
sudo apt-get update
sudo apt-get install --yes postgresql-client
- name: Connect to PostgreSQL with CLI
run: psql -c 'SELECT VERSION();'
- name: Show PostgreSQL config file
run: psql -c 'SHOW config_file;'
- name: Alter max connections
run: |
docker exec -i postgres bash << EOF
sed -i -e 's/max_connections = 100/max_connections = 1000/' /var/lib/postgresql/data/postgresql.conf
sed -i -e 's/shared_buffers = 128MB/shared_buffers = 2GB/' /var/lib/postgresql/data/postgresql.conf
EOF
docker restart --time 0 postgres
sleep 5
- name: Show max connections
run: psql -c 'SHOW max_connections;'
- name: Install pg
run: npm install pg
- name: Connect to PostgreSQL with Node.js
run: |
cat > client.js << EOF
const pg = require('pg');
const client = new pg.Client();
client.connect();
client.query('SELECT VERSION()').then((result) => {
console.log(result.rows[0]);
client.end();
});
EOF
node client.js