The validate_db_connection would come from https://github.com/puppetlabs/puppetlabs-postgresql#resource-postgresqlvalidate_db_connection which is declared by the postgresql::server -> postgresql::server::service class https://github.com/puppetlabs/puppetlabs-postgresql/blob/master/manifests/server/service.pp#L29 . The exec is https://github.com/puppetlabs/puppetlabs-postgresql/blob/master/manifests/validate_db_connection.pp#L51
So it appears that the service tries to start but isn't accepting connections via the psql command? There isn't enough information in the pasted errors to tell why though. One thing that is weird is the "-h -U -p " arguments with double spaces, indicating that a hostname/user/password is blan, so that might be why (even though this code is supposed to guard against it https://github.com/puppetlabs/puppetlabs-postgresql/blob/master/manifests/validate_db_connection.pp#L23-L34 ). What version of puppetlabs-postgresql is this? -Hunter On Tue, Jul 15, 2014 at 1:41 PM, Felix Frank < felix.fr...@alumni.tu-berlin.de> wrote: > Hi, > > it would be helpful to see the manifest that declares the Exec[validate > postgres connection for /postgres]. > > For debugging, the easiest approach is pasting the failing commands to a > shell. > > Regards, > Felix > > > On 07/14/2014 08:35 AM, Rajesh Taneja wrote: > > While running puppet agent, I am getting following error. Can someone help > me understand what might be wrong. > > Warning: Exec[validate postgres connection for > /postgres](provider=posix): Cannot understand environment setting > "PGPASSWORD=" > Warning: Exec[validate postgres connection for /postgres](provider=posix): > Cannot understand environment setting "PGPASSWORD=" > Notice: > /Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate > postgres connection for /postgres]/returns: Unable to connect to defined > database using: /usr/bin/psql --tuples-only --quiet -h -U -p --dbname > postgres > Error: echo 'Unable to connect to defined database using: /usr/bin/psql > --tuples-only --quiet -h -U -p --dbname postgres ' && false returned 1 > instead of one of [0] > Error: > /Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate > postgres connection for /postgres]/returns: change from notrun to 0 failed: > echo 'Unable to connect to defined database using: /usr/bin/psql > --tuples-only --quiet -h -U -p --dbname postgres ' && false returned 1 > instead of one of [0] > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to puppet-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/d4866842-9ae8-4ade-89c9-34aa9e82e074%40googlegroups.com > <https://groups.google.com/d/msgid/puppet-users/d4866842-9ae8-4ade-89c9-34aa9e82e074%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to puppet-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/53C591E8.5060003%40Alumni.TU-Berlin.de > <https://groups.google.com/d/msgid/puppet-users/53C591E8.5060003%40Alumni.TU-Berlin.de?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CAJaQvGAU%3DE5Wr-iJ33VowKD5tvi37XwEZxn%3DYnfGDNCq16vV9g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
