When you enter “service edex_postgres status” when logged in as root, what is
the message? Also, check the log files related to postgres and see if there are
any errors.
Joe Barrett
WDT, Inc.
Norman, OK
From: awips2-users-bounces@xxxxxxxxxxxxxxxx
[mailto:awips2-users-bounces@xxxxxxxxxxxxxxxx] On Behalf Of Justin Balbierer
Sent: Friday, October 03, 2014 9:52 AM
To: awips2-users@xxxxxxxxxxxxxxxx
Subject: [awips2-users] can't connect to postgres
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
