esup-helpdesk




User list not rendered as you do not have the privilege to view user profiles.

Page tree

Dump your 2.x database:

pg_dump -f helpdesk2.sql helpdesk2

Fix the output file by commenting the fillowing lines (at the very beginning of the file):

-- PostgreSQL database dump
-- SET client_encoding = 'latin9';
-- SET standard_conforming_strings = off;
-- SET check_function_bodies = false;
-- SET client_min_messages = warning;
-- SET escape_string_warning = off;
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
-- COMMENT ON SCHEMA public IS 'Standard public schema';
-- SET search_path = public, pg_catalog;
-- SET default_tablespace = '';
-- SET default_with_oids = true;

Create a new database:

createdb --encoding=UTF-8 helpdesk3

Insert the 2.x data into the new database:

> psql helpdesk3
 
helpdesk3=> \i helpdesk2.sql

Install version 3.x.

Recover your previous configuration (ant recover-config).

Edit /properties/config.properties to change your data path (and maybe the resource in <tomcat>/conf/server.xml).

Launch ant upgrade.

  • No labels