Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l0RmZ-0000yx-CU for pgsql-admin@arkaria.postgresql.org; Fri, 15 Jan 2021 16:17:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l0RmY-0003KY-Bx for pgsql-admin@arkaria.postgresql.org; Fri, 15 Jan 2021 16:17:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l0RmX-0003KF-TZ for pgsql-admin@lists.postgresql.org; Fri, 15 Jan 2021 16:17:02 +0000 Received: from mail-ed1-x52c.google.com ([2a00:1450:4864:20::52c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l0RmR-0002bg-0q for pgsql-admin@postgresql.org; Fri, 15 Jan 2021 16:17:01 +0000 Received: by mail-ed1-x52c.google.com with SMTP id by27so10100841edb.10 for ; Fri, 15 Jan 2021 08:16:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=1w+TuJkcuRzh5+EVEDlJ4aL3Zsk3BBex038Y9JP6LwY=; b=OrAxQebPhA3PwgJ3nfD+QdzLmZhdjTT4Afz0/jjptSXd3fDgB2SGx6gCQnqsibBaEV Tsd/LhZtVH0JNnZaPYZW6ZItY2iy9H3qGShaAi5gUm0h7/cJNNeTFsdD7BWXk4duEqh0 +jURIcLeOeHSav/6yHmfo/DsVvBbqQxLwnMVdxnoNtVvyMiO3O2YuSwvY0MoZjC9ncXk CIQKXY//Qofi5Aw7C3oH89AGWtmhYohcM01ULrFSdDkE4fkwUHWoS7XCWbeK2bIn1Z3n QH6zmg230ohIm7gntfnGVlMSSDUxouqLCXIEOKDermCgGlwTs/8gy1OcqpwCYGOh5o05 b/5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=1w+TuJkcuRzh5+EVEDlJ4aL3Zsk3BBex038Y9JP6LwY=; b=d2u915z7oHHazgJHyXq6b0lUg5ntGtsloHe2Ff4QnOHcEWAozK4w189yQtM5fZgM5X iDlvCOe3xiC1joqP7tvHpxrSPsm+Sjd0nITi6e0JbMd3ZhOpUBFnKaJTF9jsltqyBks0 mdq5Tv/JkXdMHx2d6O+H0YiDlOCPPfD5BByUnzj/eOrkYXnYrFeE5bynsKZ0wIOZUYfh DVTR1um9gVKIeyEzm78YerWglSkerOm8HTKvetU/dJFKN+ti2bgMBxA/K/t4lH1cElif TMp8zeK2doWw8we5XadFmLA8ZMl5PBGnTZOf/YapwGx0ugSCW78kF3YPtm1fPuM6UxmC LuBw== X-Gm-Message-State: AOAM531CwEwUf6+UbjtsHGTpCzhklI1virJ+NhCxAtZeuDRLz90mwvMh HVuPUW3lBPf7KKQljsc8QdPkgQ== X-Google-Smtp-Source: ABdhPJyg886Ng2ZdqnLrzdVeUwuKtS4n9ielAdDbjaKic0FDFJlhPV5kUrVAux4ROv9tcSgngunrhA== X-Received: by 2002:a05:6402:1f4:: with SMTP id i20mr8376148edy.180.1610727413414; Fri, 15 Jan 2021 08:16:53 -0800 (PST) Received: from localhost.localdomain (217-149-170-31.nat.highway.telekom.at. [217.149.170.31]) by smtp.gmail.com with ESMTPSA id i15sm3856993ejj.28.2021.01.15.08.16.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 15 Jan 2021 08:16:52 -0800 (PST) Message-ID: <329c80b2c243aaba51de0044313f0bd3f806cec3.camel@cybertec.at> Subject: Re: streaming replication between postgres and enterprisedb From: Laurenz Albe To: Atul Kumar , pgsql-admin Date: Fri, 15 Jan 2021 17:16:51 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, 2021-01-15 at 18:38 +0530, Atul Kumar wrote: > Please help me in knowing that can we configure streaming replication > between one postgres server (9.5) as master and one enterprisedb > server(10) as slave ? > > As I wanted to migrate the data from postgres 9.5 to enterprisedb 10, > So I thought Streaming replication may be helpful. > > Or Do we any other option to migrate data from postgres 9.5 to enterprisedb 10. Streaming replicatoin cannot do that, and logical replication is not supported before v10. You could use old tools like Slony. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com