Postgresql pg_hba.conf needs IP addresses

Bug #902672 reported by Patrick Hetu
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
postgresql (Juju Charms Collection)
Fix Released
Undecided
Mark Mims

Bug Description

I add relations to postgresql and it doesn't restart because the address in pg_hba.conf
was a domain name.

Maybe we can use gethostip from the syslinux package to make sure it's an IP addresses
that we add::

host=`gethostip $(unit-get private-address) | awk '{print 2ドル}'`

Related branches

lp:~patrick-hetu/charms/precise/postgresql/fix-gethostip-902672
Mark Mims (community): Approve
Diff: 47 lines (+7/-5)
3 files modified
hooks/common.sh (+2/-2)
hooks/db-relation-changed (+4/-2)
hooks/install (+1/-1)
api
Patrick Hetu (patrick-hetu)
affects: charm → postgresql (juju Charms Collection)
Mark Mims (mark-mims)
Changed in postgresql (juju Charms Collection):
assignee: nobody → Mark Mims (mark-mims)
status: New → In Progress
Revision history for this message
Timothy R. Chavez (timrchavez) wrote :

Any progress on a fix? I think I just got burned by this :/

2012年05月11日 18:21:22,024 unit:postgresql/0: hook.output INFO: * The PostgreSQL server failed to start. Please check the log output:
2012年05月11日 23:21:21 UTC LOG: specifying both host name and CIDR mask is invalid: "ip-10-190-103-176.ec2.internal/32"
2012年05月11日 23:21:21 UTC CONTEXT: line 100 of configuration file "/etc/postgresql/9.1/main/pg_hba.conf"
2012年05月11日 23:21:21 UTC FATAL: could not load pg_hba.conf
...fail!

Mark Mims (mark-mims)
Changed in postgresql (Juju Charms Collection):
status: In Progress → Fix Committed
Mark Mims (mark-mims)
Changed in postgresql (Juju Charms Collection):
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.

AltStyle によって変換されたページ (->オリジナル) /