Date:  Fri, 05 Jan 2007 14:01:21 +0200
From:  Arthur Sherman <arturs (at mark) netvision.net.il>
Subject:  [coba-e:08486] Re: AW:  Re: Backup solution
To:  coba-e (at mark) bluequartz.org
Message-Id:  <016301c730c1$392c3b90$3701a8c0@lapxp>
In-Reply-To:  <000f01c7307b$abe30100$5014a8c0 (at mark) byticsco.local>
X-Mail-Count: 08486

> Have a look at the attached sample scripts. I run pgsql_backup_all.sh
> nightly, driven by cron.
> In case of need for full restore using pgsql_restore_all.sh, 
> the parts you
> need from globals.sql dump might better be executed manually 
> from inside
> psql - but you could mainly script them also, of course.
> 
> Make sure the user executing the scripts (and started by cron) has all
> credentials/rights to log to the database as requested.
> 
> Kind regards
> Ueli Flueck


Thank you a lot.
I believe many people here will appreciate your script, too.


Best,

--
Arthur Sherman

+972-52-4878851
CPTeam