Thread: Backup Information

Backup Information

From
SOzcn
Date:
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?

RE: Backup Information

From
Date:

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?

Re: Backup Information

From
SOzcn
Date:

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?

Re: Backup Information

From
SOzcn
Date:

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?

Re: Backup Information

From
SOzcn
Date:

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?

Re: Backup Information

From
Muhammad Ikram
Date:
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?