[rt-users] BACKING UP RT WITH POSTGRES

2006-12-19 Thread Kurt A. Brust
What is the best way to do this? also what should be backed up? thanks ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden

Re: [rt-users] BACKING UP RT WITH POSTGRES

2006-12-19 Thread Kevin Murphy
Kurt A. Brust wrote: What is the best way to do this? also what should be backed up? Just use pg_dump to create a self-consistent snapshot of the database. Hopefully you have some general backup scheme to back up your systems, which will safeguard your RT customizations (RT_SiteConfig.pm

RE: [rt-users] BACKING UP RT WITH POSTGRES

2006-12-19 Thread Scott Golby
What is the best way to do this? also what should be backed up? I'm doing a Dump of the DB /usr/bin/pg_dump rt3 /root/backups/rt3-db-$TODAY_DATE.sql Then running tar and picking up that file, the whole of /opt/rt3 and rolling them into one package. You might also want to pick up the Apache