Subscription issue

[sidharth.v...@gmail.com]

Hi,
Has anyone faced subscription issues for postgresql db while configuring ha. Does someone know how i can fix this. Its just these 4 failures for subscription which i am getting while configuring HA

[sidharth.v...@gmail.com]

Some logs for reference -

pglogical_subscription pe-activity/s0c145c525e5722 create-sql,Pe_postgresql_psql,failure,,"SELECT pglogical.create_subscription(

subscription_name := 's0c145c525e5722',

provider_dsn := 'dbname=pe-activity host=puppetmom.puppet.com keepalives_count=2 keepalives_idle=30 port=5432 sslcert=/opt/puppetlabs/server/data/postgresql/9.6/data/certs/_local.cert.pem sslkey=/opt/puppetlabs/server/data/postgresql/9.6/data/certs/_local.private_key.pem sslmode=verify-full sslrootcert=/etc/puppetlabs/puppet/ssl/certs/ca.pem user=pe-ha-replication',

synchronize_structure := true)",/opt/puppetlabs/puppet/modules/puppet_enterprise/manifests/psql.pp,11

pglogical_subscription pe-classifier/s0c145c525e5722 create-sql,Pe_postgresql_psql,failure,,"SELECT pglogical.create_subscription(

subscription_name := 's0c145c525e5722',

provider_dsn := 'dbname=pe-classifier host=puppetmom.puppet.com keepalives_count=2 keepalives_idle=30 port=5432 sslcert=/opt/puppetlabs/server/data/postgresql/9.6/data/certs/_local.cert.pem sslkey=/opt/puppetlabs/server/data/postgresql/9.6/data/certs/_local.private_key.pem sslmode=verify-full sslrootcert=/etc/puppetlabs/puppet/ssl/certs/ca.pem user=pe-ha-replication',

synchronize_structure := true)",/opt/puppetlabs/puppet/modules/puppet_enterprise/manifests/psql.pp,11

pglogical_subscription pe-orchestrator/s0c145c525e5722 create-sql,Pe_postgresql_psql,failure,,"SELECT pglogical.create_subscription(

subscription_name := 's0c145c525e5722',

provider_dsn := 'dbname=pe-orchestrator host=puppetmom.puppet.com keepalives_count=2 keepalives_idle=30 port=5432 sslcert=/opt/puppetlabs/server/data/postgresql/9.6/data/certs/_local.cert.pem sslkey=/opt/puppetlabs/server/data/postgresql/9.6/data/certs/_local.private_key.pem sslmode=verify-full sslrootcert=/etc/puppetlabs/puppet/ssl/certs/ca.pem user=pe-ha-replication',

synchronize_structure := true)",/opt/puppetlabs/puppet/modules/puppet_enterprise/manifests/psql.pp,11

pglogical_subscription pe-rbac/s0c145c525e5722 create-sql,Pe_postgresql_psql,failure,,"SELECT pglogical.create_subscription(

subscription_name := 's0c145c525e5722',

provider_dsn := 'dbname=pe-rbac host=puppetmom.puppet.com keepalives_count=2 keepalives_idle=30 port=5432 sslcert=/opt/puppetlabs/server/data/postgresql/9.6/data/certs/_local.cert.pem sslkey=/opt/puppetlabs/server/data/postgresql/9.6/data/certs/_local.private_key.pem sslmode=verify-full sslrootcert=/etc/puppetlabs/puppet/ssl/certs/ca.pem user=pe-ha-replication',

synchronize_structure := true)",/opt/puppetlabs/puppet/modules/puppet_enterprise/manifests/psql.pp,11