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 1jRV82-00010B-JU for pgsql-admin@arkaria.postgresql.org; Thu, 23 Apr 2020 06:14:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jRV80-0002lp-Mo for pgsql-admin@arkaria.postgresql.org; Thu, 23 Apr 2020 06:14:28 +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 1jRV80-0002kk-4I for pgsql-admin@lists.postgresql.org; Thu, 23 Apr 2020 06:14:28 +0000 Received: from mail-am6eur05on2133.outbound.protection.outlook.com ([40.107.22.133] helo=EUR05-AM6-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 1jRV7w-0000AN-8U for pgsql-admin@lists.postgresql.org; Thu, 23 Apr 2020 06:14:27 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=kupCFmWB2pnaQyzMthY+Lywq0rrlQ5kMSl51n8CP2R0AZpmaaz1obaqgGbgZjEsm+VgECWV+bI3f2a3WpCE7HfpwEOpHIWr1oA9neS1HxZcguaAsNUC3RK8BEUYSgz9MRsR5INtrPCwKv2iAfT4LHeuOkPQa8gnpJ4KNov0wJt/d9gwcEHhnVGI/6mnxQIvnPQTHeMRFHDu9VzysGY+2MKrR1Y+zihviZw4fm9lphG0E5tV9nMhe24LpvEVPluwEXVJceTj8rm1NnQcCMSHKl1vyEavqYemDVSb3ckewSKQfMja6Cv/pu6dC6RkinepXGzTiCkUnxeVN021s/BeUcg== 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=2MZ12fnaEwmNAIvXuEbfP7QqAW5pZZ3zMl8QQEtI6b4=; b=O6B6ZIBHZh55OJEsD2eP/+KOdqkMGdr+UA5kpWUn2BiF0tbewK8CAKatGmFdlJ+RCh+oQXo54YCE3OD0H2euggiJYYhXLmL+3biwevIHFEyCFwuDOV+rV4SAhi+uwwBeq2CrDIht0vSY9nydtEijMpz61CBirNeVcgxaGBQqSKYRnh4dY+lnevEp0Ww7VWwtGmmoEtcZpIWWQx2d1qbpQm9yzd3lYwd9BPYuEyjHDpkdqNcr27rhP2jT+Lz7jRrwKxptn1tngc4eRCJAv0ONQS+NWABOn2Ov1AgMGvwY41Y73DFBYJvLbxiAtgr54irk/KNXn/gZReiApENMSDa+QA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=accelaero.com; dmarc=pass action=none header.from=accelaero.com; dkim=pass header.d=accelaero.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=accelaero.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=2MZ12fnaEwmNAIvXuEbfP7QqAW5pZZ3zMl8QQEtI6b4=; b=quYEZ8BaQZsOckd0icYExJrSLVmPwF+GpxBD0m7BA6iyJtbnEU5j9XJavTuDQKcDQ4CtuFCBtfknTfpq0uZC5/g9H4AdyniiuwaMLu8118a027KDdIVBDqrP4mrPr6yQQx7v9F8E09uwhoyvmDoparv0dfQhtQc648jjMyxvPXs= Received: from AM0P191MB0708.EURP191.PROD.OUTLOOK.COM (2603:10a6:20b:153::8) by AM0P191MB0706.EURP191.PROD.OUTLOOK.COM (2603:10a6:20b:154::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2937.13; Thu, 23 Apr 2020 06:14:21 +0000 Received: from AM0P191MB0708.EURP191.PROD.OUTLOOK.COM ([fe80::543:76b5:fb40:eda9]) by AM0P191MB0708.EURP191.PROD.OUTLOOK.COM ([fe80::543:76b5:fb40:eda9%2]) with mapi id 15.20.2937.012; Thu, 23 Apr 2020 06:14:21 +0000 From: Ashok kumar Mani To: "'pgsql-admin@postgresql.org'" , "'pgsql-admin@lists.postgresql.org'" Subject: Help needed for replication issue Thread-Topic: Help needed for replication issue Thread-Index: AdYZMmWwUBnVUTR6QkCgUVG5dRzvNQ== Date: Thu, 23 Apr 2020 06:14:21 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_e786b395-434b-40ce-b5e6-fd56d1f0fd4d_Enabled=True; MSIP_Label_e786b395-434b-40ce-b5e6-fd56d1f0fd4d_SiteId=7bbb8a4d-7f1b-4a58-9b3a-c250fb8023e3; MSIP_Label_e786b395-434b-40ce-b5e6-fd56d1f0fd4d_Owner=amani@accelaero.com; MSIP_Label_e786b395-434b-40ce-b5e6-fd56d1f0fd4d_SetDate=2020-04-23T06:14:30.5198074Z; MSIP_Label_e786b395-434b-40ce-b5e6-fd56d1f0fd4d_Name=Internal - General; MSIP_Label_e786b395-434b-40ce-b5e6-fd56d1f0fd4d_Application=Microsoft Azure Information Protection; MSIP_Label_e786b395-434b-40ce-b5e6-fd56d1f0fd4d_ActionId=fcd25e3d-ff8b-4951-bf51-9a1d55a5f45d; MSIP_Label_e786b395-434b-40ce-b5e6-fd56d1f0fd4d_Extended_MSFT_Method=Manual authentication-results: spf=none (sender IP is ) smtp.mailfrom=amani@accelaero.com; x-originating-ip: [5.107.220.205] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: f5fd2e5a-37c3-4c60-0d58-08d7e74d9080 x-ms-traffictypediagnostic: AM0P191MB0706: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:8273; x-forefront-prvs: 03827AF76E x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM0P191MB0708.EURP191.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFTY:;SFS:(4636009)(396003)(39850400004)(366004)(376002)(346002)(136003)(6506007)(66946007)(26005)(52536014)(186003)(76116006)(9686003)(2906002)(8676002)(478600001)(66446008)(66556008)(64756008)(71200400001)(55016002)(33656002)(5660300002)(86362001)(4744005)(8936002)(110136005)(66476007)(316002)(7696005)(81156014)(491001);DIR:OUT;SFP:1102; received-spf: None (protection.outlook.com: accelaero.com does not designate permitted sender hosts) x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: E68wjz2VJob3jl8yWMqHLjIwezrpZkgkaRro3l+WUamuclpB5dUrig8vqBP70EKjWDpVPjrbiBm4TCnPQiohUfC7Iik0Sfm2K4bEhaPvEcLbXVoHNJ9OVp5Hi8+o1WAuzkFJjY6VFfFj8J2rMZ6fdujotllqiExx+ceQ/KEp81FU/MD5X4FmWk7h1p3AfQP87sDHw6+LGLoXIHeLAQtJHU7LJe7Gx+3PwxkUrCL3YF+Cd2jur8EIJ6qcHUF0sLdiV8tgMqyx8m4WO0vOW2qlPKGlvZUMqtfPvgsoj5n9Jo06DYq///kO3lxFdKtpMMo4o56GDhVD9Rbx+Y/ryp4cfvMXWFgLsz6FfLZDgFPrlJxZJtZcsQals7Venw2FwkRieALfoI7R87qolu0z/HqJVf7TYg3W1WDpG1tLlHmdllBHh2tBYfZ3yOEexGikfzlMv/JAbS1cFMhCCxaAzQQLxVu+hdn05+1cCoOq072LFfg= x-ms-exchange-antispam-messagedata: wO5+Fw9eEMKGkrky76wD3tNCMF+AnGSP7p3R6FzP6VnQICMu0AsgmdhnZ6EyjqQcrkFQJVOw51Ucn6wrwVPVzR/BfN1qPY7iZQ4UZ5GE2Ljm4NRXpf7BfR4smmb5XKlB0GQ3yMcs0etkfVLVZGqHQA== x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_AM0P191MB0708A91927576F3527317C81AED30AM0P191MB0708EURP_" MIME-Version: 1.0 X-OriginatorOrg: accelaero.com X-MS-Exchange-CrossTenant-Network-Message-Id: f5fd2e5a-37c3-4c60-0d58-08d7e74d9080 X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Apr 2020 06:14:21.7590 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 7bbb8a4d-7f1b-4a58-9b3a-c250fb8023e3 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: /jEBnPyiaMPrK4JDJ94IICG+F/yNxhiyij8XWxrFZ0YoDJwp9p3AuIMtEuKkHgeKkssMnt1H8vBlFUrQf1zpQg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0P191MB0706 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_AM0P191MB0708A91927576F3527317C81AED30AM0P191MB0708EURP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Classification: Internal Dear All, I have created Postgresql 10.6 hot standb ,but while creating physical repl= ication slots by default it is in inactive more I recreated the standby but still I am unable to make slots is in active an= d also I could not able to see the LSN value on both sites. Regards, Ashok --_000_AM0P191MB0708A91927576F3527317C81AED30AM0P191MB0708EURP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Classification: I= nternal


Dear All,

I have created Postgresql 10.6 hot standb ,but while creating physical re= plication slots by default it is in inactive more

I recreated the standby but still I am unable to make slots is in active = and also I could not able to see the LSN value on both sites.

 

 

Regards,

Ashok

 

 

 

--_000_AM0P191MB0708A91927576F3527317C81AED30AM0P191MB0708EURP_--