MAAS: Difference between revisions
Jump to navigation
Jump to search
Line 3: | Line 3: | ||
==PostgreSQL== | ==PostgreSQL== | ||
===Install=== | |||
---- | |||
<source lang="bash"> | <source lang="bash"> | ||
sudo apt install postgresql postgresql-contrib | sudo apt install postgresql postgresql-contrib | ||
Line 19: | Line 21: | ||
DDL | DDL | ||
EOF | EOF | ||
</source> | |||
===Schema=== | |||
---- | |||
<source lang="bash"> | |||
MAAS_DBUSER='academia_maas' | |||
MAAS_DBNAME='academia_maas' | |||
MAAS_DBPASS='sadaqah!' | |||
</source> | </source> | ||
Line 29: | Line 39: | ||
<source lang="bash"> | <source lang="bash"> | ||
sudo -i -u postgres bash << EOF | sudo -i -u postgres bash << EOF | ||
createdb - | createdb --owner ${MAAS_DBUSER:-academia_maas} ${MAAS_DBNAME:-academia_maas} | ||
EOF | EOF | ||
</source> | </source> |
Revision as of 01:39, 17 March 2023
sudo snap install maas --channel=3.3/stable sudo snap install maas
PostgreSQL
Install
sudo apt install postgresql postgresql-contrib
sudo systemctl enable postgresql
sudo systemctl status postgresql
sudo systemctl start postgresql
sudo systemctl daemon-reload
sudo -i -u postgres bash << EOF
createuser ${USER}
createdb ${USER}
cat << DDL | psql
ALTER USER ${USER} WITH SUPERUSER;
DDL
EOF
Schema
MAAS_DBUSER='academia_maas'
MAAS_DBNAME='academia_maas'
MAAS_DBPASS='sadaqah!'
sudo -i -u postgres psql << DDL
CREATE USER ${MAAS_DBUSER:-academia_maas} WITH ENCRYPTED PASSWORD '${MAAS_DBPASS:-sadaqah}'
DDL
sudo -i -u postgres bash << EOF
createdb --owner ${MAAS_DBUSER:-academia_maas} ${MAAS_DBNAME:-academia_maas}
EOF
cat << EOF | sudo tee -a /etc/postgresql/14/main/pg_hba.conf >/dev/null
host ${MAAS_DBNAME:-academia_maas} ${MAAS_DBUSER:-academia_maas} 0/0 md5
EOF
Knowledge
install: sudo snap install maas --channel=3.3 |
upgrade: sudo snap refresh maas --channel=3.3 |
sudo snap install maas-test-db sudo maas-test-db.psql |
| ||
sudo maas init --help |
References
| ||