| From: | "Daniel R(dot) Anderson" <dan(at)mathjunkies(dot)com> |
|---|---|
| To: | Keshava Krishnagiri <keshavm12(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: data transfer between databases |
| Date: | 2003-03-22 01:24:04 |
| Message-ID: | 1048296255.8210.4.camel@ny-chicagostreet2c-110.buf.adelphia.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2003-03-22 01:56:25 | Re: configuration according to the database |
| Previous Message | Daniel R. Anderson | 2003-03-22 00:45:49 | Re: configuration according to the database |