About this Tool 🛠️
A streamlined online service to test PostgreSQL database connectivity. Using native PHP PDO Postgres drivers, it attempts a secure connection to your remote Postgres server, verifying host, port, credentials, and database name.
Benefits of Using This Tool 🌟
- Instant Verification: Quickly confirm database accessibility without launching pgAdmin or psql command line tool.
- Reliable Diagnostics: Returns exact PostgreSQL error codes natively (e.g., role does not exist, database missing).
- Secure Design: Connections are made ephemerally and credentials are never stored.
- Speed Measurement: Tracks the actual latency for the complete TCP connection and authentication handshake.
Why Use This Tool? ✨
- Firewall Testing: Easily check if
pg_hba.confand server firewalls allow remote connections globally. - Configuration Check: Ensure newly created Postgres roles have correct access to the intended databases.
- Cloud Compatibility: Ideal for testing AWS RDS for PostgreSQL, Supabase, Neon, or Heroku Postgres databases.
- Developer Workflow: Quickly validate connection parameters before embedding them into backend applications.
Frequently Asked Questions (FAQs) ❓
Q: What is the default Postgres port?
A: PostgreSQL traditionally uses port 5432 by default.
Q: Why am I getting a networking timeout?
A: Your Postgres server (postgresql.conf) might not be listening on all interfaces (*) or your firewall is silently dropping traffic.
Q: Does this support Supabase or Neon?
A: Yes! Just provide the endpoint host, port, user, password, and database provided in your remote dashboard.
Q: Is this safe for my production database?
A: While highly safe, we strongly recommend creating a read-only role alongside production systems strictly for remote testing purposes.