技术支持
Support
Server for PostgreSQL
支持 macOS 12 及以上版本(Apple Silicon)· 内置 PostgreSQL 17.x (PostgreSQL License)
Compatible with macOS 12 and later (Apple Silicon) · Bundled with PostgreSQL 17.x (PostgreSQL License)
感谢您使用 Server for PostgreSQL。本页面提供功能说明、常见问题解答以及联系方式。
功能介绍
- 启动 / 停止 / 重启 — 一键控制 PostgreSQL 服务
- 端口自动避让 — 优先使用配置端口;被占用时自动获取系统随机空闲端口
- 仅本地访问 — 限制仅本机访问,增强安全性
- 开机自启 — 登录系统时自动启动应用
- 一键复制 URI — 快速复制 PostgreSQL 连接字符串
- 工作目录访问 — 一键打开数据、日志与配置目录
- 状态栏指示 — 图标透明度直观显示服务状态
常见问题
如何启动 PostgreSQL 服务?
点击菜单栏中的应用图标,选择 Start 即可启动服务。首次启动会自动初始化数据目录与配置。
端口被占用了怎么办?
应用会自动检测端口占用情况。如果默认端口 5432 被占用,会从 5433 开始顺延到下一个可用端口。
如何连接 PostgreSQL?
服务运行时,点击菜单中的 Port: XXXXX 即可复制连接 URI,格式为 postgresql://127.0.0.1:XXXXX。
Local Access Only 是什么?
开启后仅接受来自本机(127.0.0.1)的连接。关闭后可从局域网内其他设备访问。
如何查看数据和日志?
点击菜单中的 Working Directory 打开工作目录,其中包含:数据目录、logs/(日志)、配置文件。
服务启动失败怎么办?
请检查:端口是否被占用、工作目录是否有写入权限、查看日志文件。如仍无法解决,请联系我们。
如何卸载?
将应用拖入废纸篓即可。如需删除所有数据,请手动删除 ~/Library/Application Support/Server for PostgreSQL/ 目录。
联系我们
开源许可证
Thank you for using Server for PostgreSQL. This page covers features, common questions, and how to reach us.
Features
- Start / Stop / Restart — One-click control of PostgreSQL
- Port Auto‑Avoidance — Prefers the configured port; automatically allocates a random free port if occupied
- Local Access Only — Restrict to localhost for added security
- Launch at Login — Auto-starts when you log in to your system
- Copy URI — Quickly copy the PostgreSQL connection string
- Working Directory — Open data, logs, and config folders in one click
- Status Indicator — Icon opacity reflects running state
FAQ
How do I start PostgreSQL?
Click the app icon in the menu bar and choose Start. The first launch auto-initialises the data directory and config.
What if the port is taken?
The app auto-detects port usage. If 5432 is occupied, it falls back to 5433 and continues upward.
How do I connect to PostgreSQL?
While the service is running, click Port: XXXXX in the menu to copy the URI postgresql://127.0.0.1:XXXXX.
What does Local Access Only do?
When enabled, only connections from localhost (127.0.0.1) are accepted. Disable it to allow LAN access.
How do I view data and logs?
Click Working Directory in the menu. It contains the data directory, logs/ (logs), and config files.
The service won't start?
Check: whether the port is in use, whether the working directory is writable, and the log files. Contact us if it persists.
How do I uninstall?
Drag the app to the Trash. To remove all data, manually delete ~/Library/Application Support/Server for PostgreSQL/.
Contact
Open Source License
This app bundles PostgreSQL 17.x, licensed under the PostgreSQL License (BSD-like). See postgresql.org/about/licence.
This is not an official PostgreSQL product; it is a third-party management tool for PostgreSQL.