Yes, I believe so.  When I ran this, it was using ident support locally and not the generated password (as I'm generating it in the wrong place anyway).  I'd actually like to remove the password for postgresql later, once https://github.com/puppetlabs/puppet-postgresql/pull/158 has been merged.