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.
- Can't drop role because it has privileges that are not revoked even when REVOKE statement is successful
- How to transfer string from one column to another if it doesn’t contains substring
- How to use uuid with postgresql gist index type?
- How to format date if it can be null spring
- Postrgres Regex to replace part of a String
- Query Condition in Laravel 5
- How to restrict RLS on certain column(s) in PostgreSQL/Supabase?
- Joining too many tables makes Postgres query extremely slow
- Laravel and PHP8.3 can't connect to Postgres database
- CASE vs Multiple UPDATE queries for large data sets - Performance
- Invalid resource manager ID in primary checkpoint record
- postgresql list and order tables by size
- PgAdmin 4: Cannot edit rows from one table
- Add PRIMARY KEY constraint to existing table
- Count of available items with start and end dates grouped by month
- Hibernate mapping between Postgres array of varchar and a Java/Kotlin collection of enum
- Correct way to install psql without full Postgres on macOS?
- Why pg_typeof(TIMESTAMP '2004-10-19 10:23:54+02') shows timestamp without time zone
- "extra data after last expected column" while trying to import a csv file into postgresql
- Postgres - using select statement inside CASE WHEN
- How to split events into periods of activity in postgres?
- Streak for a given endDate SQL (Postgres)
- How to set a timestamptz column in postgres to a range of values to simulate real world data?
- Why is string literal '2021-02-16 09:00' without timezone information interpreted as `timestamp with time zone` with AT TIME ZONE?
- Postgres won't accept table alias before column name
- Named argument passed as a dict: SyntaxError: syntax error at or near "%" or SyntaxError: type modifiers must be simple constants or identifiers
- pg_cron - can not query cron.job after job is scheduled
- PostgreSQL Selecting Most Recent Entry for a Given ID
- Difference between timestamps with/without time zone in PostgreSQL
- connect superset to postgresql in a docker container - The port is closed