Re: [Sysadmins] [sisyphus] postgresql (emaphores (SEMMNS), would be exceeded)

[Sisyphus@mail.ru]

Здравствуйте, Genix.
  уменьшение кол-во конектов решает проблему, вопрос как увеличит
  колво симофоров в сизифе..

  Попробывал сделать дамп и вот такое:
pg_dumpall > outfile
pg_dumpall: could not connect to database "template1": could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?  
Вы писали 11 мая 2006 г., 9:01:12:

> Sisyphus@mail.ru wrote:

>>  postgres[14947]: [2-1] FATAL:  could not create semaphores: No space left on device
>>  postgres[14947]: [2-2] DETAIL:  Failed system call was semget(5432018, 17, 03600).
>>  postgres[14947]: [2-3] HINT:  This error does *not* mean that you have run out of disk space.

> посмотри, может родственное к твоей проблеме
> http://www.opennet.ru/openforum/vsluhforumID1/64940.html#2

>>  postgres[14947]: [2-4] ^IIt occurs when either the system limit for the maximum number of semaphore sets (SEMMNI), or the system wide maximum number of
>>  postgres[14947]: [2-5]  semaphores (SEMMNS), would be exceeded.  You need to raise the respective kernel parameter.  Alternatively, reduce PostgreSQL's
>>  postgres[14947]: [2-6]  consumption of semaphores by reducing its max_connections parameter (currently 512).
>>  postgres[14947]: [2-7] ^IThe PostgreSQL documentation contains more information about configuring your system for PostgreSQL.

>                             
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> думаю стоит читать что пишет система ;)

>>  postgres[14947]: [3-1] LOG:  shmctl(25755662, 0, 0) failed: Invalid argument
>>  postgresql:  failed







-- 
С уважением,
 Sisyphus                          mailto:Sisyphus@mail.ru