Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UPwXz-0001Ua-9N for pgsql-admin@arkaria.postgresql.org; Wed, 10 Apr 2013 15:02:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UPwXy-0006Yj-QD for pgsql-admin@arkaria.postgresql.org; Wed, 10 Apr 2013 15:02:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UPtNB-0003gE-4d for pgsql-admin@postgresql.org; Wed, 10 Apr 2013 11:39:29 +0000 Received: from md-17.webhostbox.net ([208.91.198.74]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UPtMx-0003WC-Ve for pgsql-admin@postgresql.org; Wed, 10 Apr 2013 11:39:28 +0000 Received: from mailnull by md-17.webhostbox.net with sa-checked (Exim 4.77) (envelope-from ) id 1UPtMv-000cNX-Kl for pgsql-admin@postgresql.org; Wed, 10 Apr 2013 11:39:13 +0000 Received: from [123.201.39.75] (port=52579 helo=[192.168.0.100]) by md-17.webhostbox.net with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.77) (envelope-from ) id 1UPtMu-000c5S-RC for pgsql-admin@postgresql.org; Wed, 10 Apr 2013 11:39:13 +0000 Message-ID: <51654F60.5070205@postgresdba.net> Date: Wed, 10 Apr 2013 17:09:12 +0530 From: Prashanth Ranjalkar User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130328 Thunderbird/17.0.5 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Log shipping /Streaming replication between different postgres rpm's References: <51652447.0202cd0a.712a.ffffcdd9SMTPIN_ADDED_BROKEN@mx.google.com> In-Reply-To: <51652447.0202cd0a.712a.ffffcdd9SMTPIN_ADDED_BROKEN@mx.google.com> Content-Type: multipart/alternative; boundary="------------080303040906070605090006" X-Spam-Checker-Version: spamc_ctasd client on localost X-Spam-Level: X-Spam-Status: No, score=0.0 required=50.0 tests=SpamClass_Unknown, VirusClass_Unknown autolearn=disabled version=1.0.0 X-CTCH-PVer: 0000001 X-CTCH-Spam: Unknown X-CTCH-VOD: Unknown X-CTCH-Flags: 0 X-CTCH-RefID: str=0001.0A020202.51654F61.027B, ss=1, re=0.000, recu=0.000, reip=0.000, cl=1, cld=1, fgs=0 X-CTCH-Score: 0.000 X-CTCH-ScoreCust: 0.000 X-CTCH-Rules: X-CTCH-SenderID: prashanth.ranjalkar@postgresdba.net X-CTCH-SenderID-Flags: 0 X-CTCH-SenderID-TotalMessages: 1 X-CTCH-SenderID-TotalSpam: 0 X-CTCH-SenderID-TotalSuspected: 0 X-CTCH-SenderID-TotalConfirmed: 0 X-CTCH-SenderID-TotalBulk: 0 X-CTCH-SenderID-TotalVirus: 0 X-CTCH-SenderID-TotalRecipients: 0 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - md-17.webhostbox.net X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - postgresdba.net X-Source: X-Source-Args: X-Source-Dir: X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------080303040906070605090006 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 10-04-2013 13:58, Herman Pool wrote: > > All, > > We have to migrate to a new hardware infrastructure and we want to use > a Postgres version of EnterpriseDB in the new hardware infrastructure. > On the old infrastructure, postgres comes from postgresql.org > The version of postgres on the old and new infrastructure is the same, > 9.1 (old 9.1.5 and new 9.1.9) > All the directories, filesystems, tablespaces etc are the same on the > old and new infrastructure. > Is it possible to do log shipping /streaming replication between the > old and the new infrastructure? > > > > > > With regards, > > Herman > Yes, the log shipping/streaming replication is possible between these versions as the major versions are same i.e 9.1.X Thanks & Regards, Prashanth Ranjalkar Database Consultant & Architect Skype:prashanth.ranjalkar www.postgresdba.net --------------080303040906070605090006 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
On 10-04-2013 13:58, Herman Pool wrote:

All,

We have to migrate to a new hardware infrastructure and we want to use a Postgres version of EnterpriseDB in the new hardware infrastructure.
On the old infrastructure, postgres comes from postgresql.org
The version of postgres on the old and new infrastructure is the same, 9.1 (old 9.1.5 and new 9.1.9)
All the directories, filesystems, tablespaces etc are the same on the old and new infrastructure.
Is it possible to do log shipping /streaming replication between the old and the new infrastructure?





With regards,

Herman


Yes, the log shipping/streaming replication is possible between these versions as the major versions are same i.e 9.1.X



Thanks & Regards,
Prashanth Ranjalkar
Database Consultant & Architect
Skype:prashanth.ranjalkar
www.postgresdba.net
--------------080303040906070605090006--