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

(MODULES-11251) Add support for backup provider "pg_dump"

Open fraenki opened this issue 3 years ago • 17 comments

This adds support for backup "providers" to puppetlabs/postgresql. The feature is heavily inspired by a similar feature in puppetlabs/mysql.

See Puppet ticket for full details: https://tickets.puppetlabs.com/browse/MODULES-11251

fraenki avatar Jan 11 '22 13:01 fraenki

CLA assistant check
All committers have signed the CLA.

CLAassistant avatar Jan 11 '22 13:01 CLAassistant

postgresql::backup::pg_dump is a class

that may have no external impact to Forge modules.

postgresql::params is a class

that may have no external impact to Forge modules.

postgresql::server is a class

that may have no external impact to Forge modules.

This module is declared in 70 of 578 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.

Hi, I like the idea and added some inline comments. I want to mention that Vox Pupuli also has a module to do database dumps: https://forge.puppet.com/modules/puppet/dbbackup#table-of-contents

bastelfreak avatar Jan 11 '22 13:01 bastelfreak

Hi, I like the idea and added some inline comments. I want to mention that Vox Pupuli also has a module to do database dumps: https://forge.puppet.com/modules/puppet/dbbackup#table-of-contents

Thanks for the review. Actually I've already had a look at puppet/dbbackup, but I really like the integrated approach of puppetlabs/mysql's backup feature, and I cannot use systemd, which lead to the creation of this PR. :)

fraenki avatar Jan 11 '22 15:01 fraenki

I've added some tests with the latest commit.

fraenki avatar Jan 12 '22 10:01 fraenki

This PR has been marked as stale because it has been open for a while and has had no recent activity. If this PR is still important to you please drop a comment below and we will add this to our backlog to complete. Otherwise, it will be closed in 7 days.

github-actions[bot] avatar May 07 '22 02:05 github-actions[bot]

postgresql::backup::pg_dump is a class

that may have no external impact to Forge modules.

postgresql::params is a class

Breaking changes to this file WILL impact these 2 modules (exact match):
Breaking changes to this file MAY impact these 3 modules (near match):

postgresql::server is a class

Breaking changes to this file WILL impact these 38 modules (exact match):
Breaking changes to this file MAY impact these 16 modules (near match):

This module is declared in 70 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.

dear puppet, please do not autoclose PR that are only stale because nine of you reviewed it...

@fraenki sadly this now needs a rebase, could you please do that?

bastelfreak avatar May 14 '22 05:05 bastelfreak

Hello! 👋

This pull request has been open for a while and has had no recent activity. We've labelled it with attention-needed so that we can get a clear view of which PRs need our attention.

If you are waiting on a response from us we will try and address your comments on a future Community Day.

Alternatively, if it is no longer relevant to you please close the PR with a comment.

Please note that if a pull request receives no update for 7 after it has been labelled, it will be closed. We are always happy to re-open pull request if they have been closed in error.

github-actions[bot] avatar Jul 14 '22 02:07 github-actions[bot]

PR needs a review, I'll rebase ASAP...

fraenki avatar Jul 19 '22 09:07 fraenki

hey @fraenki ! Appreciated!

chelnak avatar Jul 19 '22 10:07 chelnak

@chelnak Rebased. Ready for review :)

fraenki avatar Jul 26 '22 10:07 fraenki

Hey @fraenki ! I'm on PTO this week so pinging @pmcmaw and @david22swan for assistance!

chelnak avatar Jul 26 '22 10:07 chelnak

@fraenki Look's like your getting a few spec test failures.

david22swan avatar Jul 26 '22 10:07 david22swan

I've force-pushed a fix, please re-run the spec tests.

fraenki avatar Aug 01 '22 09:08 fraenki

Since I'm unable to run the tests locally, I need to request a re-run of the spec tests again... :-/

fraenki avatar Aug 01 '22 11:08 fraenki

The spec tests are finally passing. :tada: (However, some tests seem to timeout, which is also the case for the nightly tests.)

fraenki avatar Aug 01 '22 12:08 fraenki

@chelnak @david22swan What do you think? Can this PR be merged? :)

fraenki avatar Aug 17 '22 13:08 fraenki