10.0 Connecting to the Embedded PostgreSQL Database

To connect to the embedded PostgreSQL database, based on the existing configurations, set the following environment variables:


  1. The parameter values are available in the zdm.xml file.

    The zdm.xml file is available in the following location:

    • On Windows %ZENWORKS_HOME%\conf\datamodel

    • On Linux / Appliance /etc/opt/novell/zenworks/datamodel

  2. Use the zman dgc commands to get the user name and password. For more information, see ZENworks Command Line Utilities Reference.

On Linux / Appliance Open the terminal and set the following parameters:

  • su zenpostgres

  • LD_LIBRARY_PATH=/opt/novell/zenworks/share/pgsql/lib; export LD_LIBRARY_PATH

  • PATH=$PATH:/opt/novell/zenworks/share/pgsql/bin; export PATH

  • PGPORT=<port_number>; export PGPORT

  • PGUSER=<user_name>; export PGUSER

  • PGDATABASE=<database_name>; export PGDATABASE

  • PGPASSWORD=<password>; export PGPASSWORD

  • cd /vastorage/opt/novell/zenworks/share/pgsql/bin/

  • ./psql

On Windows Open command prompt and set the following parameters:

  • set PGPASSWORD=<password>

  • set PGUSER=<user_name>

  • set PGDATABASE=<database_name>

  • set PGPORT=<port_number>

  • cd C:\Program Files (x86)\Novell\ZENworks\share\postgres\bin

  • psql