tries to use -h switch when not needed

From: Roberto C(dot) Sánchez <roberto(at)connexer(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: tries to use -h switch when not needed
Date: 2008-03-19 05:19:12
Message-ID: 20080319051912.GD1364@connexer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I have noticed that on Mac OS X (v 1.8.1) and Debian Etch (v 1.4.3), I
see incorrect behavior when trying to restore into a database when the
connection to the database is via a UNIX domain socket. In such a case,
there is no hostname specified. However, the commandline produced for
the restore command is this:

/usr/bin/pg_restore -i -h -p 5432 -U roberto -d jilldb -v "/network/home/roberto/tmp/pg.backup"

So, even though the configuration for the server in question lists
neither hostname nor port number, it tries to add both to the command
line. Since the port has a sensible default, it is at least given a
value. The host, on the other hand, has no sensible default and so is
left blank causing pg_restore to fail. Anyhow, it seems to me that the
logic behind this should be made a little smarter such that if neither
host nor port are specified that the corresponding command-line options
should be omitted.

Regards,

-Roberto

--
Roberto C. Sánchez
http://people.connexer.com/~roberto
http://www.connexer.com

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Julius Tuskenis 2008-03-19 08:17:56 no database or relation name in locks list
Previous Message Rommel the iCeMAn 2008-03-18 19:50:45 Re: pgAdmin Crashes After Changing Timezone Setting