Re: How to debug: password authentication failed for user

On 2/27/25 08:46, Alexander Farber wrote: Good evening, My problem is that the local "trust" connection all work fine, but remote connection from another pod in the AKS fails with: PGPASSWORD=timeshift_pass psql --host=timeshiftservice --port=5432 --dbname=timeshift_database --username=tim

Re: How to debug: password authentication failed for user

On 2/27/25 10:57, Greg Sabino Mullane wrote: On Thu, Feb 27, 2025 at 1:32 PM Tom Lane > wrote: > -c 'ALTER USER timeshift_user PASSWORD '"'"'timeshift_pass'"'"';' > I am still trying to work out what that quoting is doing? That's standard for -x output for

Re: How to debug: password authentication failed for user

On Thu, Feb 27, 2025 at 1:32 PM Tom Lane wrote: > > -c 'ALTER USER timeshift_user PASSWORD '"'"'timeshift_pass'"'"';' > > I am still trying to work out what that quoting is doing? > That's standard for -x output for some versions of bash. FWIW, none of the shells I had access to output it quite

Re: How to debug: password authentication failed for user

Adrian Klaver writes: > My guess it has to do with: > -c 'ALTER USER timeshift_user PASSWORD '"'"'timeshift_pass'"'"';' > I am still trying to work out what that quoting is doing? That makes my head hurt, too. Using log_statement to see what's actually getting sent to the server, I can see that

Re: How to debug: password authentication failed for user

On 2/27/25 10:14, Alexander Farber wrote: That seems to be the reason, thank you Adrian. At first connecting from the other pod in the AKS cluster does not work: $ PGPASSWORD=timeshift_pass psql --host=timeshiftservice --port=5432 --dbname=timeshift_database --username=timeshift_user psql: err

Re: How to debug: password authentication failed for user

That seems to be the reason, thank you Adrian. At first connecting from the other pod in the AKS cluster does not work: $ PGPASSWORD=timeshift_pass psql --host=timeshiftservice --port=5432 --dbname=timeshift_database --username=timeshift_user psql: error: connection to server at "timeshiftservice

How to debug: password authentication failed for user

Good evening, I am building the following Dockerfile by the command: # docker build -f ./Dockerfile --build-arg PGPASSWORD=timeshift_pass . FROM postgres:17-alpine3.21 RUN apk update && apk upgrade && apk add --no-cache pg_top ARG PGPASSWORD # Tell docker-entrypoint.sh to create superuser "pos