BUG #13727: pg_dump with a connection string fails when performing parallel backup

From: zkronion(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13727: pg_dump with a connection string fails when performing parallel backup
Date: 2015-10-25 21:54:51
Message-ID: 20151025215451.3019.80214@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13727
Logged by: Collin Stedman
Email address: zkronion(at)gmail(dot)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(at)my(dot)hostname(dot)com:5432/my-db" -Fd -f
my-dump

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

pg_dump "postgres://my-user:my-password(at)my(dot)hostname(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Tatsuo Ishii 2015-10-26 00:54:03 Re: Re: [BUGS] BUG #13611: test_postmaster_connection failed (Windows, listen_addresses = '0.0.0.0' or '::')
Previous Message David G. Johnston 2015-10-25 21:37:38 Re: BUG #13723: "duplicate key" error occurs when update delete and insert the same row concurrently