850569 - use ident method in pg_hba.conf

Do not allow access to everybody. Just katello user to katello db, candlepin user to candlepin db and foreman user to foreman db.
Revert "802346 - wait for postgres to come up in puppet"

This reverts commit 2afb6b851d58700ffb5e99e3124c43e0d95dd694.

Conflicts:
	katello-configure/modules/postgres/manifests/service.pp
	puppet/modules/postgres/manifests/sqlexec.pp

This is not needed since we have service-wait.
when connecting to postgres DB you have to be postgres user

addressing:
psql: FATAL:  Ident authentication failed for user "postgres"

and:
  Failed, please check [/var/log/katello/katello-configure/create-postgresql-katello-user.log]
  Report errors using # katello-debug tool.
err: /Stage[main]/Foreman::Config/Postgres::Createuser[foreman]/Sqlexec[createuser-foreman]/Exec[psql -h localhost --username=postgres postgres -c "CREATE ROLE foreman WITH LOGIN PASSWORD 'foreman' CREATEDB;" >> /var/log/katello/katello-configure/create-postgresql-foreman-user.log 2>&1]/returns: change from notrun to 0 failed: psql -h localhost --username=postgres postgres -c "CREATE ROLE foreman WITH LOGIN PASSWORD 'foreman' CREATEDB;" >> /var/log/katello/katello-configure/create-postgresql-foreman-user.log 2>&1 returned 2 instead of one of [0] at /usr/share/katello/install/puppet/modules/postgres/manifests/sqlexec.pp:16
removing sqlexec.pp

this is dead code now
call /usr/share/candlepin/cpdb as postgres user

addressing:
Creating Candlepin database user
err: /Stage[main]/Candlepin::Config/Exec[cpdb]/returns: change from notrun to 0 failed: /usr/share/candlepin/cpdb --create -u candlepin -d candlepin >> /var/log/katello/katello-configure/cpdb.log 2>&1 && touch /var/lib/katello/cpdb_done returned 1 instead of one of [0] at /usr/share/katello/install/puppet/modules/candlepin/manifests/config.pp:72
err: /Stage[main]/Candlepin::Config/Exec[cpdb]: Failed to call refresh: /usr/share/candlepin/cpdb --create -u candlepin -d candlepin >> /var/log/katello/katello-configure/cpdb.log 2>&1 && touch /var/lib/katello/cpdb_done returned 1 instead of one of [0] at /usr/share/katello/install/puppet/modules/candlepin/manifests/config.pp:72
err: /Stage[main]/Candlepin::Service/Exec[cpinit]: Failed to call refresh: /usr/bin/wget --timeout=30 --tries=5 --retry-connrefused -qO- http://localhost:8080/candlepin/admin/init >/var/log/katello/katello-configure/cpinit.log 2>&1 && touch /var/lib/katello/cpinit_done returned 4 instead of one of [0] at /usr/share/katello/install/puppet/modules/candlepin/manifests/service.pp:27
Populating Katello database schema
pass password to candlepin cpdb
use md5 for connection to postgres instead of ident
do not print SQL query on output as it will confuse grep
do not call pulp service script, call qpidd and mongodb directly

pulp-server is not service, it is just wrapper around several other
services and httpd is one of them, which is handled by katello-service and sysV as well,
which cause some failures during startup and shutdown.

addressing:
 katello-service  stop
Shutting down Katello services...
Stopping katello:
Stopping elasticsearch: [  OK  ]
Stopping httpd: [  OK  ]
Stopping Qpid AMQP daemon: [  OK  ]
Stopping mongod: [  OK  ]
Stopping httpd: [FAILED]
Stopping tomcat6: [  OK  ]
Done.
Merge pull request #852 from xsuchy/pull-req-pulp-server

do not call pulp service script, call qpidd and mongodb directly
Merge pull request #835 from xsuchy/pull-req-bz850569

do not allow connect to Pg without password