Skip to main content
Version: 1.15

Posgres database

Supported Postgres version: 11
Posgis extension: Facultative

Edit your inventory file inventories/<your inventory>/group_vars/regards_nodes/main.yml

  • add connection information
group_config_mservices:
[...]
postgres:
instance:
host: database-inst.cnes.fr
port: 5432
user: <some user>
password: <some password>
db: <instance database name>
init_project:
host: database-first-project.cnes.fr
port: 5432
user: <some user>
password: <some password>
db: <first project database name>
  • remove the Postgres service that was deployed inside group_docker_cots
# Before
group_docker_cots:
postgres:
tag: "{{ group_docker_tags.cots }}"
[...]

# After
group_docker_cots:
  • if you do not have Postgis on your database-inst.cnes.fr database, edit the access_instance service to indicate there is no Postgis available:
# Before
group_docker_mservices:
access_instance:
tag: "{{ group_docker_tags.back }}"
[...]

# After
group_docker_mservices:
access_instance:
tag: "{{ group_docker_tags.back }}"
postgis: false
[...]
  • update the phppgadmin service that was deployed inside group_docker_cots
    • either remove this component, as we did for postgres
    • or edit it like this, to be able to use phppgadmin on your mutualized Postgres:
  phppgadmin:
[...]
db:
- name: DB Instance
host: database-inst.cnes.fr
port: 5432
defaultdb: <instance database name>
theme: cappuccino
- name: DB Project
host: database-first-project.cnes.fr
port: 5432
defaultdb: <first project database name>
theme: cappuccino
setting_main_theme: cappuccino