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 1jZEP4-0007fV-Rn for pgsql-admin@arkaria.postgresql.org; Thu, 14 May 2020 14:00: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 1jZEP1-0000sj-Ed for pgsql-admin@arkaria.postgresql.org; Thu, 14 May 2020 13:59:59 +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 1jZEP0-0000sb-Us for pgsql-admin@lists.postgresql.org; Thu, 14 May 2020 13:59:59 +0000 Received: from mail-eopbgr60054.outbound.protection.outlook.com ([40.107.6.54] helo=EUR04-DB3-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jZEOx-0007Xw-W1 for pgsql-admin@postgresql.org; Thu, 14 May 2020 13:59:58 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=GUac2akNlQYYjASLNd7EWk7BqWivzWjL3vie6lAJUsUZOe43/6LNM7YjlZbahAznJ8kcgWGqbC7fD/81uQfVIPno8++hqx34qbO6v/25TwjNF8cxL7MkOS0F12Xtjig/wNK35QMsobIWMcMblJQKT3ivxifd5ED5lsDk4tDGJhH3RAeom1KKtB56lRCi9Y5UlUjHlLH6jVGTKEPHyUSZUsjX2jCoMexz93KN15nLipZuNe/o5SZjmX1+OoL4JtBNe4Y2VQ6tucLlGuRGSZ7UecQZQ/nB/XZsmuzkzQkThGM/tzcCXH+hKyEqHdnXCPFOQlAL0mWMi07FqvP2mIwsBA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=fwmS2RF+zHs2jAypuDWGnkWf+2LLgDHWyde/RcFWQZo=; b=A4YRK0dVBIpLaTx4dyArLKUQ4r+msHyls1rGjyikg/fOeK2tvvjlneatfYxWm/YGppAhlHp+aHSRCiwRDaeZ+7P1S3jr+s8JOm3byGukzpIxZbYgdLwQT2zEQBdU4xIk065PD4owarf7AC6/AaZRG9VeUgoECrFlWmAv+nu8j6ZSRHjbf6+V97JYCy24AzXdWLpWDo+/gdhASDSp1vqUnTwuJz16fBm3ygwlte2WXoLQPaoeLBgIvCE3drKOGe5SqrJV1jlrPf2calmhKnIhED2QgjxQgs+tW/gAyb6f5ZIco4aYZBZ28pe2vcgq+BHzaoVn7Vm2HkXc6CH/a6hBUQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucll.be; dmarc=pass action=none header.from=ucll.be; dkim=pass header.d=ucll.be; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucll.be; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=fwmS2RF+zHs2jAypuDWGnkWf+2LLgDHWyde/RcFWQZo=; b=fNEr1/plgXf7KHoAKCLWQkD934/HCOeS1Holq6jyhP2eF5o59dWlaP2MuYZ+7DJ8Ts7chO5e4OTTeX7BzyOWoVUDhg0hjFo7Cf/7YBdnHMJnrfMKwOY03Q5Zm0QoHbKkOLe0mO8xfSX/NMIlH0GfPtusV8Blx76r0zv3d7IlTOY= Authentication-Results: crunchydata.com; dkim=none (message not signed) header.d=none;crunchydata.com; dmarc=none action=none header.from=ucll.be; Received: from AM0P195MB0324.EURP195.PROD.OUTLOOK.COM (2603:10a6:208:b3::30) by AM0P195MB0643.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:169::18) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3000.20; Thu, 14 May 2020 13:59:53 +0000 Received: from AM0P195MB0324.EURP195.PROD.OUTLOOK.COM ([fe80::54b6:3cdc:b493:6760]) by AM0P195MB0324.EURP195.PROD.OUTLOOK.COM ([fe80::54b6:3cdc:b493:6760%7]) with mapi id 15.20.3000.016; Thu, 14 May 2020 13:59:53 +0000 Message-ID: <562890eff48a048d4b09d23f76506fceb867a31f.camel@ucll.be> Subject: Re: viewing connectioninfo used by subscriber on the publication server when inactive From: Wim Bertels Reply-To: wim.bertels@ucll.be To: Keith Fiske Cc: pgsql-admin Date: Thu, 14 May 2020 15:59:53 +0200 In-Reply-To: References: <25037dc66dadcdd61148f6d59208217441abfd80.camel@ucll.be> <5f77a6c973aaf8f9086cf42933f476e5bd9a948d.camel@ucll.be> Organization: UC Leuven-Limburg Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.30.5-1.1 Content-Transfer-Encoding: 7bit X-ClientProxiedBy: AM0PR04CA0048.eurprd04.prod.outlook.com (2603:10a6:208:1::25) To AM0P195MB0324.EURP195.PROD.OUTLOOK.COM (2603:10a6:208:b3::30) MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from ptr-7u36h5k51lesqlynxiz.18120a2.ip6.access.telenet.be (2a02:1811:526:1700:60e:3cff:feb0:7f7b) by AM0PR04CA0048.eurprd04.prod.outlook.com (2603:10a6:208:1::25) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3000.20 via Frontend Transport; Thu, 14 May 2020 13:59:53 +0000 X-Originating-IP: [2a02:1811:526:1700:60e:3cff:feb0:7f7b] X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 5bc136af-d246-4268-85ba-08d7f80f13db X-MS-TrafficTypeDiagnostic: AM0P195MB0643: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:9508; X-Forefront-PRVS: 040359335D X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: R8LApRPw47CFPqBCXB0y7d0qtVRVA/LDLmHSLwZo8f/5OA3L1N9kOlgW3QKy6YRbqru2r1kJLpOhin5xCrkg45MvKy69t0UAMnH25i3xuW88o7o51Ek9UMsWKQhZYWM+vUxpdISijVrhXx7u0qUD8xh+NOBmmkhzDhpLmFEG8xKgAbIP2mLOs2TgtSRt+nNYjZG/ubgx6kW0Gl9YiDXa+mvUrv3NJnZk+1Qk//i+pBD407OXMbrAAuUyTnZ2GbDgMWYtwx25Ih9oZ2mof/1NSM0HN4m5jk7eK4SEMFxsUoCIRhNQwGxWBmBBxHPZDmfth+O3oiihlBFgBZh5GdkC+oRZyDDS50wJ12uIqLwM68rp7/bti7EN/trqAu69O4TAZm5OLgMO9jB4U4sg/LT0yKaJjK9K4ACNwIZd3ISWei2V1k+PhscY1ZOjQzuweA8t X-Forefront-Antispam-Report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM0P195MB0324.EURP195.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFTY:;SFS:(4636009)(136003)(366004)(346002)(39850400004)(396003)(376002)(186003)(2906002)(16526019)(6486002)(36756003)(52116002)(316002)(786003)(478600001)(6916009)(3450700001)(6506007)(44832011)(8936002)(6512007)(36916002)(8676002)(86362001)(4744005)(66946007)(66556008)(2616005)(5660300002)(4326008)(66476007);DIR:OUT;SFP:1101; X-MS-Exchange-AntiSpam-MessageData: XBiQlL7KDzoUMPa2M2Wpd7RignZ+u8ccyVsMZ8xCoprHeTAevZsqyMd27qn4gAS00hT6ONbNc78tDM7EAXRGtB2d1oLCxIpiNoIV1ony+ME6HCYNlat+kK2EVeBS6YcjoVsOUH3NLHxztOVYYr8mO1mNaiQAOYT7TpVp1n1oXUfMhXMJR1J1lGAHGnEi6TflYCKITxuF/Mix358jwyP4s6v6q/OMoyqB65yJildT2i1OnWzziqOpYpHXHjIcPuAKSTA5qPkk77nR3iutIX8RTkeUPL3VEwKifdiLbJ7dD+CSk93LwV0BdFUpZOLWjYtxONgAWkzOMYYDur6znxC+6VGsLCWqzwZHRhxnZrayenXA9/i6Gj95r1E8fb5Gkx7PYHArtlAy/xqrQRTx8XE5JyanItUwCSyQQmjq++ILRzffdR7jYIjAGpiJKZGCLp+tH9kHFf5W5B2K+aXHm+hTX2Hm/tZeFLZ381y2CwK8s05zKvamOe65qkqpTCPbs9rxqV3UpPuAPgb4tnvX6Xyx+QttJvpL1Yd59RW2T8nVtr8= X-OriginatorOrg: ucll.be X-MS-Exchange-CrossTenant-Network-Message-Id: 5bc136af-d246-4268-85ba-08d7f80f13db X-MS-Exchange-CrossTenant-OriginalArrivalTime: 14 May 2020 13:59:53.9195 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: e638861b-15d9-4de6-a65d-b48789ae1f08 X-MS-Exchange-CrossTenant-MailboxType: HOSTED X-MS-Exchange-CrossTenant-UserPrincipalName: z+gTaTQcfO7Efr1rKz3Chv8I9XBt9vqeW2K45s5q6lvcoFi9kGr1AyuKcvx7hVg9h2PEEopaDII5bTZw3PlUEA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0P195MB0643 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > period of time, especially if the publisher is continuing to write. I > would question the design of this that is allowing the subscribers to > be offline. You may want to rethink this design a bit. That is another aspect, to achieve a goal there generally more options, but not my question. In this case: a small dataset with little changes over time is used, (so the overhead in storage should be little) ; as this seems an easy introduction exercise to replication for the students who are not always online. So they see what happens, always more appealing that just talking about it. Just to be clear, not this case: a setup for a company > -- mvg, Wim -- Kindness is a language which the deaf can hear and the blind can read. -- Mark Twain