Escape password containing @ when using the postgres pg_dump command

Question

I use postgres, I created db, user, password, this is password:

password = name&text@sob

I use the following command to dump the database and it works with my other databases that I have:

pg_dump -Fc --no-acl --no-owner --dbname=postgresql://db_user:password@127.0.0.1:5432/db_name

But it does not work when using a database with a password containing &and @:

pg_dump -Fc --no-acl --no-owner --dbname=postgresql://db_user:name&text@sob@127.0.0.1:5432/db_name

does not work due to &and @in the password. So I escaped &with \, but it didn’t work for @- any suggestions?

thank

+4

Roko Jun 15 '17 at 7:32

2 answers

, URL.

--dbname=postgresql://db_user:name%26te‌xt%40sob@127.0.0.1:5432/db_nam‌e

+1

JGH 15 . '17 13:43

Vao Tsun · Accepted Answer · 2017-06-15T08:05:23+0000

adding ?password=name%26te‌xt%40sobas uri parameter:

pg_dump -Fc --no-acl --no-owner --dbname=postgresql://db_user:password@127.0.0.1:5432/db_name?password=name%26te‌xt%40sob

URI .

, URL