Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclared identifier 'FD_SETSIZE'

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: Alvaro Herrera <alvherre@2ndquadrant.com>

Cc: Andres Freund <andres@anarazel.de>, Tom Lane <tgl@sss.pgh.pa.us>, Dilip Kumar <dilipbalaut@gmail.com>, jungleboogie0@gmail.com, pgsql-bugs@lists.postgresql.org

Date: 2019-08-19T04:28:32Z

Lists: pgsql-bugs

On Sun, Aug 18, 2019 at 10:59:54PM -0400, Alvaro Herrera wrote:
> Hmm ... yeah, this is clearly not perfect.  In my laptop, vacuumdb -j 1021
> works; 1022 and 1023 fail like this after opening a number of conns:
>
> So I agree that we need a fix.

How would you detect how many fds can be opened by a user in this
case?
--
Michael

Commits

Fix error handling of vacuumdb when running out of fds
- a21ec1a959ef 9.5.20 landed
- eb91b8ee6572 9.6.16 landed
- 4fca1460099e 10.11 landed
- 5d76c8037329 11.6 landed
- 63fc3b124008 12.0 landed
Fix error handling of vacuumdb and reindexdb when running out of fds
- 71d84efba714 13.0 landed
Fix compilation failure of vacuumdb and reindexdb with OpenBSD
- 56f8f9624ba0 13.0 landed
Improve Assert output
- d78d452bc5ac 13.0 cited
Refactor parallelization processing code in src/bin/scripts/
- 5f3840370b63 13.0 cited
vacuumdb: enable parallel mode
- a17923204736 9.5.0 cited