Re: Backup Information - Mailing list pgsql-admin

From Muhammad Ikram
Subject Re: Backup Information
Date
Msg-id CAJQ7xG7aLQGQLEQneo=K3AB6yQpBNoaQsdidOPTeNvx8OqOcwg@mail.gmail.com
Whole thread Raw
In response to Re: Backup Information  (SOzcn <selahattinozcnma@gmail.com>)
List pgsql-admin
Hi,

Could you use

SELECT * FROM pg_stat_progress_basebackup ;

Regards,
Ikram




On Sat, Oct 19, 2024 at 1:01 PM SOzcn <selahattinozcnma@gmail.com> wrote:

does anyone can share the experience of it?

16 Eki 2024 Çar 17:00 tarihinde SOzcn <selahattinozcnma@gmail.com> şunu yazdı:

SOzcn <selahattinozcnma@gmail.com>, 16 Eki 2024 Çar, 16:45 tarihinde şunu yazdı:

Mostly v14 and 15 some of one v9-10 but first of all v14-15

As I see on the backend it's using pg_basebackup and dumpbased.

16 Eki 2024 Çar 15:55 tarihinde <lennam@incisivetechgroup.com> şunu yazdı:

Let me know the version PostgreSQL , I will provide SQL to get the details from system catalog tables

 

From: SOzcn <selahattinozcnma@gmail.com>
Sent: Wednesday, October 16, 2024 3:59 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Backup Information

 

Hello,

We are currently handling backup processes for PostgreSQL through a company.

I would like to monitor the backups on the database, but I have not been able to monitor the relevant query on WAL.

Could you please assist with this matter?

pgsql-admin by date:

Previous
From: Muhammad Ikram
Date:
Subject: Re: Verify or dump pgdata files
Next
From: Murthy Nunna
Date:
Subject: RE: Verify or dump pgdata files