Jira (PDB-2259) PostgreSQL issue : database is empty after puppetdb installation

Mok (JIRA) Thu, 17 Dec 2015 07:33:17 -0800

Title: Message Title

Mok commented on

PDB-2259

For this time, I have found a temporary workaround :

/etc/init.d/puppetdb stop

sudo -u puppetdb psql

CREATE TABLE certnames (name TEXT PRIMARY KEY);

CREATE TABLE catalogs (hash VARCHAR(40) NOT NULL PRIMARY KEY, api_version INT NOT NULL, catalog_version TEXT NOT NULL);

CREATE TABLE certname_catalogs (certname TEXT UNIQUE REFERENCES certnames(name) ON DELETE CASCADE, catalog VARCHAR(40) UNIQUE REFERENCES catalogs(hash)  ON DELETE CASCADE, PRIMARY KEY (certname, catalog));

CREATE TABLE tags (catalog VARCHAR(40) REFERENCES catalogs(hash) ON DELETE CASCADE, name TEXT NOT NULL, PRIMARY KEY (catalog, name));

CREATE TABLE classes (catalog VARCHAR(40) REFERENCES catalogs(hash) ON DELETE CASCADE, name TEXT NOT NULL, PRIMARY KEY (catalog, name));

CREATE TABLE catalog_resources (catalog VARCHAR(40) REFERENCES catalogs(hash) ON DELETE CASCADE, resource VARCHAR(40), type TEXT NOT NULL, title TEXT NOT NULL, tags TEXT ARRAY[65535] NOT NULL, exported BOOLEAN NOT NULL, sourcefile TEXT, sourceline INT, PRIMARY KEY (catalog, resource));

CREATE TABLE resource_params (resource VARCHAR(40), name TEXT NOT NULL, value TEXT NOT NULL, PRIMARY KEY (resource, name));

CREATE TABLE edges (catalog VARCHAR(40) REFERENCES catalogs(hash) ON DELETE CASCADE, source VARCHAR(40), target VARCHAR(40), type TEXT NOT NULL, PRIMARY KEY (catalog, source, target, type));

CREATE TABLE schema_migrations (version INT NOT NULL PRIMARY KEY, time TIMESTAMP NOT NULL);

CREATE INDEX idx_catalogs_hash ON catalogs(hash);

CREATE INDEX idx_certname_catalogs_certname ON certname_catalogs(certname);

CREATE TABLE certname_facts (certname TEXT REFERENCES certnames(name) ON DELETE CASCADE, fact TEXT NOT NULL, value TEXT NOT NULL, PRIMARY KEY (certname, fact));

CREATE INDEX idx_resources_params_resource ON resource_params(resource);

CREATE INDEX idx_resources_params_name ON resource_params(name);

CREATE INDEX idx_certname_facts_certname ON certname_facts(certname);

CREATE INDEX idx_certname_facts_fact ON certname_facts(fact);

CREATE INDEX idx_catalog_resources_type ON catalog_resources(type);

CREATE INDEX idx_catalog_resources_resource ON catalog_resources(resource);

CREATE INDEX idx_catalog_resources_tags ON catalog_resources(tags);

INSERT INTO SCHEMA_MIGRATIONS VALUES(1,'2015-09-27 12:53:56.277000');

/etc/init.d/puppetdb start

Add Comment

This message was sent by Atlassian JIRA

--
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.

Jira (PDB-2259) PostgreSQL issue : database is empty after puppetdb installation

Reply via email to