Created
July 8, 2014 12:59
-
-
Save domcleal/9a9d92504991e0f66957 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
all good on v3.3.3... | |
[root@foremanf19 ~]# puppet module install puppetlabs/postgresql | |
Notice: Preparing to install into /etc/puppet/modules ... | |
Notice: Downloading from https://forge.puppetlabs.com ... | |
Notice: Installing -- do not interrupt ... | |
/etc/puppet/modules | |
└─┬ puppetlabs-postgresql (v3.3.3) | |
├── puppetlabs-apt (v1.5.0) | |
├── puppetlabs-concat (v1.1.0) | |
├── puppetlabs-firewall (v1.1.2) | |
└── puppetlabs-stdlib (v4.2.2) | |
[root@foremanf19 ~]# puppet apply -e 'include postgresql::server' | |
Warning: Config file /etc/puppet/hiera.yaml not found, using Hiera defaults | |
Notice: Compiled catalog for foremanf19.example.com in environment production in 1.27 seconds | |
Notice: /Stage[main]/Concat::Setup/File[/var/lib/puppet/concat]/ensure: created | |
Notice: /Stage[main]/Concat::Setup/File[/var/lib/puppet/concat/bin]/ensure: created | |
Notice: /Stage[main]/Concat::Setup/File[/var/lib/puppet/concat/bin/concatfragments.sh]/ensure: defined content as '{md5}7bbe7c5fce25a5ddd20415d909ba44fc' | |
Notice: /Stage[main]/Postgresql::Client/Package[postgresql-client]/ensure: created | |
Notice: /Stage[main]/Postgresql::Client/File[/usr/local/bin/validate_postgresql_connection.sh]/ensure: defined content as '{md5}20301932819f035492a30880f5bf335a' | |
Notice: /Stage[main]/Postgresql::Server::Install/Package[postgresql-server]/ensure: created | |
Notice: /Stage[main]/Postgresql::Server::Initdb/Exec[postgresql_initdb]/returns: executed successfully | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Config_entry[listen_addresses]/Postgresql_conf[listen_addresses]/ensure: created | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf]/ensure: created | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf/fragments.concat.out]/ensure: created | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf/fragments]/ensure: created | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Pg_hba_rule[local access to database with same name]/Concat::Fragment[pg_hba_rule_local access to database with same name]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf/fragments/002_pg_hba_rule_local access to database with same name]/ensure: defined content as '{md5}61275db6b21adbf53b575d4c1a6bbed1' | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Pg_hba_rule[allow access to ipv6 localhost]/Concat::Fragment[pg_hba_rule_allow access to ipv6 localhost]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf/fragments/101_pg_hba_rule_allow access to ipv6 localhost]/ensure: defined content as '{md5}ab588822a007943223faadf86be3044a' | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Pg_hba_rule[local access as postgres user]/Concat::Fragment[pg_hba_rule_local access as postgres user]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf/fragments/001_pg_hba_rule_local access as postgres user]/ensure: defined content as '{md5}03454101c43efbcdecc71dd3f734a68f' | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Pg_hba_rule[deny access to postgresql user]/Concat::Fragment[pg_hba_rule_deny access to postgresql user]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf/fragments/004_pg_hba_rule_deny access to postgresql user]/ensure: defined content as '{md5}205b04b3328583b8330f59e37d55c8e8' | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Pg_hba_rule[allow localhost TCP access to postgresql user]/Concat::Fragment[pg_hba_rule_allow localhost TCP access to postgresql user]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf/fragments/003_pg_hba_rule_allow localhost TCP access to postgresql user]/ensure: defined content as '{md5}f30c1a00a0759236b37352c32cd0e284' | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf/fragments.concat]/ensure: created | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Pg_hba_rule[allow access to all users]/Concat::Fragment[pg_hba_rule_allow access to all users]/File[/var/lib/puppet/concat/_var_lib_pgsql_data_pg_hba.conf/fragments/100_pg_hba_rule_allow access to all users]/ensure: defined content as '{md5}0c5966ab4591f092ef66ce333bb3f463' | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/Exec[concat_/var/lib/pgsql/data/pg_hba.conf]/returns: executed successfully | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/Exec[concat_/var/lib/pgsql/data/pg_hba.conf]: Triggered 'refresh' from 8 events | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/File[/var/lib/pgsql/data/pg_hba.conf]/content: content changed '{md5}9784211d3c0e7ad5a539b9dcb964b9c3' to '{md5}c31ee6f98ede22591533e8056938c902' | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/File[/var/lib/pgsql/data/pg_hba.conf]/owner: owner changed 'postgres' to 'root' | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/File[/var/lib/pgsql/data/pg_hba.conf]/mode: mode changed '0600' to '0640' | |
Notice: /File[/var/lib/pgsql/data/pg_hba.conf]/seluser: seluser changed 'unconfined_u' to 'system_u' | |
Notice: /Stage[main]/Postgresql::Server::Reload/Exec[postgresql_reload]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Service/Anchor[postgresql::server::service::begin]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Service/Service[postgresqld]/ensure: ensure changed 'stopped' to 'running' | |
Notice: /Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate postgres connection for /postgres]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Service/Anchor[postgresql::server::service::end]: Triggered 'refresh' from 1 events | |
Notice: Finished catalog run in 19.45 seconds | |
now latest master... | |
[root@foremanf19 ~]# git clone https://github.com/puppetlabs/puppetlabs-postgresql | |
Cloning into 'puppetlabs-postgresql'... | |
remote: Reusing existing pack: 3429, done. | |
remote: Total 3429 (delta 0), reused 0 (delta 0) | |
Receiving objects: 100% (3429/3429), 799.84 KiB | 586.00 KiB/s, done. | |
Resolving deltas: 100% (1748/1748), done. | |
[root@foremanf19 ~]# puppet apply --modulepath .:/etc/puppet/modules -e 'include postgresql::server' | |
Warning: Config file /etc/puppet/hiera.yaml not found, using Hiera defaults | |
Warning: Scope(Class[Postgresql::Server]): Passing "version" to postgresql::server is deprecated; please use postgresql::globals instead. | |
Notice: Compiled catalog for foremanf19.example.com in environment production in 1.39 seconds | |
Error: Could not set 'present' on ensure: No such file or directory - /etc/sysconfig/pgsql/postgresql at 111:/root/postgresql/manifests/server/config.pp | |
Error: Could not set 'present' on ensure: No such file or directory - /etc/sysconfig/pgsql/postgresql at 111:/root/postgresql/manifests/server/config.pp | |
Wrapped exception: | |
No such file or directory - /etc/sysconfig/pgsql/postgresql | |
Error: /Stage[main]/Postgresql::Server::Config/File[/etc/sysconfig/pgsql/postgresql]/ensure: change from absent to present failed: Could not set 'present' on ensure: No such file or directory - /etc/sysconfig/pgsql/postgresql at 111:/root/postgresql/manifests/server/config.pp | |
Notice: /Stage[main]/Postgresql::Server::Config/Concat[/var/lib/pgsql/data/pg_hba.conf]/File[/var/lib/pgsql/data/pg_hba.conf]/owner: owner changed 'root' to 'postgres' | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Config_entry[port]/Postgresql_conf[port]/ensure: created | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Config_entry[port]/Exec[postgresql_stop]: Dependency File[/etc/sysconfig/pgsql/postgresql] has failures: true | |
Warning: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Config_entry[port]/Exec[postgresql_stop]: Skipping because of failed dependencies | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Config_entry[port]/Augeas[override PGPORT in /etc/sysconfig/pgsql/postgresql]: Dependency File[/etc/sysconfig/pgsql/postgresql] has failures: true | |
Warning: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Config_entry[port]/Augeas[override PGPORT in /etc/sysconfig/pgsql/postgresql]: Skipping because of failed dependencies | |
Notice: /Stage[main]/Postgresql::Server::Service/Anchor[postgresql::server::service::begin]: Dependency File[/etc/sysconfig/pgsql/postgresql] has failures: true | |
Warning: /Stage[main]/Postgresql::Server::Service/Anchor[postgresql::server::service::begin]: Skipping because of failed dependencies | |
Notice: /Stage[main]/Postgresql::Server::Service/Anchor[postgresql::server::service::begin]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Service/Service[postgresqld]: Dependency File[/etc/sysconfig/pgsql/postgresql] has failures: true | |
Warning: /Stage[main]/Postgresql::Server::Service/Service[postgresqld]: Skipping because of failed dependencies | |
Notice: /Stage[main]/Postgresql::Server::Service/Service[postgresqld]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate postgres connection for /postgres]: Dependency File[/etc/sysconfig/pgsql/postgresql] has failures: true | |
Warning: /Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate postgres connection for /postgres]: Skipping because of failed dependencies | |
Notice: /Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate postgres connection for /postgres]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Service/Anchor[postgresql::server::service::end]: Dependency File[/etc/sysconfig/pgsql/postgresql] has failures: true | |
Warning: /Stage[main]/Postgresql::Server::Service/Anchor[postgresql::server::service::end]: Skipping because of failed dependencies | |
Notice: /Stage[main]/Postgresql::Server::Service/Anchor[postgresql::server::service::end]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Reload/Exec[postgresql_reload]: Dependency File[/etc/sysconfig/pgsql/postgresql] has failures: true | |
Warning: /Stage[main]/Postgresql::Server::Reload/Exec[postgresql_reload]: Skipping because of failed dependencies | |
Notice: /Stage[main]/Postgresql::Server::Reload/Exec[postgresql_reload]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server/Anchor[postgresql::server::end]: Dependency File[/etc/sysconfig/pgsql/postgresql] has failures: true | |
Warning: /Stage[main]/Postgresql::Server/Anchor[postgresql::server::end]: Skipping because of failed dependencies | |
Notice: Finished catalog run in 2.86 seconds | |
patch applied... | |
[root@foremanf19 ~]# puppet apply --modulepath .:/etc/puppet/modules -e 'include postgresql::server' | |
Warning: Config file /etc/puppet/hiera.yaml not found, using Hiera defaults | |
Warning: Scope(Class[Postgresql::Server]): Passing "version" to postgresql::server is deprecated; please use postgresql::globals instead. | |
Notice: Compiled catalog for foremanf19.example.com in environment production in 1.37 seconds | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Config_entry[port]/File[systemd-port-override]/ensure: created | |
Notice: /Stage[main]/Postgresql::Server::Config/Postgresql::Server::Config_entry[port]/Exec[restart-systemd]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Service/Anchor[postgresql::server::service::begin]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Service/Service[postgresqld]: Triggered 'refresh' from 1 events | |
Notice: /Stage[main]/Postgresql::Server::Service/Postgresql::Validate_db_connection[validate_service_is_running]/Exec[validate postgres connection for /postgres]: Triggered 'refresh' from 1 events | |
Notice: Finished catalog run in 2.94 seconds | |
[root@foremanf19 ~]# puppet apply --modulepath .:/etc/puppet/modules -e 'include postgresql::server' | |
Warning: Config file /etc/puppet/hiera.yaml not found, using Hiera defaults | |
Warning: Scope(Class[Postgresql::Server]): Passing "version" to postgresql::server is deprecated; please use postgresql::globals instead. | |
Notice: Compiled catalog for foremanf19.example.com in environment production in 1.36 seconds | |
Notice: Finished catalog run in 0.66 seconds | |
[root@foremanf19 ~]# systemctl status postgresql | |
postgresql.service - PostgreSQL database server | |
Loaded: loaded (/etc/systemd/system/postgresql.service; enabled) | |
Active: active (running) since Tue 2014-07-08 12:56:02 UTC; 17s ago | |
Process: 10633 ExecStop=/usr/bin/pg_ctl stop -D ${PGDATA} -s -m fast (code=exited, status=0/SUCCESS) | |
Process: 10652 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=0/SUCCESS) | |
Process: 10646 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS) | |
Main PID: 10656 (postgres) | |
CGroup: name=systemd:/system/postgresql.service | |
├─10656 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432 | |
├─10657 postgres: logger process | |
├─10659 postgres: checkpointer process | |
├─10660 postgres: writer process | |
├─10661 postgres: wal writer process | |
├─10662 postgres: autovacuum launcher process | |
└─10663 postgres: stats collector process | |
Jul 08 12:56:01 foremanf19.example.com systemd[1]: Starting PostgreSQL database server... | |
Jul 08 12:56:02 foremanf19.example.com systemd[1]: Started PostgreSQL database server. | |
[root@foremanf19 ~]# cat /etc/systemd/system/postgresql.service | |
.include /lib/systemd/system/postgresql.service | |
[Service] | |
Environment=PGPORT=5432 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment