github.com/cloudfoundry/postgres-release/src/acceptance-tests@v0.0.0-20240511030151-872bdd2e0dba/testing/templates/postgres_simple.yml (about)

     1  name: pgats-simple
     2  
     3  releases:
     4  - name: postgres
     5    version: YOUR_RELEASE_VERSION
     6  - name: os-conf
     7    version: latest
     8  
     9  stemcells:
    10  - alias: linux
    11    os: YOUR_STEMCELL_OS
    12    version: YOUR_STEMCELL_VERSION
    13  
    14  instance_groups:
    15  - name: postgres
    16    instances: 1
    17    azs: [YOUR_AZ_LIST]
    18    networks:
    19    - name: YOUR_NETWORK
    20    jobs:
    21    - name: user_add
    22      release: os-conf
    23      properties:
    24        users:
    25        - name: ((testuser_name))
    26          public_key: ((sshkey.public_key))
    27    - name: postgres
    28      release: postgres
    29      provides:
    30        postgres: {as: postgres-database}
    31      properties:
    32        databases:
    33          trust_local_connections: false
    34          port: 5524
    35          databases:
    36          - citext: false
    37            name: sandbox
    38          - citext: false
    39            name: sandbox-2
    40          max_connections: 111
    41          additional_config:
    42            shared_buffers: 32768
    43          roles:
    44          - name: ((defuser_name))
    45            password: ((defuser_password))
    46          - name: ((superuser_name))
    47            password: ((superuser_password))
    48            permissions:
    49            - "SUPERUSER"
    50            - "CONNECTION LIMIT 33"
    51            - "VALID UNTIL 'May 5 12:00:00 2025 +1'"
    52    persistent_disk_type: YOUR_DISK_TYPE
    53    vm_type: YOUR_VM_TYPE
    54    stemcell: linux
    55    env:
    56      bosh:
    57        keep_root_password: true
    58  - name: backup
    59    instances: 0
    60    azs: [YOUR_AZ_LIST]
    61    networks:
    62    - name: YOUR_NETWORK
    63    jobs:
    64    - name: bbr-postgres-db
    65      release: postgres
    66      consumes:
    67        database: {from: postgres-database}
    68      properties:
    69        release_level_backup: true
    70        postgres:
    71          dbuser: ((superuser_name))
    72    persistent_disk_type: YOUR_DISK_TYPE
    73    vm_type: YOUR_VM_TYPE
    74    stemcell: linux
    75    env:
    76      bosh:
    77        keep_root_password: true
    78  variables:
    79  - name: sshkey
    80    type: ssh
    81  update:
    82    canaries: 1
    83    canary_watch_time: 30000-600000
    84    max_in_flight: 1
    85    serial: true
    86    update_watch_time: 15000-300000