BUG #13727: pg_dump with a connection string fails when performing parallel backup - Mailing list pgsql-bugs

From zkronion@gmail.com
Subject BUG #13727: pg_dump with a connection string fails when performing parallel backup
Date
Msg-id 20151025215451.3019.80214@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13727
Logged by:          Collin Stedman
Email address:      zkronion@gmail.com
PostgreSQL version: 9.4.4
Operating system:   Mac OSX 10.10.3
Description:

The following command works just fine:

pg_dump "postgres://my-user:my-password@my.hostname.com:5432/my-db" -Fd -f
my-dump

However, if I try to parallelize the dump...

pg_dump "postgres://my-user:my-password@my.hostname.com:5432/my-db" -Fd
--jobs=9 -f my-dump

I get the following error:

pg_dump: [parallel archiver] connection to database "my-db" failed:
fe_sendauth: no password supplied

I believe I have a patch for the bug, which I'll submit to pgsql-hackers in
response to this bug report.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #13657: Some kind of undetected deadlock between query and "startup process" on replica.
Next
From: ofir.manor@gmail.com
Date:
Subject: BUG #13725: Logical Decoding - wrong results with large transactions and unfortunate timing