Export the project list for a Harmony environment on Jitterbit private agents

Introduction

You can use pgAdmin to export a list of projects in an environment associated with a private agent group, as described on this page.

Prerequisites

You will need the default (postgres) PostgreSQL admin user password chosen when installing the private agent. If you forgot this password, see Forgotten private agent PostgreSQL admin user password to connect to the database with the jitterbit PostgreSQL admin user.

Export the project list using pgAdmin

1. Launch the pgAdmin application.

2. If applicable, enter your pgAdmin master password in the prompt:

   

   Important

   The pgAdmin master password is distinct from the passwords used for PostgreSQL database users. It is not used to interact with the database directly.

   When defining a pgAdmin master password, it is recommended that you save it in a separate location for future use.

3. In the left pane, navigate to Servers > PostgreSQL and expand Databases:

   

   Note

   During navigation, you will be prompted for the default (postgres) PostgreSQL admin user password if it was not previously saved. If you forgot this password, see Forgotten private agent PostgreSQL admin user password to connect to the database with the jitterbit PostgreSQL admin user.

4. Right-click the TranDb database and click Query Tool:

   

5. The pgAdmin Query tool opens in a new tab. Under the Query tab, enter SELECT * FROM projectstab;:

   

6. Click the Execute / Refresh button or press the F5 key to execute the query. A list of projects will appear under the Data Output tab.

7. To export the list as a CSV file, click the Save Results to File button or the press F8 key: