| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: vacuumdb not letting me connect to db |
| Date: | 2021-02-04 17:05:57 |
| Message-ID: | 0928c90f-420c-7eb2-fd1c-f3517a0537dc@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2/4/21 5:26 AM, Atul Kumar wrote:
> Hi,
>
> I have 160 GB of RAM, postgres 9.6 is running on the server.
>
> after upgrade I ran the below command:
>
> "/usr/edb/as9.6/bin/vacuumdb" -U 'enterprisedb' --verbose --all -j 300
> --analyze-only
>
> after running that command I was not able to connect the database
> using psql for few minutes.
What's the exact error message?
> After 20-30 minutes i was able to connect to the db and at that time I
> checked the pg_stst_activity, the active connections was reduced to
> 27.
>
> my max_connections is set to 700.
>
> I tried to find out the reason for not being abled to connect the db
> (when 300 jobs were running) but still not got the answer. So
Connect to the cluster *before* running "vacuumdb -j300", and start looking
at pg_stst_activity while vacuumdb is running.
--
Angular momentum makes the world go 'round.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2021-02-04 17:07:27 | Re: vacuumdb not letting me connect to db |
| Previous Message | Atul Kumar | 2021-02-04 17:00:20 | Re: vacuumdb not letting me connect to db |