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 1kaHR6-0006W2-Vs for pgsql-admin@arkaria.postgresql.org; Wed, 04 Nov 2020 11:58:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kaHR4-0005vm-7p for pgsql-admin@arkaria.postgresql.org; Wed, 04 Nov 2020 11:58:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kaHR3-0005v7-TN for pgsql-admin@lists.postgresql.org; Wed, 04 Nov 2020 11:58:42 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kaHQz-0007CR-9y for pgsql-admin@lists.postgresql.org; Wed, 04 Nov 2020 11:58:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1604491114; bh=bj+N2k8A9UfGyg3pQISCz51Ggcw6NkKkZ/mGEl0W21c=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=bC36O43r3fmDVTZX78kxJKSYsH5XQH0+1lgqluy9i2JWfK9ezyGagj2R0s4A6ZpgX mula8XaoAiX8NL/5sUH+rJhy0vGFRzo6JkYnVkRG9bb+8739Rz4+EYNZ0j4kG+wiFo XG/6uHzRVebF6PIGqY1RubnLtDUBBnCQEBhegUf4= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [10.1.34.180] ([185.40.248.10]) by mail.gmx.com (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MS3il-1kl72X2cah-00TUix for ; Wed, 04 Nov 2020 12:58:34 +0100 Subject: Re: Logical replication alternative To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <998fc693-ca58-ae60-b082-45de80a78b19@gmx.net> Date: Wed, 4 Nov 2020 12:58:33 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:emfNLiOpg8R126GieNV2JEkzdRQsdAynFP97d8muA3Ckon65TTs 4RRiz2/kvUCdjSVqK8Ui9nzG2vJKUBETD9HBKRprB7hYv6BdSzzl96KeDtFGpQhvuwSAM0t lM4foLtJWz0mWKTpPfiDr9TLPwulS995pgahY6B76LYjEzRonAJ0V4JHv1X6WSlIbAZRkQw x+kBChSS3S5gTBL5WSoKg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:sCB2pk2apqQ=:IoTSyi/aYNTYSkp/1jgAdY w62ArDC9qWGUihBFlc26lWLNBM3VjUEIy8/jK6aIIV23RIcbChDMMPa8Uk7p49Jr9PVX34HM9 t5dKcT36u0gtehC/iMMyfwmKlamllxHzI8h7lI1uSw9ypyRxOVFFnfjuT/6AwVQKi1h0Zq6IK 3OGAbAQE+uxuUdpz0VkNslvsjg0N+t3oTMNjoMISMcFRNn5Vi7mlUhsB9JMF8Z+oXvZhHBJSF m4IJevvz5F4B7jYHCt9srXVYcxejK8UZ0X3AECNVru4r0qmcEG0F9juvM7I9mehKrzBWRugt+ At0V0BuTkGt86ROt/8zBPL6a1fAI1z/UvCKrMaw4iGrNW05jtYJNqWFhdJPoOfNuwFG9Ixv3r qNc64ndXNARo+WoM5BSSPH2VpdjibBvmqDYbgWZID5ucdppm/F72/LLudws4gCtltFBXIPrZB MObP4SqeRcv0DnKUkQiuCRFEuHUpkFGRU0+xaAGXDRo9GEWdL8cO0V6KqsoXf97pc7HKjZ5aR 65a9BTGWA7DaEqK30UYyl38ozCkyyRm+GpEue/g1NoB++Q9E1kWLHhDhh/302hQTFrU31pTqB +DTWudFC5uffQBHRCxF4Gmr38/dijjrEAOagjsw+ESj1R+JjH9U8fGDmenG2QBbsxl6CLRLGe YLdHze9vWJchQ/nwoi5kT94Y4ZF3vw7svVe4FYS7h+zlG9FMm7RcTNsRVv/ZHV3hoYXWt/rOc /4+imxKWh5cSQgLnZs+AwGwiZZCEQxnrtZrtPvRRJQnyKDFmGc/E0BXaGbZeNX9G4g9jb5GVP 4LdbuJtLf1YkaCcXh0bqxpt026jlxvEbeuFv0VO1i0cPj5f3hNB3rhJzrPdtSyHJ5oukaQbXW KQDz8QTSm/GhocKeje1w== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Yambu schrieb am 04.11.2020 um 11:55: > May i know what is the alternative to logical replication if i want > to replicate a few tables on postgres v10? What about using foreign tables? Then no replication would be required. If that is to slow, you could create a materialized view on the "secondary" server that is based on the foreign tables. You can refresh the MVIEW multiple times a day. The downside is that this isn't incremental, you would always copy all the data. Thomas