On Fri, 2007-06-01 at 22:13 -0500, Ron Johnson wrote:
> On 06/01/07 19:29, Jeff Davis wrote:
> [snip]
> > You shouldn't use a volatile function in a check constraint. Use a
> > trigger instead, but even that is unlikely to work for enforcing
> > constraints correctly.
> >
> > In general, for parti
On Sat, Jun 02, 2007 at 01:30:53AM +0200, Alexander Staubo wrote:
> There needs to be a point of synchronization when a DDL transaction
> appears that blocks further write transactions from running. As far as
> I can tell, the slaves themselves can continue to receive pending
> events, but perhaps
On Fri, Jun 01, 2007 at 06:15:40PM -0500, Ron Johnson wrote:
>
> Since DDL is infrequent, is that bottleneck an acceptable trade-off?
I don't know. We'd have to do the analysis. But it could be a
problem. Look at it this way: if you have a replica that is, for
isntance, _always_ 30 minutes beh
On 06/01/07 19:29, Jeff Davis wrote:
[snip]
You shouldn't use a volatile function in a check constraint. Use a
trigger instead, but even that is unlikely to work for enforcing
constraints correctly.
In general, for partitioning, you have to make some sacrifices. It's
very challenging (and/or exp
On 06/01/07 19:17, Joshua D. Drake wrote:
Ron Johnson wrote:
On 06/01/07 18:35, Joshua D. Drake wrote:
Since DDL is infrequent, is that bottleneck an acceptable trade-off?
Define infrequent? I have customers that do it, everyday in prod.
They do it willingly and refuse to change that habit.
On Sat, 2007-06-02 at 01:44 +0200, Alexander Staubo wrote:
> On 6/2/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
> > Here is some work going on that looks like what you want:
> >
> > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00050.php
>
> I had no idea someone was working on WAL-log-bas
Ron Johnson wrote:
On 06/01/07 18:35, Joshua D. Drake wrote:
Since DDL is infrequent, is that bottleneck an acceptable trade-off?
Define infrequent? I have customers that do it, everyday in prod. They
do it willingly and refuse to change that habit.
Even 2 or 3 ALTER TABLE or CREATE INDEX
On 06/01/07 18:35, Joshua D. Drake wrote:
Ron Johnson wrote:
On 06/01/07 17:31, Andrew Sullivan wrote:
On Sat, Jun 02, 2007 at 12:23:44AM +0200, Alexander Staubo wrote:
Could you not (I ask naively) detect the first DDL statement is
submitted in a transaction
Maybe.
on the master, then st
On 6/2/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
Here is some work going on that looks like what you want:
http://archives.postgresql.org/pgsql-hackers/2007-03/msg00050.php
I had no idea someone was working on WAL-log-based replication; I saw
the TODO entry a while ago, but I missed the thread
Ron Johnson wrote:
On 06/01/07 17:31, Andrew Sullivan wrote:
On Sat, Jun 02, 2007 at 12:23:44AM +0200, Alexander Staubo wrote:
Could you not (I ask naively) detect the first DDL statement is
submitted in a transaction
Maybe.
on the master, then start a transaction on
each slave, then funne
On 6/2/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Sat, Jun 02, 2007 at 12:05:20AM +0200, Alexander Staubo wrote:
> All you would require is a simple boolean flag to enable or disable
> automatic DDL propagation, surely.
You know, it is just possible that some of the responses you are
gett
On 06/01/07 17:31, Andrew Sullivan wrote:
On Sat, Jun 02, 2007 at 12:23:44AM +0200, Alexander Staubo wrote:
Could you not (I ask naively) detect the first DDL statement is
submitted in a transaction
Maybe.
on the master, then start a transaction on
each slave, then funnel this and all subse
On Sat, 2007-06-02 at 00:05 +0200, Alexander Staubo wrote:
> On 6/2/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
> > "Alexander Staubo" <[EMAIL PROTECTED]> writes:
> >
> > > I would love for the answer to have been "sorry, we did not have time
> > > or manpower enough to implement fully transparent
On Sat, Jun 02, 2007 at 12:23:44AM +0200, Alexander Staubo wrote:
> Could you not (I ask naively) detect the first DDL statement is
> submitted in a transaction
Maybe.
> on the master, then start a transaction on
> each slave, then funnel this and all subsequent statements
> synchronously to eve
On Sat, Jun 02, 2007 at 12:05:20AM +0200, Alexander Staubo wrote:
> All you would require is a simple boolean flag to enable or disable
> automatic DDL propagation, surely.
You know, it is just possible that some of the responses you are
getting in this thread have to do with the glib way you say
On 6/1/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Fri, Jun 01, 2007 at 11:08:50PM +0200, Alexander Staubo wrote:
> That doesn't make any sense. As a database *user* it's my prerogative
> to criticize the bits that make my life painful.
Sure. And as a user of free software, it is your pre
Scott Ribe wrote:
...fully transparent replication...
There is no such thing. Asking for it implies ignorance of the issues
involved and what is actually available with other database products.
We are darn close ;)
Argh, to be clear: I was referring to multimaster.
Heh, that isn't even on
>>> ...fully transparent replication...
>>
>> There is no such thing. Asking for it implies ignorance of the issues
>> involved and what is actually available with other database products.
>>
>
> We are darn close ;)
Argh, to be clear: I was referring to multimaster.
--
Scott Ribe
[EMAIL PROT
On 6/2/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
"Alexander Staubo" <[EMAIL PROTECTED]> writes:
> I would love for the answer to have been "sorry, we did not have time
> or manpower enough to implement fully transparent replication yet,
> because it's a rather complex, you see";
Would you st
"Alexander Staubo" <[EMAIL PROTECTED]> writes:
> I would love for the answer to have been "sorry, we did not have time
> or manpower enough to implement fully transparent replication yet,
> because it's a rather complex, you see";
Would you still love that if you're one of the people who use rep
On Fri, Jun 01, 2007 at 11:08:50PM +0200, Alexander Staubo wrote:
> That doesn't make any sense. As a database *user* it's my prerogative
> to criticize the bits that make my life painful.
Sure. And as a user of free software, it is your prerogative to
propose a way that the software can be modi
On 6/1/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> I could be wrong, but I believe Slony fails at this because it is
> trigger-based and simply cannot detect DDL changes.
No, there were in fact alternatives (like, for instance, patching the
back end code). But that was undesirable for the
On 6/1/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
As the owner of a company that actually actively developing a
replication system and has for years... I suggest you start putting your
code where your words are.
That doesn't make any sense. As a database *user* it's my prerogative
to critic
[EMAIL PROTECTED] writes:
> I'm disappointed because SLONY-II has not been released yet to support
> multi-master replication! PostgreSQL is going through all of the
> releases - and that's great - BUT, where is the sync-up with the
> powerhouse of a component, that Slony-II would bring to the tab
"Alexander Staubo" <[EMAIL PROTECTED]> writes:
> On 6/1/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
>> To be fair to Slony-I, the fact that it does not replicate DDL is a
>> feature, not a bug. It's table-based, which is a very flexible design.
> I fail to see how that's an excuse not to replicate D
On Fri, Jun 01, 2007 at 08:57:36PM +0200, Alexander Staubo wrote:
> I fail to see how that's an excuse not to replicate DDL. If I run
> "alter table" on the master, there is no reason whatever that this
> command cannot be executed on all the slaves -- which is what I would
> expect of a replicatio
Alexander Staubo wrote:
On 6/1/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
On Fri, 2007-06-01 at 17:00 +0200, Alexander Staubo wrote:
> the projected Slony-II design, but the setup seems dead simple, and
> from the docs I have found it seems to transparently replicate schema
> changes, unlike Slon
On 6/1/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
On Fri, 2007-06-01 at 17:00 +0200, Alexander Staubo wrote:
> the projected Slony-II design, but the setup seems dead simple, and
> from the docs I have found it seems to transparently replicate schema
> changes, unlike Slony-I. So that's something.
On Fri, 2007-06-01 at 17:00 +0200, Alexander Staubo wrote:
> the projected Slony-II design, but the setup seems dead simple, and
> from the docs I have found it seems to transparently replicate schema
> changes, unlike Slony-I. So that's something.
>
To be fair to Slony-I, the fact that it does n
It does so well because it KICKS ICE!
On Fri, 1 Jun 2007, Joshua D. Drake wrote:
Dave Page wrote:
Alexander Staubo wrote:
On 6/1/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
In the meantime, Cybertec (http://www.postgresql.at/, an Austrian
company) just announced a commercial synchronous m
Dave Page wrote:
Alexander Staubo wrote:
On 6/1/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
In the meantime, Cybertec (http://www.postgresql.at/, an Austrian
company) just announced a commercial synchronous multimaster
replication product based on 2-phase commit. It's expensive, and I
[snip
Alexander Staubo wrote:
> On 6/1/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
>> > In the meantime, Cybertec (http://www.postgresql.at/, an Austrian
>> > company) just announced a commercial synchronous multimaster
>> > replication product based on 2-phase commit. It's expensive, and I
> [snip]
>
On 6/1/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> In the meantime, Cybertec (http://www.postgresql.at/, an Austrian
> company) just announced a commercial synchronous multimaster
> replication product based on 2-phase commit. It's expensive, and I
[snip]
I could be completely cranked but
Alexander Staubo wrote:
On 6/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I'm disappointed because SLONY-II has not been released yet to support
multi-master replication!
I wouldn't pin all my hopes on a project still under development. (For
me, personally, add the fact that Slony-I stil
On 6/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I'm disappointed because SLONY-II has not been released yet to support
multi-master replication!
I wouldn't pin all my hopes on a project still under development. (For
me, personally, add the fact that Slony-I still has not solved
single-m
[EMAIL PROTECTED] wrote:
On Fri, 1 Jun 2007, Joshua D. Drake wrote:
Which databases ship with multi-master replication?
I dunno, which ones?
Which ones have robust and fully functional multi-master replication?
(Oracle, MS SQL, not-PostgreSQL).
You consider Oracle RAC fully functional mul
On Fri, 1 Jun 2007, Joshua D. Drake wrote:
[EMAIL PROTECTED] wrote:
Group,
I have to admit, I'm a little disappointed. I'm a HUGE advocate of
PostgreSQL(to state for the record) - in fact I always keep my eyes peeled
for opportunities to recommend it in my day to day business.
So why am I
[EMAIL PROTECTED] wrote:
Group,
I have to admit, I'm a little disappointed. I'm a HUGE advocate of
PostgreSQL(to state for the record) - in fact I always keep my eyes
peeled for opportunities to recommend it in my day to day business.
So why am I disappointed, and who really cares?
I'm disa
On Apr 1, 2006, at 0:19 , Robert Treat wrote:
On Thursday 30 March 2006 03:03, Aaron Glenn wrote:
Anyone care to share the great books, articles, manifestos, notes,
leaflets, etc on data modelling they've come across? Ideally I'd like
to find a great college level book on data models, but I ha
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Robert
Treat) transmitted:
> On Thursday 30 March 2006 03:03, Aaron Glenn wrote:
>> Anyone care to share the great books, articles, manifestos, notes,
>> leaflets, etc on data modelling they've come across? Ideally I'd like
>
On Thursday 30 March 2006 03:03, Aaron Glenn wrote:
Anyone care to share the great books, articles, manifestos, notes,
leaflets, etc on data modelling they've come across? Ideally I'd like
to find a great college level book on data models, but I haven't come
across one that even slightly holds "d
On Mar 30, 2006, at 2:03 AM, Aaron Glenn wrote:Anyone care to share the great books, articles, manifestos, notes,leaflets, etc on data modelling they've come across? Ideally I'd liketo find a great college level book on data models, but I haven't comeacross one that even slightly holds "definitive
Robert Treat wrote:
On Thursday 30 March 2006 03:03, Aaron Glenn wrote:
Anyone care to share the great books, articles, manifestos, notes,
leaflets, etc on data modelling they've come across? Ideally I'd like
to find a great college level book on data models, but I haven't come
across one that e
On Thursday 30 March 2006 03:03, Aaron Glenn wrote:
> Anyone care to share the great books, articles, manifestos, notes,
> leaflets, etc on data modelling they've come across? Ideally I'd like
> to find a great college level book on data models, but I haven't come
> across one that even slightly ho
In the last exciting episode, [EMAIL PROTECTED] ("Aaron Glenn") wrote:
> Anyone care to share the great books, articles, manifestos, notes,
> leaflets, etc on data modelling they've come across? Ideally I'd like
> to find a great college level book on data models, but I haven't come
> across one th
45 matches
Mail list logo
