Missing fromrepo on postgresql-server and postgresql-client-libs

[arthurzenika]

While deploying postgres-formula on debian jessie I'm getting a problem. The postgresql-server and postgresql-client-libs don't get installed because of apt pinning.

# apt-cache policy postgresql-common
postgresql-common:
  Installed: (none)
  Candidate: 165+deb8u1
  Version table:
  177.pgdg80+1 0
        500 http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg/main amd64 Packages
     165+deb8u1 0
        990 http://httpredir.debian.org/debian/ jessie/main amd64 Packages

You can see 990 for the jessie pkg and 500 for the jessie-pgdg package (less priority).

To get it to work we either have to add some pinning configuration or use fromrepo on the pkg.installed.

This is the quick hack I did to get it to work (which if necessary should be adapted to work on all distros) :

# git diff
diff --git a/postgres/client.sls b/postgres/client.sls
index c51ca11..6657cb9 100644
--- a/postgres/client.sls
+++ b/postgres/client.sls
@@ -19,6 +19,7 @@ include:
 postgresql-client-libs:
   pkg.installed:
     - pkgs: {{ pkgs }}
+    - fromrepo: jessie-pgdg
 {%- if postgres.use_upstream_repo %}
     - refresh: True
     - require:
diff --git a/postgres/server.sls b/postgres/server.sls
index a553dae..37ad460 100644
--- a/postgres/server.sls
+++ b/postgres/server.sls
@@ -14,6 +14,7 @@ include:
 postgresql-server:
   pkg.installed:
     - pkgs: {{ pkgs }}
+    - fromrepo: jessie-pgdg
 {%- if postgres.use_upstream_repo %}
     - refresh: True
     - require:

[noelmcloughlin]

I have this fromrepo working on a branch (fedora,ubuntu/centos). Will raise a PR soon.