Re: running two servers on one machine

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eric Smith <eric_h_smith(at)mac(dot)com>
Cc: Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: running two servers on one machine
Date: 2009-03-31 02:18:06
Message-ID: 28429.1238465886@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Eric Smith <eric_h_smith(at)mac(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric Smith 2009-03-31 02:53:42 Re: running two servers on one machine
Previous Message Tom Lane 2009-03-31 01:59:32 Re: pgstattuple triggered checkpoint failure and database outage?