Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uKHeN-000RQT-Vt for pgsql-admin@arkaria.postgresql.org; Wed, 28 May 2025 14:20:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uKHeM-000KBW-HA for pgsql-admin@arkaria.postgresql.org; Wed, 28 May 2025 14:20:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uKHeM-000KBO-5r for pgsql-admin@lists.postgresql.org; Wed, 28 May 2025 14:20:58 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uKHeK-000O8I-0m for pgsql-admin@lists.postgresql.org; Wed, 28 May 2025 14:20:57 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-604b9c53f6fso6294401a12.2 for ; Wed, 28 May 2025 07:20:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748442054; x=1749046854; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=HjCUkKGOr2+IIJRgSMaqpIlxYU3hWsCq2HHyL5nnXCA=; b=bRiq0TmCHQ4npMFj+UyagdMOK5xhlilfBqV9SD/GqVOh3bKIlRkH8Jb9lEwLC1lGXP wIPmPPYgJiP/8O/GCeKD1kfjzMHv/H61eCQYlFhchOSaXkDc81ycMRsZp/dLOQ/Z8rc0 9yjpJmrGhr2ai8cFiuLEFGmkCTRQvEiuuKBFYkjgYLc7PnLJiXWfuyZdMX/DtibPSSxg BlKlYK0oW7zMKi6zfsKr4Hvtdr9rWRsvPLfDYb2mzsgE6PZdqbAzR7bMEuV8JzGTnxvH +OQ1ePHppTUsrETs+YXO046sjqJpb6tpL0QhzIFjMsAPSdMGDnN5eGOg0Z7yN4lx7W5R qZbw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748442054; x=1749046854; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=HjCUkKGOr2+IIJRgSMaqpIlxYU3hWsCq2HHyL5nnXCA=; b=SBlvXY8jfOcc/mY75+apZ61JO9nxhNEUF4RbhC9plGCNZ9g8rgbLy1YFn/KYOVQok6 OBKS8jE1gag1b1q2OYxO3dToL7g+8KgBtyzmtiTf+F2j+6HRzbwZW6LOypxMcZxmXmTR 0EBbwIf1KJW+HRn7rRzUVkEl7Wr2kzsMUWnEGNi1BiOT94mkC+pvnYOSx6TBHh2Fqrqg 1P/YK9AKWcGs86Gn61RXEuZdp0VgeqI8AIym7qC4nh0IcpFS0blJEWNbcBH2DbpVfNBM wvG6lsHcg5OkuxHCSRJy+jZjo41DLOS1N2p/JT7HtLqPlhYKmoqwFk+zlicbC6+bTfDi 8d7Q== X-Gm-Message-State: AOJu0Yw54Z11ER1Cun0xxBhzDmZdGbWWxjWI99EG6uTStQnXVglJlKnc GH91G/PYafSe8lw4LOPjCgNS66g9Da5Hf1fjSsFgrRFSqGfFK2Y0xQ/KMvpCEWf7m60VLtX47Uq kbw3HNKSn+9pVdL20g7RwYYrsZizw07UCY0CK X-Gm-Gg: ASbGnctnpyUS12bjCAsXenAW92saGhcV7Oh5js+LKqANBpOVGz10ZHW/ztdhZ6mdhjq LrgZDiRLXlU4tvbO2j9EDdhjP1/b4ZHFjif4VYTKOo/B5Q3/iYf7DcSjS2B06uOYeRuNXee1IvY gPIC4WPeddodG9rFEl4YjBDSlZRyotad0Tts+imAqXRJIaLH1PybWOK+cZh3uvGsrBTmbJrzKX6 p0t X-Google-Smtp-Source: AGHT+IHjoSrxQmqpGFH/C0OzChmTUejJlpx0pOOrDQ0YPRhGzQNpEiScZ1/OXeU0vYlJb7Bj8A8xbO+cHhWKHhGvKMc= X-Received: by 2002:a05:6402:1d53:b0:5f4:cad5:360f with SMTP id 4fb4d7f45d1cf-602db4afe8fmr15550660a12.28.1748442053831; Wed, 28 May 2025 07:20:53 -0700 (PDT) MIME-Version: 1.0 From: Gambhir Singh Date: Wed, 28 May 2025 19:50:17 +0530 X-Gm-Features: AX0GCFuUqwT-KIOMd_1iU8d7CBmji4qRTnGRCXrcuRRWb7QA-c1JviiuL4G9s2k Message-ID: Subject: Replication Slots. To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000877124063632e3d8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000877124063632e3d8 Content-Type: text/plain; charset="UTF-8" Hi, Can we create replication slots on standby and read the changes. App team using Abnitio Graph to get the changes in db through replication slots. Currently they are working on primary DB, now they are asking if they can use standby for the same to offload the primary DB. -- Thanks & Regards Gambhir Singh --000000000000877124063632e3d8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Can we create replication sl= ots on standby and read the changes. App team using=C2=A0Abnitio Graph to g= et the changes in db through replication slots. Currently they are working = on primary DB, now they=C2=A0 are asking if they=C2=A0can use standby for t= he same to offload the primary DB.


--
Thanks & Regards
Gambhir Singh

--000000000000877124063632e3d8--