postgresqldockerpgadmindatabase-connectivity
Docker postgres connectivity isuue
Can anyone help me please with this?
what I run:
docker run --name pgres --rm \
-e POSTGRES_USER=uzer \
-e POSTGRES_PASSWORD=1234 \
-e POSTGRES_DB=sample_db \
-p 5432:5432 postgres:14.1
but I cannot connect to that:
even Nothing happens in the log:
waiting for server to shut down...2024-07-24 18:07:19.272 UTC [48] LOG: received fast shutdown request
.2024-07-24 18:07:19.273 UTC [48] LOG: aborting any active transactions
2024-07-24 18:07:19.275 UTC [48] LOG: background worker "logical replication launcher" (PID 55) exited with exit code 1
2024-07-24 18:07:19.275 UTC [50] LOG: shutting down
2024-07-24 18:07:19.284 UTC [48] LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
2024-07-24 18:07:19.396 UTC [1] LOG: starting PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2024-07-24 18:07:19.397 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2024-07-24 18:07:19.397 UTC [1] LOG: listening on IPv6 address "::", port 5432
2024-07-24 18:07:19.398 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-07-24 18:07:19.401 UTC [62] LOG: database system was shut down at 2024-07-24 18:07:19 UTC
2024-07-24 18:07:19.405 UTC [1] LOG: database system is ready to accept connections
Solution
My bad; I had completely forgotten.
Tor was the problem, I turned it off and now the problem is solved.
- How to show full definition of function or procedure?
- Repeated execution of PL/pgSQL function triggers error "could not open relation with OID ..."
- error: password authentication failed for user "postgres" drizzle migration
- Alembic migration for GeoAlchemy2 raises NameError: name 'geoalchemy2' is not defined
- Get the top N rows by row count in GROUP BY
- Postgres unique constraint vs index
- Postgres caseinsensitive unique key constraint: What is the fast option?
- Fixing all sequences in PostgreSQL 15 after migrating with logical replication from PostgreSQL 11
- PostgreSQL `aws_s3` Extension: SSL Certificate Verification Failed with Self-Signed Certificate
- Get fatal error: server could not be contacted when running pgAdmin4. 'NoneType' object has no attribute 'value'
- Find a value based on all its present combinations with a value in another field in Postgres
- SSLmode in FireDac for connection to Postgres
- Why is postgres container ignoring /docker-entrypoint-initdb.d/* in Gitlab CI
- Query failed: collation "numerickn" for encoding "UTF8" does not exist
- How does a Recursive CTE know to only process records added during the last iteration (and not looking at all of them)?
- Directly return Postgres jsonb binary bytes
- Combine two tables doing row count based on hour value in timestamp
- Execute function from procedure, the name of function stored in table column
- Node.js, PostgreSQL error: no pg_hba.conf entry for host
- ERROR: cannot execute CREATE TABLE in a read-only transaction
- How can I write a trigger and function to insert data into table2 when a new row is inserted into table1, while avoiding duplicates in table2?
- count difference in seconds between values from table and some moment in time using PostgreSQL
- Postgres Permissions violated by before-insert trigger function
- Update query not working with Celery and FastAPI
- nodejs query postgres using WHERE
- PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
- Group multiple events for ID in postgreSQL data
- Blazor App in Docker Occasionally Fails to Connect to PostgreSQL Database
- Table constraint for range and null values
- Fixtures are not loaded and says they are not found, although they are there