Re: Connect to server PG from laptop java app

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Connect to server PG from laptop java app
Date: 2009-04-11 08:49:47
Message-ID: grpljb$qg5$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2009-04-05, Johan Nel <johan555(dot)nel555(at)xsinet555(dot)co(dot)za> wrote:
> Jennifer,
>
> Jennifer Trey wrote:
>> Hi, I am trying to create my DB schema on the server through my
>> development laptop.
>>
>> I have installed Web Server 2008 and PostgreSQL. They are both running.
>> For some reason its not working. Do I need to open some firewall ports?
>> PostgreSQL runs on 5432. ( I think I did that though). Do I need to
>> configure PG somehow as well?
>
> Default PG installation is setup to work only on localhost or 127.0.0.1

No. The default is localhost only. if you need 127.0.0.1 you may need to add
it.

Operating systems are moving to IP6 and a recent windows(?) update saw
localhost move to ::1 (from 127.0.0.1) for me this broke some things
that were expecting to find postgres on 127.0.0.1

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2009-04-11 09:18:48 Re: Convert Oracle function to PostgreSQL
Previous Message Alvaro Herrera 2009-04-11 04:03:41 Re: ERROR: array subscript out of range