Re: PUGS talk

Lists: sfpug
From: Dirk Jagdmann <doj(at)cubic(dot)org>
To: sfpug(at)postgresql(dot)org
Subject: PUGS talk
Date: 2008-04-11 17:20:43
Message-ID: 47FF9DEB.30907@cubic.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

Hello all together,

I woulk like to introduce
my asynchronous-multi-master replication for PG on one of the future
meetings and I have already started to sketch out the details of the
talk. If you're interested we have to decide when and where this can
be done.

--
---> Dirk Jagdmann
----> http://cubic.org/~doj
-----> http://llg.cubic.org


From: Josh Berkus <josh(at)agliodbs(dot)com>
To: sfpug(at)postgresql(dot)org
Cc: Dirk Jagdmann <doj(at)cubic(dot)org>
Subject: Re: PUGS talk
Date: 2008-04-11 22:21:43
Message-ID: 200804111521.44381.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

Dirk,

> I woulk like to introduce
> my asynchronous-multi-master replication for PG on one of the future
> meetings and I have already started to sketch out the details of the
> talk. If you're interested we have to decide when and where this can
> be done.

That would be great! Let me work out with David what months we're doing
what, and get back to you with some dates next week.

Do you have a location preference: SF, East Bay or South Bay?

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco


From: David Fetter <david(at)fetter(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: sfpug(at)postgresql(dot)org, Dirk Jagdmann <doj(at)cubic(dot)org>
Subject: Re: PUGS talk
Date: 2008-04-11 23:04:41
Message-ID: 20080411230441.GD3128@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

On Fri, Apr 11, 2008 at 03:21:43PM -0700, Josh Berkus wrote:
> Dirk,
>
> > I woulk like to introduce my asynchronous-multi-master replication
> > for PG on one of the future meetings and I have already started to
> > sketch out the details of the talk. If you're interested we have
> > to decide when and where this can be done.
>
> That would be great! Let me work out with David what months we're
> doing what, and get back to you with some dates next week.
>
> Do you have a location preference: SF, East Bay or South Bay?

I think we have May open, booked June, open July and booked August.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


From: "Dirk Jagdmann" <doj(at)cubic(dot)org>
To: josh(at)agliodbs(dot)com
Cc: sfpug(at)postgresql(dot)org
Subject: Re: PUGS talk
Date: 2008-04-16 03:17:03
Message-ID: 1599.12.110.57.194.1208315823.squirrel@mail.cubic.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

>> I woulk like to introduce
>> my asynchronous-multi-master replication for PG on one of the future
>> meetings and I have already started to sketch out the details of the
>> talk. If you're interested we have to decide when and where this can
>> be done.
>
> Do you have a location preference: SF, East Bay or South Bay?

I could do it in May and I'm fine with either location.

--
---> Dirk Jagdmann ^ doj / cubic
----> http://cubic.org/~doj
-----> http://llg.cubic.org


From: David Fetter <david(at)fetter(dot)org>
To: Dirk Jagdmann <doj(at)cubic(dot)org>
Cc: josh(at)agliodbs(dot)com, sfpug(at)postgresql(dot)org
Subject: Re: PUGS talk
Date: 2008-04-27 22:35:14
Message-ID: 20080427223514.GD13175@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

On Wed, Apr 16, 2008 at 05:17:03AM +0200, Dirk Jagdmann wrote:
> >> I woulk like to introduce
> >> my asynchronous-multi-master replication for PG on one of the future
> >> meetings and I have already started to sketch out the details of the
> >> talk. If you're interested we have to decide when and where this can
> >> be done.
> >
> > Do you have a location preference: SF, East Bay or South Bay?
>
> I could do it in May and I'm fine with either location.

Dirk,

Could you send a short paragraph introducing this?

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


From: Dirk Jagdmann <doj(at)cubic(dot)org>
To: David Fetter <david(at)fetter(dot)org>
Cc: sfpug(at)postgresql(dot)org
Subject: Re: PUGS talk
Date: 2008-04-28 05:01:58
Message-ID: 48155A46.8070502@cubic.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

pg_trompe is a multi-master asynchronous replication system for
PostgreSQL. It was designed to provide a simple mechanism to share data
between multiple server installations in an application using replicated
table data and large objects. It is implemented as a set of stored
procedures and triggers on every database instance, written in pl/pgsql
and a perl program to transmit data between servers. Some of the
difficulties of multi-master replication have been solved by convention,
while others are intentionally ignored.

The talk gives an overview of the application and situation which led to
the development of pg_trompe, then discusses my solution to the
replication problem. I introduce the pl/pgsql and perl code and will
answer any questions on this project or other interesting topics.

--
---> Dirk Jagdmann
----> http://cubic.org/~doj
-----> http://llg.cubic.org