Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

WARNING: Unable to set up worker conn #0: FATAL: password authentication failed for user "master" #315

Open
mvdobrinin opened this issue Jul 20, 2022 · 1 comment

Comments

@mvdobrinin
Copy link

mvdobrinin commented Jul 20, 2022

I am running into an issue where adding the -j flag gives errors about password authentication.

$ export PGPASSWORD='my\+p@assw0rd'
$ time ./pg_repack -d pfm_infra_service_db -h pfm-infra-service-cluster.cluster-x.us-east-2.rds.amazonaws.com -U master -p 5432 -t public.execution -k -j 16
NOTICE: Setting up workers.conns
WARNING: Unable to set up worker conn #0: FATAL:  password authentication failed for user "master"
FATAL:  no pg_hba.conf entry for host "10.221.137.233", user "master", database "pfm_infra_service_db", SSL off
INFO: repacking table "public.execution"

But when running with a single thread it works fine. Also it's strange because even though it complains about password, it does the repack correctly.

The client and server of pg_repack are both 1.4.6.

   Name    | Version | Schema |                         Description
-----------+---------+--------+--------------------------------------------------------------
 pg_repack | 1.4.6   | public | Reorganize tables in PostgreSQL databases with minimal locks
(1 row)
@andreasscherbaum
Copy link
Collaborator

@mvdobrinin Can you please check if this problem is solved with the change in #354? Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants