Missing listen_port in k8s service

[phvalguima]

Currently, pgbouncer-k8s does not expose the listen_port in k8s service. It is missing something similar to mysql-router-k8s logic to patch k8s service post creation.

I would also recommend to check issue: canonical/mysql-router-k8s-operator#137

As a workaround, it is possible to patch this service manually with:

$ cat <<EOF | kubectl apply -f -
apiVersion: v1                                                
kind: Service                                                 
metadata:                                                     
  name: SERVICE_NAME                                 
  namespace: NAMESPACE                                             
spec:                                                         
  type: TYPE                                          
  selector:                                                   
    app: pgbouncer-k8s                                        
  ports:                                                      
  - name: pgbouncer                                           
    targetPort: 6432                                          
    port: 6432                                                
    protocol: TCP                                                                                                   
  - name: placeholder                                         
    port: 65535                                               
    protocol: TCP                                             
    targetPort: 65535                                         
  selector:                                                   
    app.kubernetes.io/name: pgbouncer-k8s                     
EOF                                                           

[github-actions]

https://warthogs.atlassian.net/browse/DPE-2565

[dragomirp]

Should be fixed on edge (rev. 77)