Skip to content

PGAdmin DB Connection and SSH Tunnel

  1. To add a connection, right click on Servers > Choose Register > Server.

    image.png

  2. Enter a meaningful name and deselect the Connect Now slider

    image.png

  3. Navigate to the SSH Tunnel tab and select the slider to Use SSH Tunneling

    • Put in tunnel host provided by EA
    • Leave the tunnel port as 22
    • Username is tunnel-user
    • Choose Identity file as authentication method
    • Click on folder icon and navigate to private key file generated for Github account

    image.png

  4. Navigate back to Connection tab

    • Enter hostname provided by EA
    • Leave port as 5432
    • Enter read_only as username

    image.png

  5. Click Save

    You should now see a server pop up in your server navigation on the left had side.

  6. Double click on the server, when prompted enter read_only password provided to you by EA. You can leave the SSH Tunnel password field blank if you did not password protect your Github account's private key file. If a password was used to generate this file, please enter it in now.

    • You can choose to save the password for the read_only user in this dialog box. But you will need to enter in the password for your key file upon each connection.

    image.png

NOTE: If your StartingBlocks environment is in DistrictSpecific mode, or Multi-tenant mode, all of the databases in the environment will be shown in your explorer. To only see specific ODSs or databases, your connection parameters will need to be updated. Please follow the steps below to configure.

  1. Right click on your server connection and navigate to Properties

    image.png

  2. Navigate to the Advanced tab.

    • In the DB restriction box, enter in the full database names for the databases which access has been granted. e.g. EdFi_Ods_123456 or EdFi_Ods for Shared Instances
    • Click Save and now PGAdmin should only display databases specified in the Advanced tab