View Issue Details

IDProjectCategoryView StatusLast Update
0000722Pgpool-IIEnhancementpublic2022-06-28 11:22
ReporterSatishS6 Assigned Topengbo  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionopen 
Product Version4.0.2 
Summary0000722: Wanted to know how to monitor backup and restore progress in postgresql
DescriptionHi Team,

I wanted to know how we can monitor the percentage of backup and restore database progress.

Is there any way to monitor it any PostgreSQL DMV, any script ? if yes please provide.
Steps To ReproduceHi Team,

I wanted to know how we can monitor the percentage of backup and restore database progress.

Is there any way to monitor it any PostgreSQL DMV, any script ? if yes please provide.
Additional InformationHi Team,

I wanted to know how we can monitor the percentage of backup and restore database progress.

Is there any way to monitor it any PostgreSQL DMV, any script ? if yes please provide.
TagsNo tags attached.

Activities

pengbo

2021-07-28 11:12

developer   ~0003906

> I wanted to know how we can monitor the percentage of backup and restore database progress.
>
> Is there any way to monitor it any PostgreSQL DMV, any script ? if yes please provide.

No. Pgpool-II doesn't support such capabilities.

Since PostgreSQL 13, you can use pg_stat_progress_basebackup view to watch the progress of base backup.
https://www.postgresql.org/docs/13/progress-reporting.html#BASEBACKUP-PROGRESS-REPORTING

pengbo

2022-06-28 11:22

developer   ~0004073

No response over two weeks.
Close issue.

Issue History

Date Modified Username Field Change
2021-07-27 15:56 SatishS6 New Issue
2021-07-28 11:01 pengbo Assigned To => pengbo
2021-07-28 11:01 pengbo Status new => assigned
2021-07-28 11:12 pengbo Note Added: 0003906
2021-07-28 11:12 pengbo Status assigned => feedback
2022-06-28 11:22 pengbo Note Added: 0004073
2022-06-28 11:22 pengbo Status feedback => closed