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 1u27OP-00DFbU-7k for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 11:45:25 +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 1u27NO-0082Vw-QJ for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 11:44:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u27NO-0082Vn-FE for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 11:44:22 +0000 Received: from mail-ua1-x930.google.com ([2607:f8b0:4864:20::930]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u27NM-0047k8-1W for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 11:44:22 +0000 Received: by mail-ua1-x930.google.com with SMTP id a1e0cc1a2514c-86d30787263so2539384241.1 for ; Tue, 08 Apr 2025 04:44:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744112658; x=1744717458; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=3Uhdm+0Zd3QqgNe7yXbxJlg3pBCzuaO3z8V2d3uO/6A=; b=GrohK21+u/pMRe1c5N3l3WNQxmgr3mr0F0XbXKBZJFfLJLPyB7o26tmUo51ZKQrXTj MhWgtB4cwL8cUl/Nf4Z7XZJNUsqgfsvz2uIGwriSfNMMOK0PDpk6Fmd+uRIKhG/n+wcI K8et1lQW3z9FJgKsLeHtkhbrAhjuk2cmMD+JC6XBE5iY57XehRW3aJTZM9QiGfTkxQES V54Vg1x5bgflEP/+emB9baHv0X1hhrP41PsZFVVTHYSc/9qHF33gyBgE3Dx255zEFUuK lyL+SZhTRKsO2bPrGKRfsYx9lMTGqMZY+5zIiyGmq8i21Hgfbby/zBb200FBqjGyd3oM a96Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744112658; x=1744717458; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=3Uhdm+0Zd3QqgNe7yXbxJlg3pBCzuaO3z8V2d3uO/6A=; b=d+BO/UnB9AenDjzSIH4AtOaaaBdZ7QPxtlVJ6nktVoF/inD8YZxLSO4uwfPUMayg2g EgVKD0/ljaZi9T88GDbVVXqLqsT/+LQUzuoPFa93mvOKNIJIBoA/mYTBkaDMMQh99yOH h8ADs+UUKLPDBhwRRg4Op1mVKuObO6rAW2mn9Nj2tjzYj8Q1moQZz4jDgkre7TThdoBv 2zdvqQ1qQQGOLw5M5BGHFl/BDt0VjwvNvm/dsoxDzeUmJWeOGGUnpJTliGHJmxQgT6NU KG9S7WqBd15G51cnoflzEVW1eJJ7Jcv5yqzc8EAgkWWC8+r9EmD6+OL9nFBxlGUdqz+t 0ZiQ== X-Gm-Message-State: AOJu0YzIDNVfl46uGEx8PD1ERDDjpStwsRisqL33fPPjb2l11t4yZAL4 ti5qosjDb5cN2BSt6GYldtS5GjFrF0wEUoCmWycXnP1hjB1lQaY5J2wd9Gu1IUh0ZaCLNBp1DOK qNs4AUoiNeg7ke1zJ9+Kw/Vyk0XOGKg== X-Gm-Gg: ASbGncsVXs/bfacO6loTGBQ5gym1nba0hgCYzKQrWaJmtZodhuueJXM8mxV6I8XkcK2 Ji4I+CcyR6RM82zrD2iqET8+lJnTUOYr6nzC4Sg3IV+dp4P2kN5yO75liMKuXfeUhp/+e/CnwWu SsojITvOhY+ICtai1MOr1RD2Goy3rqUW6ZvlGSTSInIu0L0u8G8aE5lFSMmSU= X-Google-Smtp-Source: AGHT+IEjSexGFmw/hb88G1Ky5yRcKk5k1pxfWtDYkrDkvA/YEWkbGD3D0RP6oNTaaiJXTUxSiR9yIxrxjsF9dbxYkEo= X-Received: by 2002:a05:6102:2c85:b0:4bb:e36f:6a30 with SMTP id ada2fe7eead31-4c8553e27a8mr12943077137.15.1744112658457; Tue, 08 Apr 2025 04:44:18 -0700 (PDT) MIME-Version: 1.0 From: Atul Kumar Date: Tue, 8 Apr 2025 17:14:07 +0530 X-Gm-Features: ATxdqUGY7V7dMA1dtUKggLRBJwJ4HVfn_Qee_Lklh739dGuJbrQFHNt5QX6YfPE Message-ID: Subject: Wal file query To: pgsql-general Content-Type: multipart/alternative; boundary="00000000000074bce0063242df4a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000074bce0063242df4a Content-Type: text/plain; charset="UTF-8" In streaming replication What is the way to check which "WAL file" is currently in use in primary and in standby ? Regards. --00000000000074bce0063242df4a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
In streaming replication=C2=A0What is the way to check wh= ich "WAL file" is currently in use in primary=C2=A0 and in standb= y ?


Regards.
--00000000000074bce0063242df4a--