How to find a customer's Postgres connection credentials

Surface a customer's hostname, database name, username, and password from the admin tab when they open a support ticket asking for connection details.

Last updated 20 days ago

How to find a customer's Postgres connection credentials

When you'd do this

A customer support ticket comes in: "What was my database password again?" or "What's the connection string for my Postgres instance?" You need to look up the customer's connection details quickly, without asking them to reset.

Where to find them

  1. Open the ImpulseDB Postgres admin tab. Addons > ImpulseDB Postgres.

  2. Find the customer's service. Use the Customers tab and search by client name, email, or service ID. Click through to the service row.

  3. Open the connection details panel. The service detail page has a Connection card with:

    • Hostname (the shared server hostname for shared plans, e.g. shared-us-1.example.com, or the dedicated hostname for dedicated plans).

    • Port (5432 unless you customized it).

    • Database name (auto-derived as impulse_{service_id}).

    • Username (same convention).

    • Password — click Reveal to display it.

    The password is stored encrypted using ImpulseCore's secret storage. The reveal action is audit-logged with your admin ID, the service ID, and a timestamp.

If the customer says credentials were leaked

Don't reveal — rotate. The Connection card has a Reset Password action that:

  • Generates a new password.

  • Updates the Postgres role with ALTER USER ... PASSWORD ... over the admin connection.

  • Updates the encrypted secret.

  • Audit-logs the rotation.

The customer's client-area service page picks up the new password on their next reload. Send them the client-area URL rather than emailing the new password directly.

SQL spot-check if the admin tab is unavailable

If the addon UI is down (license issue, maintenance), the connection metadata lives in the module tables. The encrypted password sits in ImpulseCore's secret storage, so you can't decrypt it from SQL alone — but you can confirm the instance exists and pull the hostname / DB name pair:

SELECT service_id, hostname, database_name, username, server_id, status FROM mod_impulsepostgres_instances WHERE service_id = <whmcs_service_id>;

For the password itself, wait for the admin tab to come back up — there's no offline path that doesn't also expose every other module's secrets.

What customers see on their side

Customers don't need you for this in most cases. The client-area service page has a Connection card with the same hostname / database / username fields and a Reveal Password button. Direct them there before pulling credentials yourself — it's faster for them and doesn't show up in your audit log.

Related