| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in> |
| Cc: | "'pgsql-admin(at)lists(dot)postgresql(dot)org'" <pgsql-admin(at)lists(dot)postgresql(dot)org>, Ashish Chugh <ashish(dot)chugh(at)lavainternational(dot)in> |
| Subject: | Re: PG_Base Backup take 8 to 9Hrs |
| Date: | 2022-02-08 13:02:25 |
| Message-ID: | 20220208130225.kbecwy3oxvfi6iuk@jrouhaud |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2022-02-08 14:11:44 | Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs. |
| Previous Message | Ram Pratap Maurya | 2022-02-08 11:36:19 | PG_Base Backup take 8 to 9Hrs |