pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBackup Database
3+ messages / 3 participants
[nested] [flat]
* Backup Database
@ 2007-10-31 17:14 Joanne Salerno <joanne.salerno@noaa.gov>
0 siblings, 2 replies; 3+ messages in thread
From: Joanne Salerno @ 2007-10-31 17:14 UTC (permalink / raw)
To: pgsql-sql
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 database to initiate an update (or
insert) on the backup 7.4 database?
How do most people set up a near real-time backup database? Perhaps
there is something else that acts like a trigger. Any suggestions would
be helpful.
Thanks. Joanne
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Backup Database
@ 2007-10-31 19:04 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Joanne Salerno <joanne.salerno@noaa.gov>
1 sibling, 0 replies; 3+ messages in thread
From: Andrew Sullivan @ 2007-10-31 19:04 UTC (permalink / raw)
To: pgsql-sql
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 7.4 database?
You can do this with Slony, assuming nothing else needs to be written
(on the replicated tables) into the 7.4 system.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
Never get involved in litigation. Your hair will fall out, your bones
will turn to sand. And it will still be going on.
--Tom Waits
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Backup Database
@ 2007-11-05 09:30 Asko Oja <ascoja@gmail.com>
parent: Joanne Salerno <joanne.salerno@noaa.gov>
1 sibling, 0 replies; 3+ messages in thread
From: Asko Oja @ 2007-11-05 09:30 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
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 <joanne.salerno@noaa.gov> wrote:
>
> 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 database to initiate an update (or
> insert) on the backup 7.4 database?
>
> How do most people set up a near real-time backup database? Perhaps
> there is something else that acts like a trigger. Any suggestions would
> be helpful.
>
> Thanks. Joanne
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-11-05 09:30 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-31 17:14 Backup Database Joanne Salerno <joanne.salerno@noaa.gov>
2007-10-31 19:04 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-11-05 09:30 ` Asko Oja <ascoja@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox