On Jan 18, 2011, at 12:39 AM, Vladimir Rusinov wrote:
> If sync won't finish in 9 hours, abort it, run pg_stop_backup() and continue
> next day - I assume most of the data won't change, so rsync won't re-transfer
> it (but will calculate hash and compare).
And there's --partial in case you have
On 2011-01-18, Vladislav Geller wrote:
> Hello,
>
> I'm currently in the process of migrating a huge live database from
> one part of the world to the other (for local use and data analysis).
> The bandwidth does not allow me to get a decent transfer speed.
> Furthermore i can not migrate during b
You don't need a lot of additional space to run pg_start_backup(). Read
following:
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html (see
24.3.2)
On Tue, Jan 18, 2011 at 10:49 AM, Vladislav Geller <
vladislav.gel...@vincorex.ch> wrote:
> HI,
>
> The problem with this soluti
Try to backup schema by schema or table by table starting from those which
are being changed rarely.
On Tue, Jan 18, 2011 at 8:49 AM, Vladislav Geller <
vladislav.gel...@vincorex.ch> wrote:
> HI,
>
> The problem with this solution is that i don't have enough space on the
> targeted live to implem
HI,
The problem with this solution is that i don't have enough space on the
targeted live to implement such a procedure. It would have to work by pulling
data directly off the live server. The issue with new data whilst the procedure
is running (over a span of days or weeks in not severe as eac
On Tue, Jan 18, 2011 at 8:07 AM, Vladislav Geller <
vladislav.gel...@vincorex.ch> wrote:
> Hello,
>
> I'm currently in the process of migrating a huge live database from one
> part of the world to the other (for local use and data analysis). The
> bandwidth does not allow me to get a decent transf
On Mon, Jan 17, 2011 at 10:07 PM, Vladislav Geller
wrote:
> Hello,
>
> I'm currently in the process of migrating a huge live database from one part
> of the world to the other (for local use and data analysis). The bandwidth
> does not allow me to get a decent transfer speed. Furthermore i can n
Hello,
I'm currently in the process of migrating a huge live database from one part of
the world to the other (for local use and data analysis). The bandwidth does
not allow me to get a decent transfer speed. Furthermore i can not migrate
during business hours since the connection is critical.
