Hello Arthur> but I have no clue how to backup postgreHave a look at the attached sample scripts. I run pgsql_backup_all.shnightly, driven by cron.In case of need for full restore using pgsql_restore_all.sh, the parts =youneed from globals.sql dump might better be executed manually from insidepsql - but you could mainly script them also, of course.Make sure the user executing the scripts (and started by cron) has allcredentials/rights to log to the database as requested.Kind regardsUeli Flueck-----UrsprĪgliche Nachricht-----Von: Arthur Sherman [mailto:arturs (at mark) netvision.net.il] Gesendet: Freitag, 5. Januar 2007 02:13An: coba-e (at mark) bluequartz.orgBetreff: [coba-e:08482] Re: Backup solution> I've been reading this thread for a while. This is how I do it. > > First I create a list of my sites. I then loop through the > list and create an individual cmu export of each > site on the box. I then create a dated tar/gzip archieve the > cmu export and push it off to my backup > server. > > This makes it easy to move/restore an indiviual site and > leaves me with very small cmu exports. It also > avoids a lot of the issues assosiated with large dumps.> > http://home.lewiscounty.com/~forhire/backup.txt> > Have fun,> > RandyI'd add named, mysql, postgre, /etc/mail, all configs and maybe =installedextra packages sources.There was a thread bout backing up the named, but I have no clue how to =backup postgreBest,--Arthur Sherman+972-52-4878851CPTeam
8483_2.tgz