Skip to main content

Connect with pgAdmin

Connect to an Aiven for AlloyDB Omni database using pgAdmin, which is a PostgreSQL® client useful for managing and querying databases.

Prerequisites​

  • Aiven for AlloyDB Omni service running

  • Connection details for your service available in the Aiven Console > the service's Overview page > Connection information:

    • Database name
    • Host
    • Port
    • User
    • Password

  • pgAdmin installed on your computer

Connect to a service​

  1. Open pgAdmin, go to a server group, and select Register to add a server connection.
  2. In the General tab, give the connection a name, for example MyDatabase.
  3. In the Connection tab, set the connection parameters using the values available in the Aiven Console > the service's Overview page > Connection information.
  4. In the Parameters tab, set SSL mode to require.
  5. Click Save.

The connection to your Aiven for AlloyDB Omni service should now be opened, with the pgAdmin Dashboard page showing activity metrics on your database.