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 1tPZUU-00DisO-A7 for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Dec 2024 03:52:22 +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 1tPZUT-006nHM-Kl for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Dec 2024 03:52:21 +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 1tPZUT-006nHC-7h for pgsql-hackers@lists.postgresql.org; Mon, 23 Dec 2024 03:52:21 +0000 Received: from mail-yb1-xb2f.google.com ([2607:f8b0:4864:20::b2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tPZUQ-0019m3-Bq for pgsql-hackers@lists.postgresql.org; Mon, 23 Dec 2024 03:52:20 +0000 Received: by mail-yb1-xb2f.google.com with SMTP id 3f1490d57ef6-e387ad7abdaso3511535276.0 for ; Sun, 22 Dec 2024 19:52:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734925937; x=1735530737; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=wT//jUZYFoiAeNCj+gmsc4/+aupiQBlpMjoo+up5kmg=; b=XiP5cXDss7zAhpwCcAQPzaw7u+ZOd+surSy3OEYd9jwC+jTq3vT+qgwfiMA0OxQJls TKSdwolpH8ZIuzMVg+PNsw1GDqy5WsbwgB0wprb5KSDzRS9eQn33+YvtaiaoRwVxGfNZ 2TjEZwf0FuPCcGDBPn7oIjtOpun1Y6aZ5DJowWjJEjgYIIbAxEzP87iiL7tHfpev+uyH t8oMA7zQL5T67gFy0HhIZQVRLC58+oXyL+v5Hgm/4lCeuijiDXiUSLzyxcxEVHzLcL3G knYoExP/S7ZoHON7MVqeziK2arwl3haEmlMDHZHocqcqHwsB5cqduJ9Eag292ERwxjYl 5Z1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734925937; x=1735530737; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=wT//jUZYFoiAeNCj+gmsc4/+aupiQBlpMjoo+up5kmg=; b=ILOd2kVz2/qL4y4nr64ypQddW9tj6nmQ6YSDl3+ACx0w2GOW73XJLItkvp9LLMLJZ9 JWPIDHc/QjVuoUmWbgXz+SMf2xj5fzTtjsp10oUEs+eg5UmWMTJW0ERRbhIi0QcpXIRA fr3xeE93Ss+8OZ3VMS76611Sa7DQXl+tHTQ9WhrMSbgR1ydm8DitxnmHqV9CwivD89Tq 7yn2swOIhqwXO1bAFvMo39WV7OpPM4C0Q7c6JG9WGApZFup8OBCtnfaNUj6PkMZ7uG+B gKmSI2XBIqYxQYC9OA9DSS5dETJoVFjnwUTEpwGbiTFabSVThR6yn/pRgwObFn/oijzU EdNg== X-Gm-Message-State: AOJu0YyCEx84uupZu+LTuXsnp05aqpNf/RcNMYZBB9r6gJt7xZNvnHkS wGlc9gVVTpkmRannSKyXInpQkx7pLzfM3us7kzrh8onQTCFFqf+zcwVlWGgYygVWu6Bb1aUdhnX 4MQTM9Fw2fQQDTfSDmxQOqUxgWXZtTZ1o X-Gm-Gg: ASbGnctEIPIFfTYHAsMWD/hgz+Vho+bomeG20AMVR+fsWJKzbmqiuOEXpyQVbq9gkqi /V5vyJwonDKTW3Xp5cCkvJMmGMq6+P8VwuZ5tOdklP7VLvHJw/Id18M8Urs6VEBcqsbRI X-Google-Smtp-Source: AGHT+IGgqZIh7mc0CrZ7m6726MFAFLH9sNOUgLBKvz/qUOB2+w8ZsJBQy6gUCQJD4quZNeaTg0/wwpH2AOzFh3L1vYg= X-Received: by 2002:a05:6902:2b11:b0:e4a:3170:1e90 with SMTP id 3f1490d57ef6-e538c22e453mr8544947276.12.1734925936923; Sun, 22 Dec 2024 19:52:16 -0800 (PST) MIME-Version: 1.0 From: mahendrakar s Date: Mon, 23 Dec 2024 09:22:06 +0530 Message-ID: Subject: Last removed wal segment file To: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Hackers, Is there any psql utility function that returns the last removed wal segment file? I see there is a method: XLogGetLastRemovedSegno in xlog.c. Would be happy to add a new psql function around it (similar to: pg_walfile_name, pg_last_wal_replay_lsn, etc other utility functions we have). Thanks, Mahendrakar.