Re: [GENERAL] Connect to server PG from laptop java app

2009-04-11 Thread Jasen Betts
On 2009-04-05, Johan Nel 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 som

Re: [GENERAL] Connect to server PG from laptop java app

2009-04-05 Thread Colin Streicher
Also, I don't know if this applies to windows systems, but on linux systems you have to also modify postgresql.conf On my system, it is in the same directory as pg_hba.conf looks like this: #-- # CONNECTIONS AND AUTHENTIC

Re: [GENERAL] Connect to server PG from laptop java app

2009-04-05 Thread Johan Nel
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 thin

Re: [GENERAL] Connect to server PG from laptop java app

2009-04-05 Thread Raymond O'Donnell
On 05/04/2009 19:52, Jennifer Trey wrote: > no pg_hba entry for host 85.235 user postgres, database xxx .. ssl off Ah... you need to edit pg_hba.conf and add an entry for the client to allow it access. The documentation in the file itself is pretty good, and there's more here: http://www.p

Re: [GENERAL] Connect to server PG from laptop java app

2009-04-05 Thread Adrian Klaver
On Sunday 05 April 2009 11:28:09 am 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? > Post

Re: [GENERAL] Connect to server PG from laptop java app

2009-04-05 Thread Raymond O'Donnell
On 05/04/2009 19:52, Jennifer Trey wrote: > no pg_hba entry for host 85.235 user postgres, database xxx .. ssl off > ... I meant to add too that pg_hba.comf is found in the top level of your PostgreSQL data directory. Ray. -- Ra

Re: [GENERAL] Connect to server PG from laptop java app

2009-04-05 Thread Jennifer Trey
no pg_hba entry for host 85.235 user postgres, database xxx .. ssl off ... ?? I guess that means that I need to set up pg then.. how is the question now :) / Jen On Sun, Apr 5, 2009 at 8:35 PM, Raymond O'Donnell wrote: > On 05/04/2009 19:28, Jennifer Trey wrote: > > Hi, I am trying to crea

Re: [GENERAL] Connect to server PG from laptop java app

2009-04-05 Thread ries van Twisk
On Apr 5, 2009, at 1:28 PM, 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. Define : "it's" Do I need to open some firewall