Maintenance FAQ

References

PO-Operations-Maintenance-Guide - In-depth description of maintenance procedures

Questions

How to upgrade ]project-open[?

You can upgrade ]project-open[ manually using CVS. Our CVS server is publicly available with the user "anonymous" on berlin.dnsalias.com. For further instructions please see our update tutorial
With the official release of 3.4 we will introduce an Automatic Update Service (ASUS) that will allow you to upgrade your server right out of the Admin section of ]po[.

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.

References to this Page: en:list_faq Categories: FAQ (Contents), Evaluators (User Profiles), ]po[ Beginners (User Profiles), ]po[ Users (User Profiles), ]po[ Application Admins (User Profiles), ]po[ Report Developers (User Profiles), ]po[ Developers (User Profiles), System Admins (User Profiles)