# How to connect percona postgresql to "navicat"

**URL:** <https://forums.percona.com/t/how-to-connect-percona-postgresql-to-navicat/29587>\
**Category:** Percona Operator for PostgreSQL\
**Created:** [April 7, 2024, 9:30am UTC](https://forums.percona.com/t/how-to-connect-percona-postgresql-to-navicat/29587 "2024-04-07T09:30:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![qishan](https://avatars.discourse-cdn.com/v4/letter/q/8e8cbc/32.png) [@qishan](https://forums.percona.com/u/qishan)\
**Post date:** [April 7, 2024, 9:30am UTC](https://forums.percona.com/t/how-to-connect-percona-postgresql-to-navicat/29587/1 "2024-04-07T09:30:47Z")

</div>

hi,i want connect percona postgresql to “navicat”.how should i do? i have installed percona pgsql on k8s cluster. How do I get the ip and port in the cluster to connect to navicat?

---

<div class="post-metadata">

**Author:** ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)\
**Post date:** [April 8, 2024, 8:45am UTC](https://forums.percona.com/t/how-to-connect-percona-postgresql-to-navicat/29587/2 "2024-04-08T08:45:34Z")

</div>

@qishan I assume you are looking for a connection string to paste into navicat.  
There are two things to consider:

1. Expose the cluster: [Exposing the cluster - Percona Operator for PostgreSQL](https://docs.percona.com/percona-operator-for-postgresql/2.0/expose.html)  
The connection string depends on how you expose it.  
I assume your Navicat instance runs outside of the kubernetes cluster, so you should expose your cluster with a load balancer or node port.

2. Get the connection string:  
You can get the login, password and a connection string from the secret resource. It is well described here: [2 Connect to PostgreSQL - Percona Operator for PostgreSQL](https://docs.percona.com/percona-operator-for-postgresql/2.0/connect.html)

please let me know if you still have questions.
