Thread: Remote connection via psql
I used psql a lot and generally work directly on my development server. Now
sometimes I am on another machine, but when I try to acces the database with
something like this:
psql -d dbname -U username -h 192.168.1.2
I get the following message: "psql: unknown host name: 192.168.1.2"
I am a bit puzzled, because I have no such problem e.g. from a Perl script:
$conn = Pg::connectdb("dbname=dname user=username hostaddr=192.168.1.2
port=5432") or die "Can't open: $!\n";
psql seems to expect a host name rather than an IP address and I haven't
found any other option in the psql doc. Any way out of this?
--------
François
Home page: http://www.monpetitcoin.com/
"A fox is a wolf who sends flowers"
Francois Suter wrote: > I used psql a lot and generally work directly on my development server. Now > sometimes I am on another machine, but when I try to acces the database with > something like this: > > psql -d dbname -U username -h 192.168.1.2 > > I get the following message: "psql: unknown host name: 192.168.1.2" try another syntax: $ psql -U username -h 192.168.1.2 dbname it works ok here
Francois Suter <dba@paragraf.ch> writes:
> psql -d dbname -U username -h 192.168.1.2
> I get the following message: "psql: unknown host name: 192.168.1.2"
Works fine here. What PG version is this, what platform, etc?
regards, tom lane
> Francois Suter <dba@paragraf.ch> writes: >> psql -d dbname -U username -h 192.168.1.2 >> I get the following message: "psql: unknown host name: 192.168.1.2" > > Works fine here. What PG version is this, what platform, etc? PG version is 7.2.1, platform is Mac OS X 10.1.5, network uses a router that serves as a DHCP server, but the dev server mentioned here as a fixed IP (i.e. 192.168.1.2). Other types of remote access (e.g. ping, FTP) work fine. -------- François Home page: http://www.monpetitcoin.com/ "A fox is a wolf who sends flowers"
Francois Suter <dba@paragraf.ch> writes:
>> Francois Suter <dba@paragraf.ch> writes:
> psql -d dbname -U username -h 192.168.1.2
> I get the following message: "psql: unknown host name: 192.168.1.2"
>>
>> Works fine here. What PG version is this, what platform, etc?
> PG version is 7.2.1, platform is Mac OS X 10.1.5, network uses a router that
> serves as a DHCP server, but the dev server mentioned here as a fixed IP
> (i.e. 192.168.1.2).
OS X eh? I seem to recall a prior thread about that, in which it
emerged that the gethostbyname() routine is kinda broken on OSX.
Everywhere else it will accept a numeric IP, but not on OSX --- unless
you send the query to a nameserver. Or something like that; I think
the guy did find a workaround. Check the list archives.
regards, tom lane
On Wed, 4 Sep 2002, Francois Suter wrote: > > Francois Suter <dba@paragraf.ch> writes: > >> psql -d dbname -U username -h 192.168.1.2 > >> I get the following message: "psql: unknown host name: 192.168.1.2" > > > > Works fine here. What PG version is this, what platform, etc? > > PG version is 7.2.1, platform is Mac OS X 10.1.5, network uses a router that > serves as a DHCP server, but the dev server mentioned here as a fixed IP > (i.e. 192.168.1.2). Try putting an entry in your /etc/hosts (does OS X have one of those? It is BSD, but who knows what might be different) for the server and give it a name and see if you can get a connect then.