Thread: data transfer between databases

Hi ,

Can anyone suggest a good method to perform frequent data transfers (for eg. every 10 minutes) between 2 databases in PostgreSQL (on Linux) on same machine ?

Thanks in advance for the suggestions.

Keshav

---

Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

<snip>
> Can anyone suggest a good method to perform frequent data transfers (for eg. every 10 minutes) between 2 databases in
PostgreSQL(on Linux) on same machine ? 
</snip>

Look up pg_dump, pg_dumpall, and COPY in the user manual.  It should be
relatively easy to use cron to dump to a certain file every 10 minutes
and then send it to another computer.

That should be all you need if you just need to create a copy of
databases (i.e. you want an off site backup).  If you're looking to sync
databases against each other I *think* it may be possible to use a text
editor like emacs or vi to compare dumps between computers -- but that's
just speculation on my part.

Perhaps a Postgresql guru can chip in?

--
Daniel R. Anderson
Great Lakes Industries, Inc.
80 Pineview Ave.
Buffalo, NY 14218
(716) 691-5900 x218

"Never let your schooling interfere with your education"
    -- Mark Twain