Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add ability to whitelist external IP ranges, or pass HBA rules to CNPG #939

Open
bonesmoses opened this issue Sep 4, 2024 · 0 comments
Open
Labels
enhancement New feature or request

Comments

@bonesmoses
Copy link
Contributor

A user made this request through our support portal.

Essentially, the CoreDB operator should have a syntax that allows it to pass pg_hba rules to CloudNativePG. Perhaps the easiest way to do this would be to handle a list of CIDR+netmask or host strings, eg:

ext_hba_list:
- 155.149.232.44/24
- my_host.mydomain.tld
    user: rep_user
    dbname: replication
    type: cert

And then the CoreDB operator would translate these to appropriate lines in the pg_hba section of the CloudNativePG cluster spec. If no whitelist metadata is supplied, we'd assume all.

This would allow external replication, manual use of pg_basebackup, and other use cases that are not currently possible. This would also require a GUI front-end in the website project to enable user-provisioning, but this would need to exist first.

It is currently possible to specify pg_hba rules directly in the CNPG cluster spec, but these may not persist if the CoreDB operator regenerates the spec.

@bonesmoses bonesmoses added the enhancement New feature or request label Sep 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant