[Pgcluster-general] Replicating Specific DB

[Rick Vernam]

On Friday 07 September 2007 04:17:02 pm Matthew wrote:
> So what does it replicate?
It replicates queries.
As queries come in, it looks at the query and determines if it is a query that 
will modify data.  If so, it sends the query to the other cluster members.
It is careful to make sure that other cluster members who receive the 
replicated query know what value to use for now().
Other than the fixation of a value for now(), it just allows the other cluster 
members to execute the query as normal.

> All databases's and all schemas?
Yes and Yes.  Although there might be a configuration to tell it to NOT 
replicate queries for specific database/table.  I've never used it, and have 
never really paid any attention to it, sorry.

> Basically  
> creates a mirror copy of the machine?
As you'd probably deduce from above, pgcluster doesn't touch the files that 
PostgreSQL uses.  Each cluster member (read: each postgresql server in 
communication with the replicator) is responsible for itself.  PGcluster only 
tries to ensure that data-changing queries are replicated to other cluster 
members (and of course, also that cluster members who can not access the 
replicator can not execute data-changing queries locally).

>
> -Matthew
>
> Rick Vernam wrote:
> > On Friday 07 September 2007 03:01:25 pm Matthew wrote:
> >> Is there a way to replicate just a specific database/schema in
> >> pgcluster?
> >>
> >> Is there any sort of name transformation possible either? For example,
> >> on our dev databases, we may call a particular DB 'mystuff_dev' but on
> >> the prod machine it may be called 'mystuff'.
> >
> > Nope, nothing.
> >
> >> Thanks,
> >> Matthew
> >> _______________________________________________
> >> Pgcluster-general mailing list
> >> Pgcluster-general at pgfoundry.org
> >> http://pgfoundry.org/mailman/listinfo/pgcluster-general
> >
> > _______________________________________________
> > Pgcluster-general mailing list
> > Pgcluster-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general