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?
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?
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.
This is for newer versions of pg_dump
:
pg_dump -d postgres://username:password@my_postgres_server:5432/databasename > filename