Re: terminating autovacuum process due to administrator command

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Radovan Jablonovsky *EXTERN*" <radovan(dot)jablonovsky(at)replicon(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: terminating autovacuum process due to administrator command
Date: 2012-06-25 08:03:34
Message-ID: D960CB61B694CF459DCFB4B0128514C208126EEC@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Radovan Jablonovsky wrote:
> Could you please help with this peculiar problem?
>
>
> In PostgreSQL log occurred this message:
>
> 2012-06-13 12:58:45.876 MDT [17536]: [1-1] FATAL: terminating
autovacuum process due to administrator
> command
> The server worked for 48 minutes after and then it started refuse
non-superuser connections, which
> effectively rendered it unusable for client applications.
> What could cause this behaviour?

You gave very little information.

How were the connections refused (error message)?
Could it be that there are already max_connections sessions?

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2012-06-25 10:56:42 Re: a very slow SQL
Previous Message wangqi 2012-06-25 06:45:29 a very slow SQL