nextcloud_postgresql_latest_15

docker-compose.yml

services:
  nextcloud_db:
    container_name: nextcloud_db
    image: postgres:latest
    user: 1000:1000
    network_mode: host
    volumes:
      - /home/username/docker_stack/nextcloud/nextcloud_db:/var/lib/postgresql/data
      - /home/username/docker_stack/nextcloud/nextcloud_db_scripts:/docker-entrypoint-initdb.d:ro
    environment:
      - PUID=1000
      - PGID=1000
      - TZ=Etc/GMT
      - POSTGRES_DB=nextcloud_db
      - POSTGRES_USER=username_here
      - POSTGRES_PASSWORD=password_here
      - PGPORT=13347
    restart: unless-stopped
  nextcloud_app:
    container_name: nextcloud_app
    image: nextcloud:latest
    user: 1000:1000
    network_mode: host
    volumes:
      - /home/username/Documents/nextcloud_data:/var/www/html
      - /home/username/docker_stack/nextcloud/port_modification/ports.conf:/etc/apache2/ports.conf:ro
      - /home/username/docker_stack/nextcloud/port_modification/000-default.conf:/etc/apache2/sites-enabled/000-default.conf:ro
    environment:
      - PUID=1000
      - PGID=1000
      - TZ=Etc/GMT
      - NEXTCLOUD_TRUSTED_DOMAINS='https://nextcloud.mydomain.com'
      - POSTGRES_DB=nextcloud_db
      - POSTGRES_USER=username_here
      - POSTGRES_PASSWORD=password_here
      - POSTGRES_HOST=127.0.0.1:13347
    depends_on:
      - nextcloud_db
    restart: unless-stopped

I placed a script in that .../nextcloud_db_scripts:/docker-entrypoint-initdb.d:ro folder/volume.

Here it is:

#!/bin/bash
set -e
psql --variable=ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
    GRANT CREATE ON SCHEMA public TO public;
EOSQL