Re: PG_Base Backup take 8 to 9Hrs
| От | Julien Rouhaud |
|---|---|
| Тема | Re: PG_Base Backup take 8 to 9Hrs |
| Дата | |
| Msg-id | 20220208130225.kbecwy3oxvfi6iuk@jrouhaud обсуждение исходный текст |
| Ответ на | PG_Base Backup take 8 to 9Hrs (Ram Pratap Maurya <ram.maurya@lavainternational.in>) |
| Ответы |
Re: PG_Base Backup take 8 to 9Hrs
|
| Список | pgsql-admin |
Hi, Please don't try to recall messages sent on a mailing list. That won't work and will spam everyone. On Tue, Feb 08, 2022 at 11:36:19AM +0000, Ram Pratap Maurya wrote: > > We are using Postgres -11 version and current PG DB size is 450 GB . > > Archive log enable in Database and we are running Full PG_Base backup and it > will take 8 to 9 Hrs to complete the backup , > > Please suggest how to reduce the full DB backup time. That's ~16MB/s, so many times slower than a single old 7200RPM drive. The problem is likely not with postgres, you should get a better storage or a better network.
В списке pgsql-admin по дате отправления: