PostgreSQL Accounts

PostgreSQL accounts let you manage access to your PostgreSQL databases. Users connect through Web Access (a browser-based interface) or CLI (a local proxy), and every session can be recorded.

Creating an Account

Start adding an account

Go to Privileged Access Management → Accounts and click Add Account.

Select a folder and template

Choose which folder to add the account to, then select a PostgreSQL template (e.g., the default postgres or a custom one).

Enter connection details

Field	Description
Name	A descriptive name (e.g., `orders-db-readonly`)
Host	Database hostname or IP
Port	PostgreSQL port (default: 5432)
Database	Database name
SSL Enabled	Enable SSL for the connection
Reject Unauthorized	Reject connections with invalid certificates (only if SSL enabled)
SSL Certificate	Custom CA certificate (only if SSL enabled)

Enter credentials

Field	Description
Username	PostgreSQL username
Password	PostgreSQL password

Save

Click Create.

Connecting

Web Access
CLI

Web Access provides a browser-based interface with two tools:

Data Explorer — browse tables, view data, filter and sort, edit rows, export to CSV/JSON
SQL Editor — write and run SQL queries, use transactions

To connect:

Go to Privileged Access Management → My Access
Find the account and click Launch → Connect in Browser

The CLI starts a local proxy that you connect to with your preferred PostgreSQL client.

infisical pam access backend-team/orders-db

The command outputs the local port to connect to. Then use your PostgreSQL client:

psql "postgresql://localhost:<port>/orders"

No password needed since the proxy handles authentication.Flags:

--port <port> — use a specific local port (otherwise one is assigned automatically)
--reason <reason> — provide an access reason (if required by template)

Next Steps

SSH Accounts

Add SSH server accounts.

Sessions

View and manage sessions.

Overview MySQL

⌘I

​Creating an Account

​Connecting

​Next Steps

SSH Accounts

Sessions

Creating an Account

Connecting

Next Steps