I just tried this and I was able to connect. Maybe there is an issue with your docker networking. What do you get if you rundocker ps?

I just tried this and I was able to connect. Maybe there is an issue with your docker networking. What do you get if you rundocker ps?

I tried to rundocker ps, it worked as i expected, i got the activated containers.

docker ps --filter'name=postgres' --format'{{.ID}}'

CONTAINER ID   IMAGE      COMMAND                   CREATED         STATUS         PORTS                    NAMESbdb2469f4a82   postgres"docker-entrypoint.s…"   4 minutes ago   Up 4 minutes   0.0.0.0:5432->5432/tcp   postgres_1698292090

I thought after running
docker run \ --name "postgres_$(date '+%s')" \ -e POSTGRES_USER=${DB_USER} \ -e POSTGRES_PASSWORD=${DB_PASSWORD} \ -e POSTGRES_DB=${DB_NAME} \ -p "${DB_PORT}":5432 \ -d \ postgres -N 1000, i should manually set $DB_USER. Then, i tried to modify the script like this:

docker run \    --name"${RUNNING_POSTGRES_CONTAINER}" \    -e POSTGRES_USER=${DB_USER} \    -e POSTGRES_PASSWORD=${DB_PASSWORD} \    -e POSTGRES_DB=${DB_NAME} \    -p"${DB_PORT}":5432 \    -d \    postgres -N 1000sleep 5dockerexec -it$RUNNING_POSTGRES_CONTAINER psql -U$DB_USER -d$DB_NAME -c"CREATE USER$DB_USER WITH PASSWORD '$DB_PASSWORD';"

However, it reports :ERROR: role "admin" already exists.

I just tried this and I was able to connect. Maybe there is an issue with your docker networking. What do you get if you rundocker ps?

According tohttps://stackoverflow.com/questions/11919391/postgresql-error-fatal-role-username-does-not-exist, maybe i must use the system userpostgres to init database?

The user is successfully created. Do you have postgres installed locally as well? I am wondering if your script isn't connecting to your container postgres but another one.

The user is successfully created. Do you have postgres installed locally as well? I am wondering if your script isn't connecting to your container postgres but another one.

Yes, i have installed locally. But i did not start local postgres, i just use thepsql as a tool to connect to the postgres container.

File "/home/gridsentry/imgaudit/GAudit/myenv/lib/python3.8/site-packages/psycopg2/init.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: role "gaudit" does not exist

Project

export ENV_HOME=$PWD
export ENV_PROJECT=GAudit
export ENV_DJANGO_SECRET_KEY='xxxxxxxxxxxxxxxxxxxxxxx
export PYTHONPATH=$ENV_HOME/backend
export ENV_SITE=im_gaudit

Database

export ENV_DB_USER=gaudit
export ENV_DB_NAME=imdev
export ENV_DB_PASSWORD="gaudit@123"

Super Admin

export ENV_ADMIN_USER=gsadmin
export ENV_ADMIN_PASSWORD="GS@dm!n24"
export ENV_ADMIN_EMAIL=admin@gmail.com

Server

export ENV_SERVER_TYPE=dev
export DEBUG=1

How to fix this issue?