puppetlabs-puppetdb icon indicating copy to clipboard operation
puppetlabs-puppetdb copied to clipboard

set encoding when creating the DB

Open elfranne opened this issue 1 year ago • 3 comments

According to the docs you should specify the encoding when creating the database. The database encoding will be set depending on your locale (I got LATIN1) unless specified.

I am getting some errors is the PuppetDB logs:

ERROR: unsupported Unicode escape sequence Detail: Unicode escape values cannot be used for code point values above 007F when the server encoding is not UTF8.

and filling up few gig of additional log at /opt/puppetlabs/server/data/puppetdb/stockpile/discard

elfranne avatar Oct 17 '22 12:10 elfranne

puppetdb::database::postgresql is a class

that may have no external impact to Forge modules.

This module is declared in 33 of 579 indexed public Puppetfiles.


These results were generated with Rangefinder, a tool that helps predict the downstream impact of breaking changes to elements used in Puppet modules. You can run this on the command line to get a full report.

Exact matches are those that we can positively identify via namespace and the declaring modules' metadata. Non-namespaced items, such as Puppet 3.x functions, will always be reported as near matches only.

CLA assistant check
All committers have signed the CLA.

CLAassistant avatar Oct 17 '22 12:10 CLAassistant

This only applies on newly created puppetdb. If you don t care about the data in the db you can:

sudo service puppetdb stop
sudo -i -u postgres psql
DROP DATABASE puppetdb;

puppet apply manifest/site.pp

elfranne avatar Nov 04 '22 13:11 elfranne