/[adm]/puppet/modules/postgresql/manifests/init.pp
ViewVC logotype

Diff of /puppet/modules/postgresql/manifests/init.pp

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 536 by misc, Tue Dec 7 02:40:36 2010 UTC revision 646 by misc, Fri Dec 17 01:45:21 2010 UTC
# Line 91  class postgresql { Line 91  class postgresql {
91      }      }
92    
93      define user($password) {      define user($password) {
94          $sql = "CREATE ROLE $name ENCRYPTED PASSWORD '$password' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;"          $sql = "CREATE ROLE $name ENCRYPTED PASSWORD '\$pass' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;"
95    
96          exec { "psql -U postgres -c \"$sql\" ":          exec { "psql -U postgres -c \"$sql\" ":
97              user => root,              user => root,
98                environment => "pass=$password",
99              unless => "psql -A -t -U postgres -c '\du $name' | grep '$name'",              unless => "psql -A -t -U postgres -c '\du $name' | grep '$name'",
100          }          }
101      }      }
Legend:
Removed from v.536  
changed lines
  Added in v.646
  ViewVC Help
Powered by ViewVC 1.1.30