Presto Administration : Presto Server Administration : Upgrade to New Versions of Presto and Migrate Artifacts : Migrating the Presto Repository from 3.1.1 to 3.2
Migrating the Presto Repository from 3.1.1 to 3.2
If you are upgrading to Presto 3.2, but using an existing 3.1.1 Presto Repository, there are several minor updates to the schema or configuration properties that you must make to your 3.1.1 Presto Repository.
1. If your existing 3.1.1 Presto Repository is hosted in a PostgreSQL database, you must replace one JAR file before you apply schema changes:
a. Remove the web-apps-home/presto/WEB-INF/lib/rds.jar JAR file. You can delete this JAR or simply move it to a folder outside of the Presto web application.
b. Copy this JAR file:
presto-install/dist/rds-postgresql.jar
To the web-apps-home/presto/WEB-INF/lib folder.
2. Use the SQL client or command line tool for your existing 3.1.1 Presto Repository. Run the SQL script shown below from the folder that corresponds to your database in presto-install/prestorepository:
Database
Folder
SQL Script
HSQL
hsqldb
updateDB3.2.sql
Microsoft SQL Server
mssqldb
MySQL
mysqldb
Oracle
oracledb
PostgreSQL
postgresdb
Copyright © 2006-2015 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback