]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register
 

Contents

Remote Training
Support
SaaS Service

3 registered users
 in last 24 hours

Maintenance FAQ

References

 

How to upgrade ]project-open[?

There are [several documents] providing detailed upgrade instructions for various ]po[ versions.

How to backup and restore

This is explained in detail in the PO-Operations-Maintenance-Guide.

Basicly, you use the built-in PostgreSQL commands to backup and restore your database. There is a "wrapper page" in ]project-open[, but this page basicly calls the PostgreSQL commands:

To backup: pg_dump projop -c -O -F p -f c:/backup.YYYY-MM-DD.sql

To restore: psql -d projop -f c:/backup.YYYY-MM-DD.sql

These commands work both on Linux and Windows (CygWin shell). Please note that the "forward slashes" are being used in both cases.

Please note that the "restore" operation may write out a lot of error messages if you load a backup dump into an empty database. This is because the backup file contains SQL commands to delete the data in an existing database. You don't need to worry about these errors.


PO server runs very slow after a couple of months in production. What can can I do to improve the performance?

Installations using PostgreSQL 8.2 and earlier require frequent DB vacuums. The VM downloadable from SOURCEFORGE should be configured accordingly (see crontab).
Results are written into /var/log/postgres82/vacuumdb.log (or similar). First check this log file for any irregularities.

Next you want to check your /web/projop/log/error.log file for irregularities.

Other reasons for bad performance can be:

  • Low disk space
    Extend/free disk space and /or use de-fragmentation tools 

  • Long running SQL statements.
    Use 'top' and type 'c' to make statement visible.  



Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy