Historique de la page

Faire un dump de la base V2 Dump your 2.x database:

pg_dump -f helpdesk2.sql helpdesk2

Corriger le fichier créé, en commentant le début du fichier contenant les informations du type 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;

Créer un nouvelle base Create a new database:

createdb --encoding=UTF-8 helpdesk3

Insérer les données de la version 2 dans la base Insert the 2.x data into the new database:

> psql helpdesk3
 
helpdesk3=> \i helpdesk2.sql

Configurer la connexion à PostgreSQL comme indiqué dans .

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 Lancer la procédure ant upgrade.