Page MenuHomeDevCentral
Differential D2760

Provision PostgreSQL cluster
ClosedPublic
Actions

Authored by dereckson on Jan 26 2023, 17:50.
Tags
None
Referenced Files
F2831466: D2760.id7039.diff
Fri, Apr 19, 16:40
F2831116: D2760.id7040.diff
Fri, Apr 19, 15:05
F2828301: D2760.diff
Fri, Apr 19, 03:43
F2828138: D2760.id7039.diff
Fri, Apr 19, 03:01
Unknown Object (File)
Thu, Apr 18, 18:42
Unknown Object (File)
Thu, Apr 18, 07:41
Unknown Object (File)
Mon, Apr 15, 23:29
Unknown Object (File)
Mon, Apr 15, 05:27
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 Passed
SeverityLocationCodeMessage
Advice_modules/credentials.py:191F821flake8 F821
Advice_modules/credentials.py:223F821flake8 F821
Advice_modules/credentials.py:225F821flake8 F821
Unit
No Test Coverage
Branch
postgresql
Build Status
Buildable 4395
Build 4662: arc lint + arc unit

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
10 lines
1 line
pillar/
credentials/
12 lines
dbserver/
22 lines
nodes/
20 lines
3 lines
roles/
core/
motd/
files/
9 lines
network/
4 lines
dbserver-pgsql/
server/
102 lines
files/
6 lines
3 lines
24 lines
2 lines

Diff 7041

View Options

_modules/credentials.py

Loading...
View Options

_modules/zr.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/core/network/ipv6.sls

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

top.sls

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