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