problem in restoring database when connected via named socket - Mailing list pgadmin-support

From Giuseppe Sacco
Subject problem in restoring database when connected via named socket
Date
Msg-id 1263289784.5772.21.camel@scarafaggio
Whole thread Raw
List pgadmin-support
Hi all,
I am connected to a local postgresql server via named pipe instead of
tcp/ip socket, i.e., I did not specify the hostname while creating the
connection.

No, when I try to restore a database, the command fail since the
"hostname" argument is missing. This is the error message I get:

/usr/bin/pg_restore -i -h  -p 5439 -U giuseppe -d proteus -v
"/home/giuseppe/Desktop/migrazione saronno/saronno-proteus.pgdump"
pg_restore: [archiviatore] could not open input file "5439": No such
file or directory

the problem being that pg_restore use "-p" as hostname since it is just
after "-h" option, then "4539" is used as file name since it is the
first non option argument.

Of course, I imported my dump using command line pg_restore. Using the
very same line, without "-h".

Is this a known problem of pgadmin? Should I file it somewhere?

Bye,
Giuseppe




pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: problem in restoring database when connected via named socket
Next
From: Giuseppe Sacco
Date:
Subject: Re: problem in restoring database when connected via named socket