Search Postgresql Archives

Re: Slony v. DBMirror

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, May 06, 2005 at 09:01:58AM -0400, Jeff - wrote:
> slave and hten fire up dbmirror.  Although it might work if you  
> install the dbmirror triggers, then dump & restore.

It's a little trickier than that, but yes, it might work.  Somewhere
in my mail archives, I have a very angry rant about this problem and
erserver (the current community version, approximately).  I looked at
dbmirror, and it took me no time to conclude it had the same issues. 
It wouldn't be a problem for everyone.

> Slony uses the COPY interface to read/load data.  This is the same  
> method used by pg_dump so the only throttle will be the network.

Not quite, because your schema needs to be complete on the target
system (in particular, you need your unique keys to stay, although
you can get rid of some other indexes to speed things up).

A

-- 
Andrew Sullivan  | ajs@xxxxxxxxxxxxxxx
The plural of anecdote is not data.
		--Roger Brinner

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux