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

    • How to purge data from PassagePoint

      It is recommended that a good backup is performed before purging any data. see here: https://support.stopware.com/portal/en/kb/articles/how-do-i-backup-my-database-before-performing-a-passagepoint-upgrade Remember that Data Deleted using this process ...

    • 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 https://support.stopware.com/portal/en/kb/articles/sqlcontext-for-windows-authentication For SQL Authentication see instructions below. If TLS is required, see attachements. 1) Create a clean database ...

    • Importing Self Signed Certs into PassagePoint (SSL)

      Must be 6452 or Higher Login to the PassagePoint desktop client with an admin account Do Home > Configure System > System Administration > Database Tool > Certificate/Keystore for HTTPS Click on ‘Generate’ button , this will open the generate ...

    • 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 ...