\u7531\u4e8e\u67d0\u79cd\u539f\u56e0\uff0c\u6211\u6b63\u5728\u5bfb\u627e\u4f7f\u7528Puppet\u5b89\u88c5PostgreSQL\u7684\u65b9\u6cd5\uff0c\u6211\u53d1\u73b0PuppetLabs\u63d0\u4f9b\u7684\u6a21\u5757\u4f3c\u4e4e\u53ef\u4ee5\u4f7f\u7528\uff0c\u6240\u4ee5\u6211\u8bb0\u5f55\u4e0b\u4e86\u76f8\u5173\u6b65\u9aa4\u3002<\/p>\n
\u73af\u5883\u662fCentOS 7.2\u548cPuppet 3.8.7\u3002<\/p>\n
Puppet\u5728\u5355\u673a\u6a21\u5f0f\u4e0b\u8fdb\u884c\u4e86\u8bd5\u9a8c\uff0c\u4ec5\u5e94\u7528\u4e8e\u81ea\u8eab\u670d\u52a1\u5668\u3002<\/p>\n
\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0cyum\u4e0d\u4f1a\u5305\u542b\u6b64\u5185\u5bb9\uff0c\u56e0\u6b64\u8bf7\u5b89\u88c5PuppetLabs\u63d0\u4f9b\u7684\u8f6f\u4ef6\u6e90\u3002<\/p>\n
[root@localhost ~]# rpm -ivh http:\/\/yum.puppetlabs.com\/puppetlabs-release-el-7.noarch.rpm\r\nhttp:\/\/yum.puppetlabs.com\/puppetlabs-release-el-7.noarch.rpm \u3092\u53d6\u5f97\u4e2d\r\n\u8b66\u544a: \/var\/tmp\/rpm-tmp.d38UNf: \u30d8\u30c3\u30c0\u30fc V4 RSA\/SHA1 Signature\u3001\u9375 ID 4bd6ec30: NOKEY\r\n\u6e96\u5099\u3057\u3066\u3044\u307e\u3059... ################################# [100%]\r\n\u66f4\u65b0\u4e2d \/ \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d...\r\n 1:puppetlabs-release-7-12 ################################# [100%]\r\n<\/code><\/pre>\n\u7528 yum \u6765\u5b89\u88c5 puppet\u3002<\/p>\n
[root@localhost ~]# yum install puppet\r\n<\/code><\/pre>\n[root@localhost ~]# puppet --version\r\n3.8.7\r\n<\/code><\/pre>\n\u5728\u5b89\u88c5\u65f6\u4e3a\u4ec0\u4e48\u4e0d\u6765\u521b\u5efa\u4e00\u4e2a manifest\u7f6e\u304d\u5834\u7684\u76ee\u5f55\u5462\uff1f\u8bf7\u63d0\u524d\u51c6\u5907\u597d\u3002<\/p>\n
[root@localhost ~]# mkdir -p \/etc\/puppet\/manifests\r\n<\/code><\/pre>\n\u5b89\u88c5Puppetlabs\u7684PostgreSQL\u6a21\u5757\u3002<\/h1>\n
\u53ef\u4ee5\u901a\u8fc7Puppet\u6a21\u5757\u547d\u4ee4\u8fdb\u884c\u5b89\u88c5\u3002<\/p>\n
[root@localhost ~]# puppet module install puppetlabs-postgresql\r\nNotice: Preparing to install into \/etc\/puppet\/modules ...\r\nNotice: Downloading from https:\/\/forgeapi.puppetlabs.com ...\r\nNotice: Installing -- do not interrupt ...\r\n\/etc\/puppet\/modules\r\n\u2514\u2500\u252c puppetlabs-postgresql (v4.7.1)\r\n \u251c\u2500\u2500 puppetlabs-apt (v2.2.2)\r\n \u251c\u2500\u2500 puppetlabs-concat (v2.1.0)\r\n \u2514\u2500\u2500 puppetlabs-stdlib (v4.12.0)\r\n<\/code><\/pre>\n\u987a\u4fbf\u63d0\u4e00\u4e0b\uff0cPuppet\u6a21\u5757\u547d\u4ee4\u4e5f\u53ef\u4ee5\u8fdb\u884c\u641c\u7d22\u3002<\/p>\n
[root@localhost postgresql]# puppet module search postgresql\r\nNotice: Searching https:\/\/forgeapi.puppetlabs.com ...\r\nNAME DESCRIPTION AUTHOR KEYWORDS \r\npuppetlabs-postgresql Offers support for basic ... @puppetlabs postgresql \r\nexample42-postgresql Puppet module for postgresql @example42 postgresql \r\nakumria-postgresql Install and configure the... @akumria postgresql \r\ngodp1301-postgresql PostgreSQL defined resour... @godp1301 \r\nherculesteam-augeasproviders_postgresql Augeas-based postgresql t... @herculesteam postgresql \r\nnpwalker-pe_external_postgresql A module for installing a... @npwalker \r\ninkling-postgresql PostgreSQL defined resour... @inkling postgresql \r\nicinga-icingaweb2 Module to install and mai... @icinga postgresql \r\nstschulte-postgres Manage postgres roles and... @stschulte postgresql \r\nULHPC-backupninja Install and configure bac... @ULHPC postgresql \r\nrhoml-pgbouncer Installs and configure pg... @rhoml postgresql \r\nchrisjohntapp-repmgr Module to install and con... @chrisjohntapp postgresql \r\ncpitman-database_schema Manages database schema c... @cpitman postgresql \r\nit2ndq-barman Barman (Backup and Recove... @it2ndq postgresql \r\nleoc-phppgadmin Deprecated! Use velaluqa\/... @leoc postgresql \r\nmwhahaha-pgpool A puppet module to config... @mwhahaha postgresql \r\njlcox-postgresplus Installation and confgiur... @jlcox postgresql \r\nEnvek-pgtune Configures PostgreSQL ins... @Envek postgresql \r\ndomcleal-augeasproviders Alternative Augeas-based ... @domcleal postgresql \r\njhoblitt-pureftpd Manages the pure-ftpd pac... @jhoblitt postgresql \r\nknowshan-phppgadmin Install and configure php... @knowshan postgresql \r\njdowning-wal_e Setup wal_e @jdowning postgresql \r\nvelaluqa-phppgadmin Puppet PhpPgAdmin Module @velaluqa postgresql \r\nSchnWalter-happydev Setup a Development Envir... @SchnWalter postgresql \r\nmjhas-mailserver This Module provides a ma... @mjhas postgresql \r\nechoes-postgres_xc Postgres-XC Module @echoes postgresql\r\n<\/code><\/pre>\n\u5728\u4ee3\u7406\u73af\u5883\u4e0b\u8fdb\u884c\u6a21\u5757\u5b89\u88c5\u3002<\/h2>\n
\u5c06\u4ee5\u4e0b\u53c2\u6570\u8bbe\u7f6e\u5230\/etc\/puppet\/puppet.conf\u6587\u4ef6\u4e2d\u3002<\/p>\n
\n- \n
http_proxy_host<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
http_proxy_port<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
http_proxy_user<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
http_proxy_password<\/ul>\n\u8fdb\u884cPostgreSQL\u7684\u5b89\u88c5\u548c\u542f\u52a8<\/h1>\n
\u6839\u636e README \u4e2d\u7684\u4f7f\u7528\u8bf4\u660e\uff0c\u4f3c\u4e4e\u5728\u6e05\u5355\u4e2d\u4f7f\u7528 postgresql::server \u7c7b\u5373\u53ef\u3002<\/p>\n
\u66ab\u6642\u5148\u8a66\u8457\u5beb\u4e00\u500b\u80fd\u5920\u5b89\u88dd\u5230\u81ea\u5df1\u7684\u4f3a\u670d\u5668\u4e0a\u7684manifest\u6587\u4ef6\u3002<\/p>\n
\r\nclass<\/span> {'postgresql::server': \r\n listen_addresses => '*',\r\n postgres_password => 'postgres',\r\n}<\/span>\r\n\r\n<\/code><\/pre>\n\u8bd5\u8bd5\u770b\u3002<\/p>\n
[root@localhost manifests]# puppet apply \/etc\/puppet\/manifests\/site.pp \r\nWarning: Config file \/etc\/puppet\/hiera.yaml not found, using Hiera defaults\r\nWarning: Scope(Concat[\/var\/lib\/pgsql\/data\/pg_ident.conf]): The $force parameter to concat is deprecated and has no effect.\r\nNotice: Compiled catalog for localhost in environment production in 0.87 seconds\r\nNotice: \/Stage[main]\/Postgresql::Client\/Package[postgresql-client]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Client\/File[\/usr\/local\/bin\/validate_postgresql_connection.sh]\/ensure: defined content as '{md5}20301932819f035492a30880f5bf335a'\r\nNotice: \/Stage[main]\/Postgresql::Server::Install\/Package[postgresql-server]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Initdb\/Exec[postgresql_initdb]\/returns: executed successfully\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/File[systemd-override]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Postgresql::Server::Config_entry[data_directory]\/Postgresql_conf[data_directory]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Concat[\/var\/lib\/pgsql\/data\/pg_ident.conf]\/File[\/var\/lib\/pgsql\/data\/pg_ident.conf]\/content: content changed '{md5}f11c8332d3f444148c0b8ee83ec5fc6d' to '{md5}9300ac105fe777787ac9e793b8df8d25'\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Concat[\/var\/lib\/pgsql\/data\/pg_ident.conf]\/File[\/var\/lib\/pgsql\/data\/pg_ident.conf]\/mode: mode changed '0600' to '0640'\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Exec[restart-systemd]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Postgresql::Server::Config_entry[listen_addresses]\/Postgresql_conf[listen_addresses]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Postgresql::Server::Config_entry[port]\/Postgresql_conf[port]\/ensure: created\r\nNotice: \/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'\r\nNotice: \/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'\r\nNotice: \/Stage[main]\/Postgresql::Server::Service\/Anchor[postgresql::server::service::begin]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Postgresql::Server::Service\/Service[postgresqld]\/ensure: ensure changed 'stopped' to 'running'\r\nNotice: \/Stage[main]\/Postgresql::Server::Service\/Postgresql::Validate_db_connection[validate_service_is_running]\/Exec[validate postgres connection for @:5432\/postgres]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Postgresql::Server::Service\/Anchor[postgresql::server::service::end]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Postgresql::Server::Reload\/Exec[postgresql_reload]: Triggered 'refresh' from 1 events\r\nNotice: Finished catalog run in 45.50 seconds\r\n[root@localhost manifests]# pgrep -a postgres\r\n29258 \/usr\/bin\/postgres -D \/var\/lib\/pgsql\/data -p 5432\r\n29259 postgres: logger process \r\n29261 postgres: checkpointer process \r\n29262 postgres: writer process \r\n29263 postgres: wal writer process \r\n29264 postgres: autovacuum launcher process \r\n29265 postgres: stats collector process\r\n[root@localhost manifests]# rpm -qa | grep postgres\r\npostgresql-9.2.15-1.el7_2.x86_64\r\npostgresql-libs-9.2.15-1.el7_2.x86_64\r\npostgresql-server-9.2.15-1.el7_2.x86_64\r\n<\/code><\/pre>\n\u54e6\uff0c\u770b\u8d77\u6765\u64cd\u4f5c\u7cfb\u7edf\u9ed8\u8ba4\u5df2\u7ecf\u5b89\u88c5\u4e86 PostgreSQL\u3002<\/p>\n
\u66f4\u6539\u5b89\u88c5\u7684PostgreSQL\u7248\u672c<\/h1>\n
\u6839\u636e\u9605\u8bfb\u6587\u6863\u7684\u60c5\u51b5\uff0c\u4f3c\u4e4e\u53ef\u4ee5\u6307\u5b9a\u8981\u5b89\u88c5\u7684PostgreSQL\u7248\u672c\u3002\u5982\u679c\u6307\u5b9a\u4e86\u7248\u672c\uff0c\u5219\u5c06\u4f7f\u7528PostgreSQL\u5b98\u65b9\u7684\u8f6f\u4ef6\u5305\u3002\u8fd9\u8fb9\u7684\u9009\u62e9\u66f4\u597d\uff0c\u6211\u4f1a\u5c1d\u8bd5\u4fee\u6539\u6e05\u5355\u3002<\/p>\n
class<\/span> { 'postgresql::globals':\r\n manage_package_repo => true,\r\n version => '9.5',\r\n}<\/span>\r\n\r\nclass<\/span> {'postgresql::server': \r\n listen_addresses => '*',\r\n postgres_password => 'postgres',\r\n}<\/span>\r\n\r\n<\/code><\/pre>\n\u5c06manage_package_repo\u8bbe\u7f6e\u4e3atrue\uff0c\u5e76\u6307\u5b9a\u8981\u5b89\u88c5\u7684\u7248\u672c\u5373\u53ef\u3002\u5c1d\u8bd5\u5e94\u7528\u8fd9\u4e9b\u8bbe\u7f6e\u3002<\/p>\n
[root@localhost manifests]# puppet apply \/etc\/puppet\/manifests\/site.pp \r\nWarning: Config file \/etc\/puppet\/hiera.yaml not found, using Hiera defaults\r\nWarning: Scope(Concat[\/var\/lib\/pgsql\/9.5\/data\/pg_ident.conf]): The $force parameter to concat is deprecated and has no effect.\r\nNotice: Compiled catalog for localhost in environment production in 0.99 seconds\r\nNotice: \/Stage[main]\/Postgresql::Repo::Yum_postgresql_org\/File[\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG-95]\/ensure: defined content as '{md5}78b5db170d33f80ad5a47863a7476b22'\r\nNotice: \/Stage[main]\/Postgresql::Repo::Yum_postgresql_org\/Yumrepo[yum.postgresql.org]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Install\/Package[postgresql-server]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Initdb\/Exec[postgresql_initdb]\/returns: executed successfully\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/File[systemd-override]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Postgresql::Server::Config_entry[data_directory]\/Postgresql_conf[data_directory]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Concat[\/var\/lib\/pgsql\/9.5\/data\/pg_ident.conf]\/File[\/var\/lib\/pgsql\/9.5\/data\/pg_ident.conf]\/content: content changed '{md5}f11c8332d3f444148c0b8ee83ec5fc6d' to '{md5}9300ac105fe777787ac9e793b8df8d25'\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Concat[\/var\/lib\/pgsql\/9.5\/data\/pg_ident.conf]\/File[\/var\/lib\/pgsql\/9.5\/data\/pg_ident.conf]\/mode: mode changed '0600' to '0640'\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Exec[restart-systemd]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Postgresql::Server::Config_entry[listen_addresses]\/Postgresql_conf[listen_addresses]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Postgresql::Server::Config_entry[port]\/Postgresql_conf[port]\/ensure: created\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Concat[\/var\/lib\/pgsql\/9.5\/data\/pg_hba.conf]\/File[\/var\/lib\/pgsql\/9.5\/data\/pg_hba.conf]\/content: content changed '{md5}16401f4bb2f7a0cbeac3ecb5133e2904' to '{md5}c31ee6f98ede22591533e8056938c902'\r\nNotice: \/Stage[main]\/Postgresql::Server::Config\/Concat[\/var\/lib\/pgsql\/9.5\/data\/pg_hba.conf]\/File[\/var\/lib\/pgsql\/9.5\/data\/pg_hba.conf]\/mode: mode changed '0600' to '0640'\r\nNotice: \/Stage[main]\/Postgresql::Server::Service\/Anchor[postgresql::server::service::begin]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Postgresql::Server::Service\/Service[postgresqld]\/ensure: ensure changed 'stopped' to 'running'\r\nNotice: \/Stage[main]\/Postgresql::Server::Service\/Postgresql::Validate_db_connection[validate_service_is_running]\/Exec[validate postgres connection for @:5432\/postgres]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Postgresql::Server::Service\/Anchor[postgresql::server::service::end]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Postgresql::Server::Reload\/Exec[postgresql_reload]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Postgresql::Server::Passwd\/Exec[set_postgres_postgrespw]\/returns: ALTER ROLE\r\nNotice: \/Stage[main]\/Postgresql::Server::Passwd\/Exec[set_postgres_postgrespw]\/returns: executed successfully\r\nNotice: Finished catalog run in 51.49 seconds\r\n[root@localhost manifests]# pgrep -a postgres\r\n30567 \/usr\/pgsql-9.5\/bin\/postgres -D \/var\/lib\/pgsql\/9.5\/data\r\n30568 postgres: logger process \r\n30570 postgres: checkpointer process \r\n30571 postgres: writer process \r\n30572 postgres: wal writer process \r\n30573 postgres: autovacuum launcher process \r\n30574 postgres: stats collector process \r\n[root@localhost manifests]# rpm -qa | grep postgres\r\npostgresql95-server-9.5.3-2PGDG.rhel7.x86_64\r\npostgresql95-9.5.3-2PGDG.rhel7.x86_64\r\npostgresql95-libs-9.5.3-2PGDG.rhel7.x86_64\r\n<\/code><\/pre>\n\u597d\u7684\u3002<\/p>\n
\u5c1d\u8bd5\u521b\u5efa\u6570\u636e\u5e93\u548c\u7528\u6237<\/h1>\n
\u56e0\u4e3a\u6709\u529f\u80fd\uff0c\u6240\u4ee5\u6211\u51b3\u5b9a\u8bd5\u4e00\u8bd5\u3002<\/p>\n
class<\/span> { 'postgresql::globals':\r\n manage_package_repo => true,\r\n version => '9.5',\r\n}<\/span>\r\n\r\nclass<\/span> {'postgresql::server': \r\n listen_addresses => '*',\r\n postgres_password => 'postgres',\r\n}<\/span>\r\n\r\npostgresql<\/span>::<\/span>server<\/span>::<\/span>db<\/span> { 'test': \r\n user => 'testuser',\r\n password => 'password',\r\n grant => 'all',\r\n require => Class['postgresql::server'],\r\n}<\/span>\r\n\r\n<\/code><\/pre>\nPostgreSQL\u7684\u670d\u52a1\u5668\u6570\u636e\u5e93\u4e0d\u662f\u4e00\u4e2a\u7c7b\uff0c\u6709\u70b9\u5947\u602a\u3002\uff08\u867d\u7136\u6ca1\u6709\u8ba4\u771f\u5730\u7ed3\u6784\u5316\u6e05\u5355\uff0c\u8fd9\u4e5f\u662f\u6211\u7684\u9519\uff09<\/p>\n
[root@localhost manifests]# puppet apply \/etc\/puppet\/manifests\/site.pp \r\nWarning: Config file \/etc\/puppet\/hiera.yaml not found, using Hiera defaults\r\nWarning: Scope(Concat[\/var\/lib\/pgsql\/9.5\/data\/pg_ident.conf]): The $force parameter to concat is deprecated and has no effect.\r\nNotice: Compiled catalog for localhost in environment production in 1.16 seconds\r\nNotice: \/Stage[main]\/Postgresql::Server::Service\/Service[postgresqld]\/ensure: ensure changed 'stopped' to 'running'\r\nNotice: \/Stage[main]\/Main\/Postgresql::Server::Db[test]\/Postgresql::Server::Role[testuser]\/Postgresql_psql[CREATE ROLE testuser ENCRYPTED PASSWORD ****]\/command: command changed 'notrun' to 'CREATE ROLE \"testuser\" ENCRYPTED PASSWORD '$NEWPGPASSWD' LOGIN NOCREATEROLE NOCREATEDB NOSUPERUSER CONNECTION LIMIT -1'\r\nNotice: \/Stage[main]\/Main\/Postgresql::Server::Db[test]\/Postgresql::Server::Database[test]\/Postgresql_psql[Create db 'test']\/command: command changed 'notrun' to 'CREATE DATABASE \"test\" WITH OWNER=\"postgres\" TEMPLATE=\"template0\" '\r\nNotice: \/Stage[main]\/Main\/Postgresql::Server::Db[test]\/Postgresql::Server::Database[test]\/Postgresql_psql[REVOKE CONNECT ON DATABASE \"test\" FROM public]: Triggered 'refresh' from 1 events\r\nNotice: \/Stage[main]\/Main\/Postgresql::Server::Db[test]\/Postgresql::Server::Database_grant[GRANT testuser - all - test]\/Postgresql::Server::Grant[database:GRANT testuser - all - test]\/Postgresql_psql[grant:database:GRANT testuser - all - test]\/command: command changed 'notrun' to 'GRANT ALL ON DATABASE \"test\" TO\r\n \"testuser\"'\r\nNotice: Finished catalog run in 1.96 seconds\r\n[root@localhost manifests]# pgrep -a postgres\r\n31428 \/usr\/pgsql-9.5\/bin\/postgres -D \/var\/lib\/pgsql\/9.5\/data\r\n31430 postgres: logger process \r\n31432 postgres: checkpointer process \r\n31433 postgres: writer process \r\n31434 postgres: wal writer process \r\n31435 postgres: autovacuum launcher process \r\n31436 postgres: stats collector process \r\n[root@localhost manifests]# sudo -u postgres psql -l\r\n \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\r\n \u540d\u524d | \u6240\u6709\u8005 | \u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0 | \u7167\u5408\u9806\u5e8f | Ctype(\u5909\u63db\u6f14\u7b97\u5b50) | \u30a2\u30af\u30bb\u30b9\u6a29 \r\n-----------+----------+------------------+-------------+-------------------+-----------------------\r\n postgres | postgres | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 | \r\n template0 | postgres | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 | =c\/postgres +\r\n | | | | | postgres=CTc\/postgres\r\n template1 | postgres | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 | =c\/postgres +\r\n | | | | | postgres=CTc\/postgres\r\n test | postgres | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 | =T\/postgres +\r\n | | | | | postgres=CTc\/postgres+\r\n | | | | | testuser=CTc\/postgres\r\n(4 \u884c)\r\n\r\n[postgres@localhost ~]$ psql -h localhost -Utestuser -d test\r\n\u30e6\u30fc\u30b6 testuser \u306e\u30d1\u30b9\u30ef\u30fc\u30c9: \r\npsql (9.5.3)\r\n\"help\" \u3067\u30d8\u30eb\u30d7\u3092\u8868\u793a\u3057\u307e\u3059.\r\n\r\nlocalhost 31589 test=> \\d\r\n\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u304c\u3042\u308a\u307e\u305b\u3093\u3002\r\n\r\n<\/code><\/pre>\n\u55ef\uff0c\u6211\u89c9\u5f97\u8fd9\u4e2a\u5730\u65b9\u81ea\u5df1\u5904\u7406\u4f1a\u66f4\u5bb9\u6613\u63a7\u5236\u3002<\/p>\n
\u7ed3\u675f\uff01<\/p>\n
\u8bf7\u67e5\u9605<\/h1>\n\n- \n
How To Install Puppet In Standalone Mode on CentOS 7<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
Puppetlabs-Postgresql: A Puppet Enterprise Supported Module<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
puppetlabs-postgresql\u30e2\u30b8\u30e5\u30fc\u30eb\u306fDB\u5185\u306e\u7ba1\u7406\u307e\u3067\u3067\u304d\u308b<\/ul>\n","protected":false},"excerpt":{"rendered":"\u7531\u4e8e\u67d0\u79cd\u539f\u56e0\uff0c\u6211\u6b63\u5728\u5bfb\u627e\u4f7f\u7528Puppet\u5b89\u88c5PostgreSQL\u7684\u65b9\u6cd5\uff0c\u6211\u53d1\u73b0PuppetLabs\u63d0\u4f9b\u7684\u6a21\u5757\u4f3c […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41729","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n
\u5982\u4f55\u5728Puppet\u4e2d\u5b89\u88c5PostgreSQL - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5982\u4f55\u5728puppet\u4e2d\u5b89\u88c5postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5982\u4f55\u5728Puppet\u4e2d\u5b89\u88c5PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"\u7531\u4e8e\u67d0\u79cd\u539f\u56e0\uff0c\u6211\u6b63\u5728\u5bfb\u627e\u4f7f\u7528Puppet\u5b89\u88c5PostgreSQL\u7684\u65b9\u6cd5\uff0c\u6211\u53d1\u73b0PuppetLabs\u63d0\u4f9b\u7684\u6a21\u5757\u4f3c […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5982\u4f55\u5728puppet\u4e2d\u5b89\u88c5postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-16T06:27:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T01:40:36+00:00\" \/>\n<meta name=\"author\" content=\"\u65b0, \u97f5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u65b0, \u97f5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/\",\"name\":\"\u5982\u4f55\u5728Puppet\u4e2d\u5b89\u88c5PostgreSQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-01-16T06:27:05+00:00\",\"dateModified\":\"2024-04-29T01:40:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5982\u4f55\u5728Puppet\u4e2d\u5b89\u88c5PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\",\"name\":\"\u65b0, \u97f5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"caption\":\"\u65b0, \u97f5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5982\u4f55\u5728Puppet\u4e2d\u5b89\u88c5PostgreSQL - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5982\u4f55\u5728puppet\u4e2d\u5b89\u88c5postgresql\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5982\u4f55\u5728Puppet\u4e2d\u5b89\u88c5PostgreSQL","og_description":"\u7531\u4e8e\u67d0\u79cd\u539f\u56e0\uff0c\u6211\u6b63\u5728\u5bfb\u627e\u4f7f\u7528Puppet\u5b89\u88c5PostgreSQL\u7684\u65b9\u6cd5\uff0c\u6211\u53d1\u73b0PuppetLabs\u63d0\u4f9b\u7684\u6a21\u5757\u4f3c […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5982\u4f55\u5728puppet\u4e2d\u5b89\u88c5postgresql\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-01-16T06:27:05+00:00","article_modified_time":"2024-04-29T01:40:36+00:00","author":"\u65b0, \u97f5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u65b0, \u97f5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"9 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/","name":"\u5982\u4f55\u5728Puppet\u4e2d\u5b89\u88c5PostgreSQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-01-16T06:27:05+00:00","dateModified":"2024-04-29T01:40:36+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5982\u4f55\u5728Puppet\u4e2d\u5b89\u88c5PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9","name":"\u65b0, \u97f5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","caption":"\u65b0, \u97f5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e5%9c%a8puppet%e4%b8%ad%e5%ae%89%e8%a3%85postgresql\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41729"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41729\/revisions"}],"predecessor-version":[{"id":84501,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41729\/revisions\/84501"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}