14.6 Connecting to PostgreSQL Database Through Command Line

Sentinel Rapid Deployment has a command line option to connect to the PostgreSQL database:

  1. Connect to the Sentinel Rapid Deployment server as the user who owns the Sentinel Rapid Deployment installation files.

  2. Change to the Rapid Deployment bin directory.

    cd <RD_install_home>/bin

  3. Run the setenv.sh script to set the environment variables.

    . setenv.sh

  4. Change to the PostgreSQL bin directory.

    cd <RD_install_home>/3rdparty/postgresq/bin

  5. Run psql to connect to the PostgreSQL database.

    ./psql SIEM -U dbauser