Correctly add tracker and wanna-build backups @ danzi
[mirror/dsa-puppet.git] / modules / postgres / manifests / backup_source.pp
index be48b37..363c890 100644 (file)
@@ -1,4 +1,6 @@
 #
+# See dsa-wiki input/howto/postgres-backup.creole for some documentation
+#
 class postgres::backup_source {
        file { "/usr/local/bin/pg-backup-file":
                mode    => '0555',
@@ -12,20 +14,58 @@ class postgres::backup_source {
                content => template('roles/postgresql_server/pg-backup-file.conf.erb'),
        }
 
-       if ! $::postgresql_key {
-               exec { 'create-postgresql-key':
-                       command => '/bin/su - postgres -c \'mkdir -p -m 02700 .ssh && ssh-keygen -C "`whoami`@`hostname` (`date +%Y-%m-%d`)" -P "" -f .ssh/id_rsa -q\'',
-                       onlyif  => '/usr/bin/getent passwd postgres > /dev/null && ! [ -e /var/lib/postgresql/.ssh/id_rsa ]'
-               }
-       }
+       ssh::keygen {'postgres': }
 
 
-       if $::hostname in [melartin] {
+       if $::hostname in [melartin, vittoria] {
+               postgres::backup_cluster { $::hostname:
+                       pg_version => '9.6',
+               }
+       }
+       if $::hostname in [buxtehude] {
+               postgres::backup_cluster { $::hostname:
+                       pg_version => '11',
+                       pg_port => 5433,
+               }
+               postgres::backup_cluster { "${::hostname}-debbugs":
+                       pg_version => '11',
+                       pg_port => 5441,
+                       pg_cluster => 'debbugs',
+               }
+       }
+       if $::hostname in [danzi] {
                postgres::backup_cluster { $::hostname:
                        pg_version => '9.6',
+                       pg_port => 5433,
                }
+               postgres::backup_cluster { "${::hostname}-tracker":
+                       pg_version => '9.6',
+                       pg_port => 5432,
+                       pg_cluster => 'tracker',
+               }
+               postgres::backup_cluster { "${::hostname}-debconf":
+                       pg_version => '9.6',
+                       pg_port => 5434,
+                       pg_cluster => 'debconf',
+               }
+               postgres::backup_cluster { "${::hostname}-wannabuild":
+                       pg_version => '9.6',
+                       pg_port => 5436,
+                       pg_cluster => 'wannabuild',
+               }
+       }
 
+       if $::hostname in [postgresql-manda-01] {
+               postgres::backup_cluster { "${::hostname}-bacula":
+                       pg_version => '11',
+                       pg_port => 5432,
+                       pg_cluster => 'bacula',
+               }
+       }
+
+       if $::hostname in [melartin, vittoria, godard, buxtehude, danzi, postgresql-manda-01] {
                postgres::backup_server::register_backup_clienthost { "backup-clienthost-${::fqdn}}":
                }
        }
+
 }