Page MenuHomeDevCentral
Differential D2760

Provision PostgreSQL cluster
ClosedPublic
Actions

Authored by dereckson on Jan 26 2023, 17:50.
Tags
None
Referenced Files
F2965363: D2760.id7042.diff
Sun, May 19, 04:01
F2965360: D2760.id7040.diff
Sun, May 19, 04:01
F2965359: D2760.id7041.diff
Sun, May 19, 04:01
F2965356: D2760.id7004.diff
Sun, May 19, 04:01
F2965355: D2760.id7039.diff
Sun, May 19, 04:01
Unknown Object (File)
Sat, May 18, 22:34
Unknown Object (File)
Sat, May 18, 22:28
Unknown Object (File)
Sat, May 18, 09:48
View All Files
Subscribers
None

Details

Reviewers
dereckson
Maniphest Tasks
T1750: Import FANTOIR database
Commits
rOPSa4a81d1137cc: Provision PostgreSQL cluster
Summary

Database cluster naming convention:

db-<series>-<counter>

Cluster A will be PostgreSQL main, first is db-A-001.
It will host fantoir database.

Ref T1750.

Test Plan

Connect to db-A-001.nasqueron.drake

Diff Detail

Repository
rOPS Nasqueron Operations
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

dereckson requested review of this revision.Jan 26 2023, 17:50
dereckson created this revision.
Harbormaster completed remote builds in B4364: Diff 7004.Jan 26 2023, 17:50
dereckson planned changes to this revision.Jan 26 2023, 17:51
dereckson added inline comments.
pillar/nodes/nodes.sls
63

.drake

It doesn't have public IPv4.

dereckson updated this revision to Diff 7039.Feb 2 2023, 22:45

Vault. Fix content code. Service. Rebased.

Harbormaster completed remote builds in B4393: Diff 7039.Feb 2 2023, 22:45
dereckson updated this revision to Diff 7040.Feb 2 2023, 22:46

Fix hostname to use local domain

Harbormaster completed remote builds in B4394: Diff 7040.Feb 2 2023, 22:46
dereckson retitled this revision from WIP: provision PostgreSQL cluster to Provision PostgreSQL cluster.Feb 2 2023, 22:47
dereckson updated this revision to Diff 7041.Feb 2 2023, 22:50

-notifications vhost

Harbormaster completed remote builds in B4395: Diff 7041.Feb 2 2023, 22:50
dereckson accepted this revision.Feb 2 2023, 22:51
This revision is now accepted and ready to land.Feb 2 2023, 22:51
Closed by commit rOPSa4a81d1137cc: Provision PostgreSQL cluster (authored by dereckson). · Explain WhyFeb 2 2023, 22:52
This revision was automatically updated to reflect the committed changes.
dereckson added a commit: rOPSa4a81d1137cc: Provision PostgreSQL cluster.
dereckson added a reverting change: D2845: Restore notifications.nasqueron.org vhost.Mar 5 2023, 21:49
dereckson added a reverting change: rOPS3e4d5ac2b812: Restore notifications.nasqueron.org vhost.Mar 5 2023, 21:49
dereckson mentioned this in D2941: Create airflow PostgreSQL database.Mar 29 2023, 15:55
dereckson mentioned this in rOPSe472250c6ae7: Create airflow PostgreSQL database.Mar 29 2023, 15:56

Revision Contents
Changeset List

PathSize
_modules/
47 lines
1 line
pillar/
credentials/
12 lines
dbserver/
22 lines
nodes/
20 lines
3 lines
roles/
core/
motd/
files/
9 lines
dbserver-pgsql/
server/
102 lines
files/
6 lines
3 lines
24 lines
paas-docker/
nginx/
files/
vhosts/
2 lines

Diff 7042

View Options

_modules/credentials.py

Loading...
View Options

map.jinja

Loading...
View Options

pillar/credentials/vault.sls

Loading...
View Options

pillar/dbserver/cluster-A.sls

Loading...
View Options

pillar/nodes/nodes.sls

Loading...
View Options

pillar/top.sls

Loading...
View Options

roles/core/motd/files/db-A-001

Loading...
View Options

roles/dbserver-pgsql/server/content.sls

Loading...
View Options

roles/dbserver-pgsql/server/files/postgresql.rc

Loading...
View Options

roles/dbserver-pgsql/server/init.sls

Loading...
View Options

roles/dbserver-pgsql/server/software.sls

Loading...
View Options

roles/paas-docker/nginx/files/vhosts/notifications.conf

Loading...
View Options

top.sls

Loading...
Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator