Re: vacuumdb not letting me connect to db

From: Ravi Krishna <rkrishna_pg(at)aol(dot)com>
To: "akumar14871(at)gmail(dot)com" <akumar14871(at)gmail(dot)com>, "ronljohnsonjr(at)gmail(dot)com" <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: vacuumdb not letting me connect to db
Date: 2021-02-04 20:50:03
Message-ID: 1467216775.1827853.1612471803922@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>There is no error message, when I try to connect the database while
>running vacuumdb with 300 jobs, it gets stuck.

But you mentioned max connection which now seems to be a red herring.
Based on your description, the impression I got is that you are getting
"sorry, too many clients already" error.

As others have pointed out, the db is probably saturated with I/O error.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Samuel Nelson 2021-02-04 22:11:35 Partition Creation Permissions
Previous Message Pavan Pusuluri 2021-02-04 18:51:58 Unable To Drop Tablespace