Deployment Instructions¶

Preparing pggraph for installation¶

• symlink all the scripts into the containing directory
• copy config.ini and ssh.ini into the containing directory
• Verify the existence of the pggraph database, and all the functions and types have been created.
• Configure the INI file:
  • Local database, pggraph
  • SSH connection to the remote server
  • Authentication on their postgres server. postgres user credentials
  • Determine their pricing plan for pggraph statistics, and set shortest interval accordingly. Should match the cron length.
  • Decide on a prefix
• Run the installer.
• Start up forward.py. It will read the connection info from the ssh.ini file and initiate a tunnel to the remote server.
• run bridge.py, verify that it can correctly pull data over the bridge.
• Add a cronjob for bridge.py, with the single argument of the filesystem location of the config file it is to use.

Apache¶

• Decide on where pggraph will live on the filesystem
• Configure apache to expose the directory where pggraph2 is installed to the web, as a CGI directory.
• Allow .py to execute via python
• Mark pggraph_index.py, pggraph_database.py, and pggraph_table.py as +x
• verify correct operation