postgresql integration needs host option

[mellotron]

openstacklib::db::postgresql assumes that the postgresql database is on localhost, while ::mysql allows one to specify a host => option. The puppet-postgresql module has the ability to use a connect_settings variable to work around this issue.

I have PostgreSQL set up in a 3-node HA cluster with a VIP for the master node.

Sadly, I can't use keystone::db::postgresql, etc, as I can't specify these to talk to a VIP and localhost might not be my master when puppet runs.

[Takashi Kajinami (kajinamit)]

We are currently using the postgresql::server::db defined resource type from puppet-postgresql but this defined type does not support such host option.

Because the option is not implemented in the underlying library, there is no good way to implement this in our modules.

Maybe you better bring this topic to the puppet-postgresql project first. They might have better idea about the possible solutions.