cannot start database service built with `pgstac:v0.3.5`

[vincentsarago]

docker-compose.yml

  database:
    container_name: stac-db
    platform: linux/amd64
    image: ghcr.io/stac-utils/pgstac:v0.3.5
    environment:
      - POSTGRES_USER=username
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=postgis
    ports:
      - "5439:5432"
    command: postgres -N 500

docker-compose up database

stac-db  | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/pgstac.sql
stac-db  | BEGIN
stac-db  | psql:/docker-entrypoint-initdb.d/pgstac.sql:2: error: sql/001_core.sql: No such file or directory

cc @bitner

[NicolaiLolansen]

I have the same issue with v0.3.5

[vincentsarago]

@bitner I still can start a service with v0.3.6 but now because if a different error

asyncpg.exceptions.InvalidAuthorizationSpecificationError: role "postgres" does not exist

  database:
    container_name: db
    platform: linux/amd64
    image: ghcr.io/stac-utils/pgstac:v0.3.6
    environment:
      - POSTGRES_USER=username
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=postgis
    ports:
      - "5439:5432"
    command: postgres -N 500

$ docker-compose up database
Creating db ... done
Attaching to db
db | The files belonging to this database system will be owned by user "postgres".
db | This user must also own the server process.
db | 
db | The database cluster will be initialized with locale "en_US.utf8".
db | The default database encoding has accordingly been set to "UTF8".
db | The default text search configuration will be set to "english".
db | 
db | Data page checksums are disabled.
db | 
db | fixing permissions on existing directory /var/lib/postgresql/data ... ok
db | creating subdirectories ... ok
db | selecting dynamic shared memory implementation ... posix
db | selecting default max_connections ... 100
db | selecting default shared_buffers ... 128MB
db | selecting default time zone ... Etc/UTC
db | creating configuration files ... ok
db | running bootstrap script ... ok
db | performing post-bootstrap initialization ... ok
db | syncing data to disk ... ok
db | 
db | initdb: warning: enabling "trust" authentication for local connections
db | You can change this by editing pg_hba.conf or using the option -A, or
db | --auth-local and --auth-host, the next time you run initdb.
db | 
db | Success. You can now start the database server using:
db | 
db |     /usr/lib/postgresql/13/bin/pg_ctl -D /var/lib/postgresql/data -l logfile start
db | 
db | waiting for server to start....2021-10-28 13:10:33.205 UTC [123] LOG:  starting PostgreSQL 13.4 (Debian 13.4-4.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
db | 2021-10-28 13:10:33.245 UTC [123] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db | 2021-10-28 13:10:33.384 UTC [127] LOG:  database system was shut down at 2021-10-28 13:10:32 UTC
db | 2021-10-28 13:10:33.513 UTC [123] LOG:  database system is ready to accept connections
db |  done
db | server started
db | CREATE DATABASE
db | 
db | 
db | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/initpgstac.sh
db | 2021-10-28 13:10:35.311 UTC [161] FATAL:  role "postgres" does not exist
db | Traceback (most recent call last):
db |   File "/usr/local/bin/pypgstac", line 5, in <module>
db |     app()
db |   File "/usr/local/lib/python3.9/dist-packages/typer/main.py", line 214, in __call__
db |     return get_command(self)(*args, **kwargs)
db |   File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 829, in __call__
db |     return self.main(*args, **kwargs)
db |   File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 782, in main
db |     rv = self.invoke(ctx)
db |   File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 1259, in invoke
db |     return _process_result(sub_ctx.command.invoke(sub_ctx))
db |   File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 1066, in invoke
db |     return ctx.invoke(self.callback, **ctx.params)
db |   File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 610, in invoke
db |     return callback(*args, **kwargs)
db |   File "/usr/local/lib/python3.9/dist-packages/typer/main.py", line 497, in wrapper
db |     return callback(**use_params)  # type: ignore
db |   File "/opt/src/pypgstac/pypgstac/pypgstac.py", line 31, in migrate
db |     version = asyncio.run(run_migration(dsn, toversion))
db |   File "/usr/lib/python3.9/asyncio/runners.py", line 44, in run
db |     return loop.run_until_complete(main)
db |   File "/usr/lib/python3.9/asyncio/base_events.py", line 642, in run_until_complete
db |     return future.result()
db |   File "/opt/src/pypgstac/pypgstac/migrate.py", line 140, in run_migration
db |     conn = await asyncpg.connect(dsn=dsn)
db |   File "/usr/local/lib/python3.9/dist-packages/asyncpg/connection.py", line 1980, in connect
db |     return await connect_utils._connect(
db |   File "/usr/local/lib/python3.9/dist-packages/asyncpg/connect_utils.py", line 661, in _connect
db |     con = await _connect_addr(
db |   File "/usr/local/lib/python3.9/dist-packages/asyncpg/connect_utils.py", line 640, in _connect_addr
db |     await compat.wait_for(connected, timeout=timeout)
db |   File "/usr/local/lib/python3.9/dist-packages/asyncpg/compat.py", line 103, in wait_for
db |     return await asyncio.wait_for(fut, timeout)
db |   File "/usr/lib/python3.9/asyncio/tasks.py", line 481, in wait_for
db |     return fut.result()
db | asyncpg.exceptions.InvalidAuthorizationSpecificationError: role "postgres" does not exist
db exited with code 1