Comments (2)
I have the same issue with v0.3.5
from pgstac.
@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
from pgstac.
Related Issues (20)
- scripts/install missing? HOT 1
- Occasional syntax errors from well formed search queries HOT 10
- CQL2: ILIKE vs. CASEI
- Validation Error and Content Mismatch in Sentinel-2-L1C Item Definition JSON HOT 3
- Error when installing pgstac > v0.8.1 HOT 2
- Changelog inaccurately indicates pypgstac loader compatibility within major version HOT 2
- Excessive growth of database logs HOT 1
- Unable to ingest private metadata HOT 8
- Feature request: Update collection extend from item(s) HOT 2
- BETWEEN operator bug
- CQL2 filters resulting in full scans despite indexed properties HOT 2
- Error on docker image startup. HOT 7
- Aggregation Extension HOT 1
- No module named 'pypgstac.pgstacrs' HOT 1
- Ensure proper handling of geometries passed in that cross the antimeridian HOT 1
- Docs - Add link to videos that describe pgstac HOT 1
- Add Links to ItemCollection directly in pgstac
- Relax smart-open dependency version HOT 8
- update_collection_extent setting results in wrong JSON structure HOT 2
- collection_temporal_extent produces invalid datetime HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgstac.