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

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: