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
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
I have two Postgres databases (7.4 and 8.24) within the same network on
LINUX platforms. Data sources go to both databases.
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 da
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
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/test2
- A and B restarted
would B db 'test' be running the data that was in
