Skip to content
This repository has been archived by the owner on Sep 26, 2023. It is now read-only.

max number connections exceeded #5

Open
smnorris opened this issue Feb 28, 2017 · 0 comments
Open

max number connections exceeded #5

smnorris opened this issue Feb 28, 2017 · 0 comments

Comments

@smnorris
Copy link
Owner

smnorris commented Feb 28, 2017

When loading ~250 tables via ogr2pg, the loader bails at ~220 or so with:

ERROR 1: PQconnectdb failed.
FATAL:  sorry, too many clients already

in postgresql.conf, max_connections = 25

No luck reproducing this with a simple test (test_n_connections()). I'm not sure where the connection closing is being held up. Disabling the NullPool required for multiprocessing didn't help (137e8c9)

Setting max_connections = 50 eliminates the problem

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant