problem in restoring database when connected via named socket

Поиск
Список
Период
Сортировка
От Giuseppe Sacco
Тема problem in restoring database when connected via named socket
Дата
Msg-id 1263288851.5772.20.camel@scarafaggio
обсуждение исходный текст
Ответы Re: problem in restoring database when connected via named socket  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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 по дате отправления:

Предыдущее
От: Ashesh Vashi
Дата:
Сообщение: Re: running pgagent
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: problem in restoring database when connected via named socket