What's the Best Way to Manage and Access Multiple Postgresql Instances in K8s?

Posted4 months agoActive4 months ago

xiangyufan723

1 points

2 comments

github.comTechstory

calmneutral

Debate

0/100

PostgresqlKubernetesContainer Orchestration

Key topics

Postgresql

Kubernetes

Container Orchestration

Discussion about managing multiple PostgreSQL instances in Kubernetes.

Snapshot generated from the HN discussion

Discussion Activity

Light discussion

First comment

N/A

Peak period

Day 1

Avg / period

Key moments

01Story posted
Sep 3, 2025 at 3:17 AM EDT
4 months ago
Step 01
02First comment
Sep 3, 2025 at 3:17 AM EDT
0s after posting
Step 02
03Peak activity
1 comments in Day 1
Hottest window of the conversation
Step 03
04Latest activity
Sep 14, 2025 at 11:43 PM EDT
4 months ago
Step 04

Generating AI Summary...

Analyzing up to 500 comments to identify key contributors and discussion patterns

Discussion (2 comments)

Showing 2 comments

xiangyufan723Author

4 months ago

1 reply

I'd like to ask how everyone quickly accesses the many PostgreSQL instances deployed in Kubernetes. If you use development tools like DataGrip, you have to go through a rather complex configuration process. But if you're frequently using these instances, such tools can still be quite convenient.

So, I tried vibe-coding a project p6s that mimics the way k9s works—allowing quick access to PostgreSQL instances via a TUI (terminal user interface). It also comes with some basic built-in queries, such as active connection count and table storage information for databases.

Right now, it’s still quite basic. I’d like to expand it to support more database types—such as MySQL, ClickHouse, and others—directly. I’d really appreciate any suggestions or ideas you might have!

Tostino

4 months ago

When I need to access an instance I do a local port forward for that instance using kubectl and connect to it with pgadmin like any other database. If I need to access another instance, I close that port forward and open another to the instance I want to connect to. If I need multiple at once for some reason I could choose different local ports and have them pre-configured in pgadmin...but I don't generally need that.

View full discussion on Hacker News

ID: 45113100Type: storyLast synced: 11/17/2025, 10:08:25 PM

Want the full context?

Jump to the original sources

Read the primary article or dive into the live Hacker News thread when you're ready.

Open link View on HN