Search Postgresql Archives

Re: running two servers on one machine

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Eric Smith <eric_h_smith@xxxxxxx> writes:
> Log file says "could not create shared memory segment".  It also says  
> that I should change max_connections or shared_buffers.

> Error message claims that max_connections is 23, but postgresql.conf  
> has this listed as 20.

The autovacuum workers get added on.

> Error message claims that shared_buffers is 300, but postgresql.conf  
> has this listed as 2400kB.

Same thing, different units.

Anyway, you left out the interesting part of the error message,
ie the kernel error code.  If it's "Cannot allocate memory" then
you probably need to increase SHMALL.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux