lp://staging/~marcoceppi/charms/precise/postgresql/ip-hostname-verification

Branch merges

Propose for merging

No branches dependent on this one.

Merged into lp://staging/charms/postgresql at revision 32

Kapil Thangavelu (community): Approve on 2013-02-13

Diff: 0 lines api

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Bug #1117542: Postgres server fails because of hostname + CIDR

Undecided

Fix Released

Link a bug report

Related blueprints

33. By Marco Ceppi on 2013-02-13

Use interpolation instead of join

32. By Marco Ceppi on 2013-02-12

Added check for ip or hostname

31. By Marco Ceppi on 2013-02-07

Marco Ceppi 2013-02-06 Install postresql-contrib

30. By Marco Ceppi on 2013-02-07

Marco Ceppi 2013-02-06 Since we're working with explicit addresses don't appent /32

29. By Juan L. Negron on 2013-01-15

Merging Sidnei's bag of tricks. MP:143097

28. By Juan L. Negron on 2012-11-28

While putting together a charm with a postgresql relation, I ran into a situation that appears to have been anticipated by a TODO comment in the postgresql charm:

    # XXX: This appears to reset the password every time
    # this might not end well

Specifically, I found that the password was being reset (IIRC by the db-{,admin-}relation-changed hook) after I'd made use of it in my charm, and of course then everything went wrong.

There doesn't seem any particularly nice way to deal with this; I don't think we can rely on the password being cached in the relation, because multiple relations might make use of the same user. But given the existing password handling, it doesn't seem that bad to just cache it in a file readable only by root, and this fixed the problem for me. Of course I'm open to better suggestions. MP: 135128

27. By Juan L. Negron on 2012-11-28

I have a charm that needs the debversion type in PostgreSQL. As far as I can tell, there seems no harm in just trying to install this unconditionally. MP: 135130

26. By Juan L. Negron on 2012-11-28

The postgresql charm includes *-relation-departed hook symlinks, but hooks.py doesn't implement them and exits 1 when they're called. This has the effect that whenever a condition arises such that a *-relation-departed hook is called, the relation goes into an error state.

I don't know if *-relation-departed should be implemented (I had some trouble divining the exact difference between that and *-relation-broken) but it would be better for them to be absent than broken. MP:135132

25. By Juan L. Negron on 2012-11-05

Add storage options, and add config options for postgresql.conf - also add the capability to autotune based on system RAM/CPU if wanted. MP:132166 by mthaddon

24. By David Owen on 2012-06-20

Only reload for pg_hba updates