Re: [awips2-users] can't connect to postgres

  • To: "Larry D. Oolman" <ldoolman@xxxxxxxx>
  • Subject: Re: [awips2-users] can't connect to postgres
  • From: Justin Balbierer <jbalbier@xxxxxxxxx>
  • Date: Fri, 3 Oct 2014 20:00:20 -0400
Your advice worked. Thank you very much, Larry.

- Justin

Sent from my iPad

> On Oct 3, 2014, at 12:46 PM, "Larry D. Oolman" <ldoolman@xxxxxxxx> wrote:
> 
> Try changing 192.168.1.1/32 to 192.168.1.0/24
> 
> I believe the way you have it only allows that one IP address to connect.  
> Using /24
> will allow any ip address 192.168.1.x
> 
>> On 10/03/14 08:52, Justin Balbierer wrote:
>> I was trying to start my edex server for the first time and the only process 
>> pid that didn't start is postgres.
>> 
>> I am currently running my network over a router (DHCP), so my inet address 
>> is 192.168.1.3. I tried changing my
>> pg_hba.conf file to include the local network as follows (below), but 
>> postgres still will not run. Is there something I
>> am missing?
>> 
>> - Justin B.
>> 
>> # "local" is for Unix domain socket connections only
>> local   fxatext     all                               trust
>> local   hd_ob92oax  all                               trust
>> local   dc_ob7oax   all                               trust
>> local   metadata    all                               trust
>> local   maps        all                               trust
>> local   hmdb        all                               trust
>> local   postgres    all                               trust
>> local   ncep        all                               trust
>> local   ebxml       all                               trust
>> # IPv4 local connections:
>> host     all        all 192.168.1.1/32 <http://192.168.1.1/32>          trust
>> host    fxatext     all 127.0.0.1/32 <http://127.0.0.1/32>          trust
>> host    fxatext     all 192.168.1.1/32 <http://192.168.1.1/32>         trust
>> host    fxatext     all 162.0.0.0/8 <http://162.0.0.0/8>           trust
>> host    hd_ob92oax  all 127.0.0.1/32 <http://127.0.0.1/32>          trust
>> host    hd_ob92oax  all 192.168.1.1/32 <http://192.168.1.1/32>         trust
>> host    hd_ob92oax  all 162.0.0.0/8 <http://162.0.0.0/8>           trust
>> host    dc_ob7oax   all 127.0.0.1/32 <http://127.0.0.1/32>          trust
>> host    dc_ob7oax   all 192.168.1.1/32 <http://192.168.1.1/32>         trust
>> host    dc_ob7oax   all 162.0.0.0/8 <http://162.0.0.0/8>           trust
>> host    hmdb        all 127.0.0.1/32 <http://127.0.0.1/32>          trust
>> host    hmdb        all 192.168.1.1/32 <http://192.168.1.1/32>          trust
>> host    hmdb        all 162.0.0.0/8 <http://162.0.0.0/8>           trust
>> host    metadata    all 127.0.0.1/32 <http://127.0.0.1/32>          md5
>> host    metadata    all 192.168.1.1/32 <http://192.168.1.1/32>         md5
>> host    metadata    all 162.0.0.0/8 <http://162.0.0.0/8>           md5
>> host    maps        all 127.0.0.1/32 <http://127.0.0.1/32>          md5
>> host    maps        all 192.168.1.1/32 <http://192.168.1.1/32>          md5
>> host    maps        all 162.0.0.0/8 <http://162.0.0.0/8>           md5
>> host    postgres    all 127.0.0.1/32 <http://127.0.0.1/32>          md5
>> host    postgres    all 192.168.1.1/32 <http://192.168.1.1/32>          md5
>> host    postgres    all 162.0.0.0/8 <http://162.0.0.0/8>           md5
>> host    ncep        all 127.0.0.1/32 <http://127.0.0.1/32>          md5
>> host    ncep        all 192.168.1.1/32 <http://192.168.1.1/32>          md5
>> host    ncep        all 162.0.0.0/8 <http://162.0.0.0/8>           md5
>> host    ebxml       all 127.0.0.1/32 <http://127.0.0.1/32>          trust
>> host    ebxml       all 192.168.1.1/32 <http://192.168.1.1/32>          trust
>> host    ebxml       all 162.0.0.0/8 <http://162.0.0.0/8>           trust
>> # IPv6 local connections:
>> host    all         all         ::1/128               md5
>> 
>> 
>> _______________________________________________
>> awips2-users mailing list
>> awips2-users@xxxxxxxxxxxxxxxx
>> For list information, to unsubscribe, or change your membership options, 
>> visit: http://www.unidata.ucar.edu/mailing_lists/
> 
> 
> -- 
> Larry Oolman
> Department of Atmospheric Science
> University of Wyoming
> Dept. 3038, 1000 E. University Ave.
> Laramie, WY 82071
> ldoolman@xxxxxxxx
> http://www.uwyo.edu/atsc



  • 2014 messages navigation, sorted by:
    1. Thread
    2. Subject
    3. Author
    4. Date
    5. ↑ Table Of Contents
  • Search the awips2-users archives: