Re: [ADMIN] terminating autovacuum process due to administrator command

2012-06-28 Thread Albe Laurenz
Radovan Jablonovsky wrote: Could you, please navigate me how to explain 2 different calculation kernel parameter SEMMNI. In PostgreSQL documentation: http://www.postgresql.org/docs/9.1/static/kernel-resources.html#SYSVIPC is used this calculation of SEMMNI. SEMMNIMaximum number of

Re: [ADMIN] terminating autovacuum process due to administrator command

2012-06-27 Thread Radovan Jablonovsky
Hello, Could you, please navigate me how to explain 2 different calculation kernel parameter SEMMNI. In PostgreSQL documentation: http://www.postgresql.org/docs/9.1/static/kernel-resources.html#SYSVIPC is used this calculation of SEMMNI. SEMMNIMaximum number of semaphore identifiers (i.e.,

Re: [ADMIN] terminating autovacuum process due to administrator command

2012-06-25 Thread Albe Laurenz
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

Re: [ADMIN] terminating autovacuum process due to administrator command

2012-06-25 Thread Radovan Jablonovsky
Thanks for response, How were the connections refused (error message)? 2012-06-13 13:45:38.809 MDT [25172]: [1-1] FATAL: remaining connection slots are reserved for non-replication superuser connections 2012-06-13 13:45:38.889 MDT [25173]: [1-1] FATAL: remaining connection slots are reserved

Re: [ADMIN] terminating autovacuum process due to administrator command

2012-06-25 Thread Craig Ringer
On 06/25/2012 11:00 PM, Radovan Jablonovsky wrote: Thanks for response, How were the connections refused (error message)? 2012-06-13 13:45:38.809 MDT [25172]: [1-1] FATAL: remaining connection slots are reserved for non-replication superuser connections 2012-06-13 13:45:38.889 MDT [25173]:

Re: [ADMIN] terminating autovacuum process due to administrator command

2012-06-24 Thread Craig Ringer
On 06/23/2012 10:14 AM, Radovan Jablonovsky wrote: Could you please help with this peculiar problem? Not without more information than that - at the very minimum, your version of PostgreSQL. http://wiki.postgresql.org/wiki/Guide_to_reporting_problems You also need to provide some info