Skip site navigation (1) Skip section navigation (2)

Re: running two servers on one machine

From: Eric Smith <eric_h_smith(at)mac(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 00:43:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
That's it!

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.
Error message claims that shared_buffers is 300, but postgresql.conf  
has this listed as 2400kB.

What the heck is going on here?  (no, the lines in the conf file are  
not commented out).  How do I enforce the conf file entries?


On Mar 29, 2009, at 8:19 PM, Tom Lane wrote:

> Eric Smith <eric_h_smith(at)mac(dot)com> writes:
>> Yes, if I start one, but not the other, the process works just great.
>> It's only when trying to run both that I have a problem.
> Have you looked into the postmaster logfile?
> One likely idea is that you don't have shmall cranked up high enough
> for two servers, which'd result in something like
> FATAL:  could not create shared memory segment: Cannot allocate memory
> in the postmaster log.
> 			regards, tom lane

In response to


pgsql-general by date

Next:From: Ow Mun HengDate: 2009-03-31 01:20:59
Subject: partial TEXT search on an index
Previous:From: jc_michDate: 2009-03-30 23:55:19
Subject: PL/PGSQL arithmetic errors

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group