Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!weretis.net!feeder4.news.weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: posygresql and hot stand by Date: Tue, 29 Mar 2011 19:08:17 +0000 (UTC) Organization: solani.org Lines: 14 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1301425697 7301 eJwFwQkBwDAIA0BLA8Inh5bGv4TduYXETYQHnM6pTCzPZYOkX2nM7LRiq1ZVHwRhdr6XsfwBNAURoA== (29 Mar 2011 19:08:17 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Tue, 29 Mar 2011 19:08:17 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwFwYEBwCAIA7CX2gFlO0em/f8EkwpRf6dKWS73SARyUHzwjo/MRSRZXrYO/cXhDky79wUJXBDq Cancel-Lock: sha1:8F13FmGH/o+TAtBgz68STCPF7mY= X-NNTP-Posting-Host: eJwFwYEBwCAIA7CXBNqK50yQ/09YwpCpNkSBw9FlONwmX+U9Y2CGN5qK93ntxXXMMd2GSv4LrxBy Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:60 On Tue, 29 Mar 2011 13:35:39 +0200, hitan wrote: > thanks, but already use Slony, I wanted to replicate with native > postgresql Native PostgreSQL replication is WAL archive based. The archives are transferred to the replica node and the database cluster there is the exact replica of the original. It's not SQL based, that's why it's much faster than the SQL based methods like Slony. -- http://mgogala.byethost5.com