binary version of pg_current_wal_insert_lsn and pg_walfile_name functions

From: Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: binary version of pg_current_wal_insert_lsn and pg_walfile_name functions
Date: 2022-09-19 14:49:34
Message-ID: CAE9k0PkQehNApO0vWuVbNb2pCTu64eCMWYkCFXQtb6CZop10RA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

Currently, we have pg_current_wal_insert_lsn and pg_walfile_name sql
functions which gives us information about the next wal insert
location and the WAL file that the next wal insert location belongs
to. Can we have a binary version of these sql functions? It would be
like any other binaries we have for e.g. pg_waldump to which we can
pass the location of the pg_wal directory. This binary would scan
through the directory to return the next wal insert location and the
wal file the next wal insert pointer belongs to.

The binary version of these sql functions can be used when the server
is offline. This can help us to know the overall WAL data that needs
to be replayed when the server is in recovery. In the control file we
do have the redo pointer. Knowing the end pointer would definitely be
helpful.

If you are ok then I will prepare a patch for it and share it. Please
let me know your thoughts/comments. thank you.!

--
With Regards,
Ashutosh Sharma.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2022-09-19 14:50:36 Re: Ubuntu 16.04: Xenial: Why was it removed from the apt repo?
Previous Message Larry Rosenman 2022-09-19 14:46:05 Ubuntu 16.04: Xenial: Why was it removed from the apt repo?