How do I backup my database before performing a PassagePoint upgrade?

It is IMPORTANT you make sure you make backups before the update.

On the passagepoint server machine

1) Locate and stop the passagepoint service.

2) Locate the PPGlobal folder and backup the entire "config" folder.

3) On the Database side, see steps below if using postgresql. (If running MS SQL server or Oracle, please consult your DBA)

to determine if you're running PostgreSQL, open the sqlcontext.xml file, and if it says "org.postgresql.Driver, passagepoint is using postgreSQL

see screenshot below:

To backup PostgreSQL Database

1. Start->all programs->postgreSQL->PGAdmin III

2. Double-click on PostgreSQL Database Server 8.2 (or 9.2) or whatever version you have.

3. Login with "amber" as the password (unless you've changed it)

4. Once logged in, expand the directory until you can highlight the amber database and select backup

filename - click and save to a location

select "Custom"

select UTF8

Rolename - postgresw

then hit the backup.