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

Managing postgresql::server::role fails when using non-default port #1554

Open
david-barbion opened this issue Nov 21, 2023 · 0 comments
Open

Comments

@david-barbion
Copy link

Describe the Bug

Before #1498, only one configuration key was needed to manage both postgresql::server and postgresql::server::role: postgresql::server::port.

Since the PR, if only the first key is set, Puppet will fail to create the role claiming it can't connect to port 5432.
We are now forced to set 2 configuration keys when we want to start postgresql server on a custom TCP port:

---
postgresql::server::port: 5433
postgresql::globals::default_connect_settings:
  "PGPORT": "5433"

Expected Behavior

One key to manage tcp port for both server and managed resources (role, extension, ...).

Steps to Reproduce

Steps to reproduce the behavior:

  1. Set postgresql::server with a custom port (eg 5433)
  2. Set postgresql::server::role
  3. Do a puppet run and see postgresql::server::role failing

Environment

  • puppetlabs-postgresql 10.0.2
  • Platform - RHEL9/Postgresql 16
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants