Connecting to the PostgreSQL database

You can connect to the PostgreSQL database directly by using psql, an interactive terminal program. After you make the connection, you can use SQL statements to extract or query the data without using a business intelligence tool.
    Note:
  • You do not have to follow this procedure if you use Data Transmitters.

To verify that the PostgreSQL database is running, try to connect to it. If you get the psql command prompt, the database is running.

To connect to the PostgreSQL database:
  1. Log in to the primary computer and open a command line.
  2. Change directories to the correct option for your system.
    • On Linux:
      • /aiw/aiw1/bin/postgresql/Linux/pgsql/bin or
      • /usr/pgsql-14/bin/
    • On Windows:
      • C:\aiw\aiw1\bin\postgresql\Windows\pgsql\bin or
      • <RPD Install Directory>\PostgreSQL\bin\
  3. Enter this command: ./psql databaseusername

    Replace database with the name of the database that you specified in Administration ⇒ Reports ⇒ Database Settings. The default is history.

    Replace username with the user name that you specified in Administration ⇒ Reports ⇒ Database Settings. The default is rpdreports.

  4. If prompted, enter the password that you specified in Administration ⇒ Reports ⇒ Database Settings.

    The psql command prompt database=# is displayed.

    If you specified history in the command, the command prompt is history=#.

    You now are connected to the PostgreSQL database.

  5. To access the data, run SQL statements.
  6. To exit psql, enter: \q

Related information:

Supplied Tableau workbook
PostgreSQL database connection issues
Useful PostgreSQL commands
Parent topic: Working with data in the PostgreSQL database