【跟我学Puppet】1.4 Puppet 3.7 使用PuppetDB做数据仓库
yum install postgresql-server -ysed -i '/^classname/ s/org.hsqldb.jdbcDriver/org.postgresql.Driver/' /etc/puppetdb/conf.d/database.ini
sed -i '/^subprotocol/ s/hsqldb/postgresql/' /etc/puppetdb/conf.d/database.ini
sed -i '/^subname/ s@= .*@=//localhost:5432/puppetdb@' /etc/puppetdb/conf.d/database.ini
sed -i 's/# username =.*/username = puppetdb/' /etc/puppetdb/conf.d/database.ini
sed -i 's/# password =.*/password = #你的密码#/' /etc/puppetdb/conf.d/database.ini
service postgresql initdb
/etc/init.d/postgresql start
#创建用户，输入密码<就是上面的密码..>..然后创建一个库
sudo -u postgres sh
createuser -DRSP puppetdb
createdb -E UTF8 -O puppetdb puppetdb
exit
#如果使用PostgreSQL 9.3
sudo -u postgres sh
psql puppetdb -c 'create extension pg_trgm'
exit
#更改为允许网络连接使用MD5认证
sed -i '/^local/ s/ident/md5/' /var/lib/pgsql/data/pg_hba.conf
sed -i '/^host/ s/ident/md5/' /var/lib/pgsql/data/pg_hba.conf
psql -h localhost puppetdb puppetdb
service puppetdb restart
页:
[1]