PostgreSQL 0 ▲ tommi.space main stream 98 days ago · Tech · hide · Fediverse post Collecting notes on databases management, mainly Postgres. Change password It could be that connecting from localhost does not require a password. In that case, you have to replace trust with scram-sha-256 in /var/lib/postgresql/data/pg_hba.conf and either restart the service or run SELECT pg_reload_conf(); to apply the changes. ALTER USER username WITH PASSWORD 'newpasswordhereeeeee' Run inside a container podman exec -it containername psql -d "postgresql://username@localhost/maybesomething" -c "COMMAND" or podman exec -it spliit-db bash -lc ' psql \ "host=127.0.0.1 port=5432 user=username dbname=databasename" \ -c "COMMAND" ' Commenting on Bubbles has been removed. Why? If you want to talk about this post, write to the author, use the comments on their blog if it has them, or reply with a "RE:" post on your own blog. Suggestions? feedback@bubbles.town