| From: | Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> |
|---|---|
| To: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
| Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Incremental backup with RSYNC or something? |
| Date: | 2011-11-18 07:09:36 |
| Message-ID: | CAFrxt0iqby3sdn1uU56LUtK+9BaJPiX+OS7zij4CuNP+zMdPPg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Nov 18, 2011 at 6:08 AM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>wrote:
> On Mon, Nov 14, 2011 at 1:45 PM, Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
> wrote:
> >> Question: what can I do to rsync only the new additions in every table
> >> starting 00:00:01 until 23:59:59 for each day?
> >
> > A table level replication (like Slony) should help here.
>
>
> Slony needs more than one physical server, right?
>
Not necessarily, you can replicate with-in the same host as well. It all
depends on which tables you want to replicate.
It does not depend on number of hosts.
Thanks
VB
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2011-11-18 07:30:41 | Re: pg_dump error |
| Previous Message | Mamatha_Kagathi_Chan | 2011-11-18 07:01:19 | pg_dump error |