Jira (PDB-4771) Setup PDB instance on n1/n2 with test data

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data Change By: Zachary Kent Summary: Setup pg PDB instance on n1/n2 with test data Add Comment

This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935)

[Zachary Kent (Jira)]

Zachary Kent commented on PDB-4771

Re: Setup PDB instance on n1/n2 with test data For this ticket we'll want to create a pe-pdbbox sandbox on n1/n2 that's loaded with the slv-data. You should be able to ssh into the n1/n2 servers using <puppet-username>@pdb-n1-prod.ops.puppetlabs.net If you're unable to log in ... Once this data is loaded we'll need to make sure that we routinely bump the timestamps so PDB gc doesn't delete the loaded data on start up. We should adapt the updatetime.sql script in the slv link above so we can run it on demand. We'll also want to VACUUM FULL the database after the timestamps are updated to eliminate any dead rows caused by the update. The slv pg_dump is from a PE install so we'll need to pull out only the pe-puppetdb database. We don't need to load the data for the other PE services.

Add Comment

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-4771

Setup PDB instance on n1/n2 with test data

Change By: Zachary Kent Acceptance Criteria: * A bash helper script which loads only the pe-puppetdb slv data into a pe-pdbbox sandbox * This helper script should also have the ability to run the updatetime.sql script on the data and follow that modification with a VACUUM FULL of the database

Add Comment

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Zachary Kent Acceptance Criteria:

* A bash helper script which loads only the pe-puppetdb slv data into a pe-pdbbox sandbox * This helper script should also have the ability to run the updatetime.sql script on the data and follow that modification with a VACUUM FULL of the database

* Basic dev docs on how to run the helper script * A pe-pdbbox sandbox loaded with the slv data with pdb turned off

Add Comment

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Zachary Kent Team: PuppetDB HA

Add Comment

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Zachary Kent Labels: tsr-pdb-backlog

Add Comment

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Zachary Kent Acceptance Criteria:

* A bash helper script which loads only the pe-puppetdb slv data into a pe-pdbbox sandbox * This helper script should also have the ability to run the updatetime.sql script on the data and follow that modification with a VACUUM FULL of the database * Basic dev docs on how to run the helper script * A pe-pdbbox sandbox loaded with the slv data with pdb turned off

* The helper script should live somewhere in the pdbext repo

Add Comment

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Zachary Kent Acceptance Criteria: * A bash /python helper script which loads only the pe-puppetdb slv data into a pe-pdbbox sandbox

* This helper script should also have the ability to run the updatetime.sql script on the data and follow that modification with a VACUUM FULL of the database * Basic dev docs on how to run the helper script * A pe-pdbbox sandbox loaded with the slv data with pdb turned off * The helper script should live somewhere in the pdbext repo

Add Comment

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Zachary Kent Acceptance Criteria: * A bash/python helper script which loads only the pe-puppetdb slv data into a pe-pdbbox sandbox

* This helper script should also have the ability to run the updatetime.sql script on the data and follow that modification with a VACUUM FULL of the database * Basic dev docs on how to run the helper script * A pe-pdbbox sandbox loaded with the slv data with pdb turned off * The helper script should live somewhere in the pdbext repo

Add Comment

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Zachary Kent Story Points: 3

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Bogdan Irimie Team: HA Ghost

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Bogdan Irimie Sprint: ghost-7.04.2021

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Bogdan Irimie Story Points: 3

Add Comment

[Florin Dragos (Jira)]

Florin Dragos assigned an issue to Florin Dragos

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Florin Dragos Assignee: Florin Dragos

Add Comment

[Rob Browning (Jira)]

Rob Browning updated an issue

PuppetDB / PDB-4771 Setup PDB instance on n1/n2 with test data

Change By: Rob Browning Acceptance Criteria: * A helper script which loads only the pe-puppetdb slv data into a pe-pdbbox sandbox

* This helper script should also have the ability to run the updatetime.sql script on the data and follow that modification with a VACUUM FULL of the database * Basic dev docs on how to run the helper script * A pe-pdbbox sandbox loaded with the slv data with pdb turned off

* The helper script should live somewhere in the pdbext pdb repo

Add Comment