Re: [SQL] Backup Database

2007-11-05 Thread Asko Oja
Hi We do it with Skytools. In addition to replication with Londiste it hs lot's of other useful scripts for keeping online database small and healthy. Asko On 10/31/07, Joanne Salerno <[EMAIL PROTECTED]> wrote: > > I have two Postgres databases (7.4 and 8.24) within the same network on > LINUX

Re: [SQL] Backup Database

2007-10-31 Thread Andrew Sullivan
On Wed, Oct 31, 2007 at 10:14:33AM -0700, Joanne Salerno wrote: > I'd like to set up one as a near real-time backup to the operational > database. Is it possible to incorporate a trigger upon update (or > insert) on the operational 8.24 database to initiate an update (or > insert) on the backup

Re: [SQL] backup database tablespace with rsync?

2007-10-20 Thread Scott Marlowe
On 10/19/07, chester c young <[EMAIL PROTECTED]> wrote: > postgres A, db 'test', tablespace /pg/test1 > postgres B, db 'test', tablespace /pg/test2 > > tablespace /pg/test1 only has A db 'test' > tablespace /pg/test2 only has B db 'test' > > if > - A and B shut down > - /pg/test1 copied to /pg/test