Support
Postgresql and Timesheet

 

This page describes how to set up Journyx Timesheet for Unix to use an external Postgresql database.

Journyx provides an "Internal Database" on the Unix platform based on the open-source Postgresql database. The Internal Database does not require any special setup instructions. However, if you want Timesheet to talk to your own Postgresql server, you must follow the instructions on this page.

External Postgresql instructions

Follow these steps to install to an external Postgresql instance.

  1. Note that you can only talk to an external Postgresql server if your Timesheet server is running on Unix-like platform such as Linux, FreeBSD, or Solaris. You cannot talk to external Postgresql from a Windows Timesheet server. (Likewise, you cannot talk to Microsoft SQL Server from Timesheet on Unix.)
  2. Make sure your Postgresql server is version 7.3 or later.
  3. Make sure you have read the general instructions here.
  4. Create a database for Timesheet with the createdb command. Consult the Postgresql documentation for more information on creating databases and users.
  5. Make sure to choose the appropriate character set for the database. See this page for general guidelines on choosing a character set. Do not pick a Unicode character set. See the Postgresql documentation for specific instructions on character sets.
  6. Create a user in Postgresql for the Timesheet account. Make sure the user has permissions to access the database you created above.
  7. Make sure the plpgsql language is installed in the database. Run this command:

    createlang plpgsql <database_name>

    See your Postgresql documentation on createlang for further information on createlang.

  8. When the database is ready, unzip and un-tar the product distribution in the normal manner.
  9. Run the jtinstall install script and give the externaldb option.

    ./jtinstall --externaldb jxdbpgres instuser/pghost/pgport/pguser pgpass

    Where:

    • instuser is the Postgresql user for Timesheet
    • pgport is the port where the external Postgresql server can be found
    • pguser is the postgres user
    • pgpass is the postgres user password