autobase: pgbouncer user doesn't exist error when trying to deploy from command line
Hello @vitabaks,
I’m trying to deploy the cluster with the ansible script, but I keep getting the following error:
`fatal: [172.22.134.241]: FAILED! => {"changed": true, "cmd": ["/usr/lib/postgresql/16/bin/psql", "-p", "5432", "-U", "postgres", "-d", "postgres", "-tAXc", "CREATE FUNCTION user_search(uname TEXT) RETURNS TABLE (usename name, passwd text) AS $$ SELECT usename, passwd FROM pg_shadow WHERE usename=$1; $$ LANGUAGE sql SECURITY DEFINER; REVOKE ALL ON FUNCTION user_search(uname TEXT) FROM public; GRANT EXECUTE ON FUNCTION user_search(uname TEXT) TO pgbouncer"], "delta": "0:00:00.011840", "end": "2024-10-22 13:16:06.143323", "msg": "non-zero return code", "rc": 1, "start": "2024-10-22 13:16:06.131483", "stderr": "ERROR: role \"pgbouncer\" does not exist", "stderr_lines": ["ERROR: role \"pgbouncer\" does not exist"], "stdout": "CREATE FUNCTION\nREVOKE", "stdout_lines": ["CREATE FUNCTION", "REVOKE"]}`
Thanks in advance for your response!
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 22 (12 by maintainers)
I can confirm that at least in my case I was using dedicated etcd servers.
Hi @vitabaks,
Thanks for the heads-up, you diverted my attention to the right direction: According to the comment the password for the user will be generated if not defined explicitly in the yaml: https://github.com/vitabaks/postgresql_cluster/blob/23d021967cd38dd11e84692e07d381d1d90bb381/automation/vars/main.yml#L353 In fact that caused the problem, when setting the password in the yaml for "pgbouncer"user it works OK.