How to use pg_dump with a connection uri / url?

Question

I can invoke psql like this:

psql postgres://...

How can I use pg_dump with a connection string in the format postgres://...?
Would be more convenient than breaking URI's into host, post, username, password.

Is there syntax for this?

If an answer solves your problem (such as the one by @Jorge Disaz) you should probably accept it. — Neowizard, Jan 03 '18 at 14:51

score 211 · Answer 1 · edited Sep 13 '21 at 14:55

211

pg_dump postgres://username:password@my_postgres_server:5432/databasename

I just downloaded a dump using this format. Optionally you can add -f filename to specify a local filename.

edited Sep 13 '21 at 14:55

Emil Laine

41,598
9
101
157

answered Mar 17 '15 at 14:10

Jorge Diaz

2,503
1
14
15

score 29 · Answer 2 · answered Aug 31 '21 at 16:23

29

This is for newer versions of pg_dump:

pg_dump -d postgres://username:password@my_postgres_server:5432/databasename > filename

answered Aug 31 '21 at 16:23

Mohammad Barbast

1,753
3
17
28

I did not need the `-d` flag, it worked anyway. – Johan Walles May 09 '23 at 12:45

How to use pg_dump with a connection uri / url?

2 Answers2

Linked