You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm using the bitnami/postgres16 image with docker compose. I'm starting off with an empty database to test. The database is initialized and I log into the container via:
sudo docker exec -it <name of containter> /bin/bash
From inside the container I login to the database via:
PGPASSPASSWORD=<POSTGRESQL_POSTGRES_PASSWORD variable defined in docker_compose.yml> psql -U psql
Once logged in as the postgres user, I try something simple such as:
postgres=# ALTER USER postgres WITH ENCRYPTED PASSWORD 'postgresql-postgresql-pass';
The control process never returns to the command prompt. I need to break the command with a Cntl-C. Checking in this the command seems to be successfully completed (can log in via the new password) however with every command given at command line I need to break command.
What is the expected behavior?
Process should execute and return the to the prompt. Such as:
postgres=# ALTER USER postgres WITH ENCRYPTED PASSWORD 'postgresql-postgresql-pass';
postgres=#
What do you see instead?
I see a hanging cursor:
postgres=# ALTER USER postgres WITH ENCRYPTED PASSWORD 'postgresql-postgresql-pass';
[]
Additional information
I originally thought it might be a permissions issue, but I don't think this is the case since in my example the password is actually changed. I've also tried running variations of this command by running this command from the psql command line prompt from within the docker container and it does the same thing in terms of "freezing" or not returning the command prompt.
The text was updated successfully, but these errors were encountered:
Name and Version
bitnami/postgres:16
What architecture are you using?
amd64
What steps will reproduce the bug?
I'm using the bitnami/postgres16 image with docker compose. I'm starting off with an empty database to test. The database is initialized and I log into the container via:
sudo docker exec -it <name of containter> /bin/bash
From inside the container I login to the database via:
PGPASSPASSWORD=<POSTGRESQL_POSTGRES_PASSWORD variable defined in docker_compose.yml> psql -U psql
Once logged in as the postgres user, I try something simple such as:
postgres=# ALTER USER postgres WITH ENCRYPTED PASSWORD 'postgresql-postgresql-pass';
The control process never returns to the command prompt. I need to break the command with a Cntl-C. Checking in this the command seems to be successfully completed (can log in via the new password) however with every command given at command line I need to break command.
What is the expected behavior?
Process should execute and return the to the prompt. Such as:
What do you see instead?
I see a hanging cursor:
Additional information
I originally thought it might be a permissions issue, but I don't think this is the case since in my example the password is actually changed. I've also tried running variations of this command by running this command from the psql command line prompt from within the docker container and it does the same thing in terms of "freezing" or not returning the command prompt.
The text was updated successfully, but these errors were encountered: