Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Constant WAL replay

  • From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
  • To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
  • Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>, pgsql-hackers(at)postgresql(dot)org, eg(at)cybertec(dot)at
  • Subject: Re: Constant WAL replay
  • Date: Sun, 24 Apr 2005 17:06:00 -0700
  • Message-id: <426C3468(dot)7090805(at)commandprompt(dot)com>

Very close. We don't use the WAL (yet, slated for probably 8.1) but we
do use a transaction log shipping method. So the implementation is almost the same. 


Can you run queries on the slave?  If so, how do you handle xid collisions?
You can run any query that does not modify data on a replicated table. You can run any non data modifying query on any of the tables. 

Sincerely,

Joshua D. Drake
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group