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

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.

    • Related Articles

    • Use MSSQL database instead of PostgreSQL

      If you want to use SQL, after PassagePoint has been installed >> go to \PPGlobal\config delete the first 'sqlcontext.xml' file. Then rename the 'sqlcontext.xml.mssql' to 'sqlcontext.xml' Here - edit the new updated 'sqlcontext.xml' You will need to ...
    • How to connect to Microsoft SQL database and encyrpt user password

      Note: For windows authentication see KB article For SQL Authentication see instructions below. If TLS is required, see attachements. 1) Create a clean database ...
    • How to purge data from PassagePoint

      It is recommended that a good backup is performed before purging any data. see here: Remember that Data Deleted using this process ...
    • How to Automatically Back-up the PostgreSQL Database

      To automatically backup the PassagePoint PostgreSQL database, create a Windows task with the changes below to invoke the PostgreSQL agent to back up the database. Create a batch file with the line below, and add it to your Window task: pg_dump -i -h ...
    • How do I move PassagePoint global to a different server?

      How do I move PassagePoint Global to a different server? Source Machine = Production server is the customer's server that contains the PassagePoint Global “config” folder and database Destination Machine = New server for the PassagePoint Global ...