Thread: [GENERAL] pg_dump throws too many command-line arguments in Postgres 10

[GENERAL] pg_dump throws too many command-line arguments in Postgres 10

From
"Andrus"
Date:
In Postgres 10   Windows 

invoking g_dump exe with

pg_dump.exe -b -f b.backup -Fc -h  -U admin -p 5432 mydb

causes error

pg_dump: too many command-line arguments (first is "-p")
Try "pg_dump --help" for more information.

How to fix this ?
In earlier versions it worked.

Andrus


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_dump throws too many command-line arguments inPostgres 10

From
Paul A Jungwirth
Date:
On Wed, Oct 18, 2017 at 8:05 AM, Andrus <kobruleht2@hot.ee> wrote:
> pg_dump.exe -b -f b.backup -Fc -h  -U admin -p 5432 mydb
>
> causes error
>
> pg_dump: too many command-line arguments (first is "-p")

Don't you need a hostname after -h? I think right now pg_dump thinks
your hostname is "-U", your database is "admin", and everything after
that is extra.

Yours,
Paul


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general