On Fri, May 06, 2005 at 05:42:38PM +0100, Peter Wilson wrote:
> I got the lack of schema changes from the Slony documentation.
This seems odd. I see Brad already told you what to look for; but
putting schema changes in through slonik was _always_ part of the
design. What's always been true (and
On Fri, May 06, 2005 at 12:09:14PM -0400, Chris Browne wrote:
> What I need, for that, is a way of grabbing all the index definitions
> for the table. One way to do that would be to run "pg_dump -s -t a",
> though I'd rather have a method that uses the connection I already
> have to the database.
Peter Wilson wrote:
Andrew Sullivan wrote:
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
Looking at Slony now, can someone tell me what the benefits of Slony
are over DBmirror? As far as I can see:
+ both are async Master->multiple slaves
+ both (I think) can do cascaded replicatio
[EMAIL PROTECTED] (Jeff -) writes:
> On May 5, 2005, at 5:03 PM, Grant McLean wrote:
>>
>> Why would you need to take anything down to run pg_dump? And surely
>> bringing a slave up to speed using Slony would be much slower than
>> dump/restore?
>>
>
> You'd need to stop client access to PG to pre
Andrew Sullivan wrote:
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
Looking at Slony now, can someone tell me what the benefits of Slony are
over DBmirror? As far as I can see:
+ both are async Master->multiple slaves
+ both (I think) can do cascaded replication
This isn't really
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
> Looking at Slony now, can someone tell me what the benefits of Slony are
> over DBmirror? As far as I can see:
> + both are async Master->multiple slaves
> + both (I think) can do cascaded replication
This isn't really true of dbmirr
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
Peter Wilson wrote:
Grant McLean wrote:
On Thu, 2005-05-05 at 14:16 -0400, Jeff - wrote:
One of the biggest things for Slony is that you can install slony,
set things up and it will bring the slave(s) "up to speed". You
don't need to do an initial data dump (I think you still need to
load th
On May 5, 2005, at 5:03 PM, Grant McLean wrote:
Why would you need to take anything down to run pg_dump? And surely
bringing a slave up to speed using Slony would be much slower than
dump/restore?
You'd need to stop client access to PG to prevent changes from
occuring between when you take the d
Grant McLean wrote:
On Thu, 2005-05-05 at 14:16 -0400, Jeff - wrote:
One of the biggest things for Slony is that you can install slony,
set things up and it will bring the slave(s) "up to speed". You
don't need to do an initial data dump (I think you still need to load
the schema on the slav
On Thu, 2005-05-05 at 14:16 -0400, Jeff - wrote:
> One of the biggest things for Slony is that you can install slony,
> set things up and it will bring the slave(s) "up to speed". You
> don't need to do an initial data dump (I think you still need to load
> the schema on the slaves, but not
On May 5, 2005, at 10:35 AM, Peter Wilson wrote:
I couldn't get it to work - and having tried another couple of
solutions I settled on DBMirror which comes with Postgres in the
'contrib' directory.
I've had no issues setting up slony. I've even had it running in a 6
node cluster with no i
12 matches
Mail list logo