Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 07AFA9FB374 for ; Thu, 12 Apr 2007 21:50:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01824-08 for ; Thu, 12 Apr 2007 21:50:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id 5CEF89FB3E2 for ; Thu, 12 Apr 2007 21:50:51 -0300 (ADT) Received: (qmail 23638 invoked from network); 13 Apr 2007 00:50:49 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;6e3f1f2e93b97e20fddbc5d6dc9788cd; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 13 Apr 2007 00:50:48 -0000 Received: (qmail 24837 invoked by uid 1166); 13 Apr 2007 10:50:45 +1000 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.556648 secs); 13 Apr 2007 00:50:45 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.556648 secs Process 24825) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 13 Apr 2007 10:50:43 +1000 From: "Phillip Smith" To: "'Karthikeyan Sundaram'" , , Subject: Re: [SQL] setting up a mirroring or replication database Date: Fri, 13 Apr 2007 10:50:35 +1000 Organization: Weatherbeeta Pty Ptd Message-ID: <00da01c77d65$bf725ae0$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00DB_01C77DB9.911E6AE0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 In-Reply-To: Importance: Normal X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1176425448.875-23622-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.05/0.39 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/127 X-Sequence-Number: 25191 This is a multi-part message in MIME format. ------=_NextPart_000_00DB_01C77DB9.911E6AE0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable This may best be asked in the admin group - please don't cross-post. = Let's keep all further discussion in the admin group. =20 A good starting place for you would be the PostgreSQL manual, = specifically the chapter called "High Availability": http://www.postgresql.org/docs/current/interactive/high-availability.html= . also Pgpool: http://pgfoundry.org/projects/pgpool/ . and Slony: http://slony.info/ =20 Cheers, ~p =20 -----Original Message----- From: pgsql-sql-owner@postgresql.org = [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Karthikeyan Sundaram Sent: Friday, 13 April 2007 10:39 To: pgsql-admin@postgresql.org; pgsql-sql@postgresql.org Subject: [SQL] setting up a mirroring or replication database =20 Hi Team, =20 We are using Postgres 8.1.0 and in the plans to migrate to 8.2.3. = Ours is a OLTP application. Publishers, advertisers and consumers use our = system world wide. Right now it's not a very big database. But we are = expanding our operations to Europe and US where we are expecting a moster growth. =20 I want to setup a mirroring database or replications database so = that if one database crash, the load balancing database should take care or it. = Not only that, if I am upgrading one database, the other should take the = load.=20 =20 I have never set this kind of replication or mirroring the database before. What are the steps and procedures to do this kind of setup. =20 Please advise. =20 Regards skarthi =20 _____ =20 Live Search Maps - find all the local information you need, right when = you need it. Find it! =0A*******************Confidentiality and Privilege Notice*******************= =0A=0AThe material contained in this message is privileged and confidential to= =0Athe addressee. If you are not the addressee indicated in this message or= =0Aresponsible for delivery of the message to such person, you may not copy=0Aor= deliver this message to anyone, and you should destroy it and kindly=0Anotify= the sender by reply email.=0A=0AInformation in this message that does not relat= e to the official business=0Aof Weatherbeeta must be treated as neither given = nor endorsed by Weatherbeeta.=0AWeatherbeeta, its employees, contractors or as= sociates shall not be liable=0Afor direct, indirect or consequential loss aris= ing from transmission of this=0Amessage or any attachments=0A ------=_NextPart_000_00DB_01C77DB9.911E6AE0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

This may best be asked in the admin = group – please don’t cross-post. Let’s keep all further discussion = in the admin group.

 

A good starting place for you would = be the PostgreSQL manual, specifically the chapter called “High = Availability”:

http://www.postgresql.org/docs/current/interactive/high-availab= ility.html

… also = Pgpool:

      =       http://pgfoundry.org/proje= cts/pgpool/

… and = Slony:

      =       http://slony.info/

 

Cheers,

~p

 

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] = On Behalf Of Karthikeyan = Sundaram
Sent: Friday, 13 April = 2007 10:39
To: = pgsql-admin@postgresql.org; pgsql-sql@postgresql.org
Subject: [SQL] setting up = a mirroring or replication database

 

Hi Team,
 
    We are using Postgres 8.1.0 and in the plans to = migrate to 8.2.3.   Ours is a OLTP application.  Publishers, = advertisers and consumers use our system world wide.  Right now it's not a very = big database. But we are expanding our operations to Europe and US where we are expecting a moster growth.
 
    I want to setup a mirroring database or replications database so that if one database crash, the load balancing database = should take care or it.  Not only that, if I am upgrading one database, the = other should take the load.
 
    I have never set this kind of replication or = mirroring the database before.  What are the steps and procedures to do this kind = of setup.
 
   Please advise.
 
Regards
skarthi

 

Live Search Maps – = find all the local information you need, right when you need it. Find it!


=

=0A*******************Confidentiality and Privilege Notice*************= ******=0A

=0AThe material contained in this message is privileged and conf= idential to=0Athe addressee. If you are not the addressee indicated in this m= essage or=0Aresponsible for delivery of the message to such person, you may no= t copy=0Aor deliver this message to anyone, and you should destroy it and kind= ly=0Anotify the sender by reply email.=0A

=0AInformation in this message that do= es not relate to the official business=0Aof Weatherbeeta must be treated as ne= ither given nor endorsed by Weatherbeeta.=0AWeatherbeeta, its employees, contr= actors or associates shall not be liable=0Afor direct, indirect or consequenti= al loss arising from transmission of this=0Amessage or any attachments=0A
= ------=_NextPart_000_00DB_01C77DB9.911E6AE0--