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

Severity	Location	Code	Message
Advice	_modules/credentials.py:191	F821	flake8 F821
Advice	_modules/credentials.py:223	F821	flake8 F821
Advice	_modules/credentials.py:225	F821	flake8 F821

Unit

No Test Coverage

Branch

postgresql

Build Status

Buildable 4394
Build 4661: 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.

Vault. Fix content code. Service. Rebased.

Harbormaster completed remote builds in B4393: Diff 7039.Feb 2 2023, 22:45

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

-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

Provision PostgreSQL cluster
ClosedPublic
Actions

Details

Diff Detail

Event Timeline

Revision Contents
Changeset List

Diff 7040

_modules/credentials.py

_modules/zr.py

map.jinja

pillar/credentials/vault.sls

pillar/dbserver/cluster-A.sls

pillar/nodes/nodes.sls

pillar/top.sls

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

roles/core/network/ipv6.sls

roles/dbserver-pgsql/server/content.sls

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

roles/dbserver-pgsql/server/init.sls

roles/dbserver-pgsql/server/software.sls

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

top.sls

Provision PostgreSQL clusterClosedPublicActions

Details

Diff Detail

Event Timeline

Revision ContentsChangeset List

Diff 7040

_modules/credentials.py

_modules/zr.py

map.jinja

pillar/credentials/vault.sls

pillar/dbserver/cluster-A.sls

pillar/nodes/nodes.sls

pillar/top.sls

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

roles/core/network/ipv6.sls

roles/dbserver-pgsql/server/content.sls

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

roles/dbserver-pgsql/server/init.sls

roles/dbserver-pgsql/server/software.sls

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

top.sls

Provision PostgreSQL cluster
ClosedPublic
Actions

Revision Contents
Changeset List