| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Kashif Zeeshan <kashif(dot)zeeshan(at)enterprisedb(dot)com> |
| Cc: | Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, Ahsan Hadi <ahsan(dot)hadi(at)gmail(dot)com>, Asif Rehman <asifr(dot)rehman(at)gmail(dot)com>, Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: WIP/PoC for parallel backup |
| Date: | 2020-04-02 11:48:33 |
| Message-ID: | CA+Tgmobx=97uFjP5eRuDxLhGDsQ63ws6=9PE=SORuUaKa=w1aQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Apr 2, 2020 at 7:30 AM Kashif Zeeshan <
kashif(dot)zeeshan(at)enterprisedb(dot)com> wrote:
> The backup failed with errors "error: could not connect to server: could
> not look up local user ID 1000: Too many open files" when the
> max_wal_senders was set to 2000.
> The errors generated for the workers starting from backup worke=1017.
>
It wasn't the fact that you set max_wal_senders to 2000. It was the fact
that you specified 1990 parallel workers. By so doing, you overloaded the
machine, which is why everything failed. That's to be expected.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kashif Zeeshan | 2020-04-02 11:54:49 | Re: WIP/PoC for parallel backup |
| Previous Message | Robert Haas | 2020-04-02 11:46:51 | Re: WIP/PoC for parallel backup |