Re: [rt-users] Postgres and 3.8.2
2009/1/15 Dominic Hargreaves : > On Thu, Jan 15, 2009 at 10:26:51PM +, Gavin Henry wrote: >> We've got an existing 3.6.7 db in rt3 and /opt/rt3. I've create a new >> Pg rt38 db and /opt/rt38 dir. All is installed and working. >> >> What's the best way to get the tickets etc. out of the old DB, as >> there's nothing listed in UPGRADING about this and I don't want >> to trample on new tables etc. > > The best way is to point the RT 3.8 config at the old database, and then > run the rt-setup-database script in order to apply the necessary schema > updates. Obviously back up your database before doing this! > > You don't need to set up a completely new database. Great news, thanks. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Postgres and 3.8.2
On Thu, Jan 15, 2009 at 10:26:51PM +, Gavin Henry wrote: > We've got an existing 3.6.7 db in rt3 and /opt/rt3. I've create a new > Pg rt38 db and /opt/rt38 dir. All is installed and working. > > What's the best way to get the tickets etc. out of the old DB, as > there's nothing listed in UPGRADING about this and I don't want > to trample on new tables etc. The best way is to point the RT 3.8 config at the old database, and then run the rt-setup-database script in order to apply the necessary schema updates. Obviously back up your database before doing this! You don't need to set up a completely new database. Dominic. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Postgres and 3.8.2
Hi, We've got an existing 3.6.7 db in rt3 and /opt/rt3. I've create a new Pg rt38 db and /opt/rt38 dir. All is installed and working. What's the best way to get the tickets etc. out of the old DB, as there's nothing listed in UPGRADING about this and I don't want to trample on new tables etc. Thanks. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com