/[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 524 by misc, Tue Dec 7 02:40:22 2010 UTC revision 525 by misc, Tue Dec 7 02:40:23 2010 UTC
# Line 68  class postgresql { Line 68  class postgresql {
68          require => Package["postgresql-server"],          require => Package["postgresql-server"],
69      }      }
70    
71        # TODO convert it to a regular type ( so we can later change user and so on )
72        define database($description="", $user="postgres") {
73            exec { "createdb -U postgres $name '$description'":
74                user => root,
75                unless => "psql -l -U postgres | grep '^$name|'",
76            }
77        }
78    
79      define user($password) {      define user($password) {
80          $sql = "CREATE ROLE $name ENCRYPTED PASSWORD '$password' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;"          $sql = "CREATE ROLE $name ENCRYPTED PASSWORD '$password' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;"
81    
Legend:
Removed from v.524  
changed lines
  Added in v.525
  ViewVC Help
Powered by ViewVC 1.1.30