<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div class="default-style">
<div class="default-style">
I am currently using PGpool-II v4.0.2 and got it working as a proxy for
</div>
<div class="default-style">
legacy software that need to connect to a new PostgreSQL server that
</div>
<div class="default-style">
is located in a Kubernetes cluster.
</div>
<div class="default-style">
</div>
<div class="default-style">
The only problem i got is mapping between a frontend authentication and a
</div>
<div class="default-style">
backend authentication. I can only get the pool_passwd entry to check the
</div>
<div class="default-style">
frontend and also pass that authentication on to the backend.
</div>
<div class="default-style">
</div>
<div class="default-style">
I looked at the code of v4.0.2 and also v4.4.4 and found out there was also
</div>
<div class="default-style">
some work done on this by using a backend set of credentials on the same
</div>
<div class="default-style">
line in the pool_passwd file. As i understand this is what is expected in code:
</div>
<div class="default-style">
</div>
<div class="default-style">
[frontend username]:[frontend password]:[backend username]:[backend password]
</div>
<div class="default-style">
</div>
<div class="default-style">
Which would be great for my application as i would like to have the frontend
</div>
<div class="default-style">
username 'postgres' to be mapped to another backend user called: 'appsuser'
</div>
<div class="default-style">
I tried this but it did not work; pgpool still tries to authenticate with the frontend
</div>
<div class="default-style">
username to the backend.
</div>
<div class="default-style">
</div>
<div class="default-style">
I looked through the code some more but i am beginning to think this feature
</div>
<div class="default-style">
is not yet fully implemented. I could not find a place in the code where the backend
</div>
<div class="default-style">
username is checked and if present used to authenticate with the backend.
</div>
<div class="default-style">
</div>
<div class="default-style">
Does anyone know if the mapping feature is available and if so please tell
</div>
<div class="default-style">
me how i can configure this.
</div>
</div>
</body>
</html>