slaves should match the table structure
on master.
> That is, do you replicate a physical table image
> (maybe not including transaction ids on master) ?
Yes, we call this 'full dump', and it is fired automatically for every
replicated table. We replicate only data however, not DDL comman
or
> > > do you apply the changes at some lower level ?
> >
> > We replicate the binary data along with a command type. Only the data
> > necessary to replay the command on a slave are replicated.
>
> Do you replay it as SQL insert/update/delete comm
Marko Kreen wrote:
> On 10/11/07, Alexey Klyukin <[EMAIL PROTECTED]> wrote:
> > Hannu Krosing wrote:
> > > For what use cases do you think your WAL-based approach is better than
> > > Slony/Skytools trigger-based one ?
> >
> > A pure trigger based appr
eplicate data for the commands
which fire triggers. AFAIK Slony is unable to replicate TRUNCATE
command (I don't know if Skytools can). Replicator doesn't have this
limitation.
Regards,
--
Alexey Klyukin http://www.commandprompt.com/
The Po
ed a version which applies (or applied to the cvs head
at the time of post) cleanly there:
http://archives.postgresql.org/pgsql-patches/2007-06/msg00204.php
>
> 2. Support to sort the heap tuples represented by one index tuple, in
> normal index scans, if we go with alternative
ons on reviewing the GIT patch ?
Regards,
--
Alexey Klyukin http://www.commandprompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your de
from
> the main cvs repository?
>
> kind regards,
> Hannes Eder
>
> Footnotes:
> [1] http://subversion.tigris.org/svn_1.4_releasenotes.html#svnsync
> [2] http://projects.commandprompt.com/public/pgsql/repo/
>
Regards,
--
Alexey Klyukin
mit I haven't tried.
I have tried and svn up worked without issues.
Regards,
--
Alexey Klyukin [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://projects.commandprompt.com/public/pgsql/browser
or do the anonymous checkout with:
svn co http://projects.commandprompt.com/public/pgsql/repo/
Regards,
--
Alexey Klyukin [EMAIL PROTECTED]
---(end of broadcast)
Jeremy Drake wrote:
On Thu, 26 Oct 2006, Alvaro Herrera wrote:
Jeff Trout wrote:
On Oct 26, 2006, at 3:23 PM, Martijn van Oosterhout wrote:
On Thu, Oct 26, 2006 at 03:15:00PM -0400, Andrew Dunstan wrote:
Perhaps people who use other platforms could look for these fla
Hi,
A typo:
("a write to any server has to be _propogated_")
s/propogated/propagated
Bruce Momjian wrote:
Here is a new replication documentation section I want to add for 8.2:
ftp://momjian.us/pub/postgresql/mypatches/replication
Comments welcomed.
--
Regards,
Alex
101 - 111 of 111 matches
Mail list logo