Bingo!
I doubled each of the entries below, and the two servers are now
running together quite happily!
Regards,
Eric
On Mar 30, 2009, at 7:56 PM, Eric Smith wrote:
... as a reminder, this is running on mac os 10.5
Eric
On Mar 30, 2009, at 7:53 PM, Eric Smith wrote:
Ahhh! Can't seem t
... as a reminder, this is running on mac os 10.5
Eric
On Mar 30, 2009, at 7:53 PM, Eric Smith wrote:
Ahhh! Can't seem to make this go away!
Here is the log file entry:
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=5432001,
Eric Smith writes:
> Following the queue on the postgres web page, I created /etc/
> sysctl.conf and added the following five entries:
> kern.sysv.shmmax=4194304
> kern.sysv.shmmin=1
> kern.sysv.shmmni=32
> kern.sysv.shmseg=8
> kern.sysv.shmall=1024
> But when I try to start two servers, I ge
Ahhh! Can't seem to make this go away!
Here is the log file entry:
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=5432001, size=4030464,
03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory s
Eric Smith 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 m
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 postgresq
Adrian Klaver writes:
> I think you are going to have to show us the exact command you are using.
What *I* want to see is the postmaster log, which should certainly
contain an error message explaining why it failed to start.
regards, tom lane
--
Sent via pgsql-general m
On Sunday 29 March 2009 7:59:19 pm Eric Smith wrote:
> Thomas,
>
> When I start the servers, I use different ports via the -p option. Is
> that equivalent to using different listener ports in postgresql.conf?
>
> Thanks,
> Eric
>
I think you are going to have to show us the exact command you are
Thomas,
When I start the servers, I use different ports via the -p option. Is
that equivalent to using different listener ports in postgresql.conf?
Thanks,
Eric
On Mar 28, 2009, at 3:51 PM, Thomas Kellerer wrote:
Adrian Klaver wrote on 28.03.2009 23:37:
On Saturday 28 March 2009 3:27:15
Eric Smith 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 resu
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.
Thanks,
Eric
On Mar 28, 2009, at 3:37 PM, Adrian Klaver wrote:
On Saturday 28 March 2009 3:27:15 pm Eric Smith wrote:
All,
I'm trying to run two database clusters
On Sat, 2009-03-28 at 23:51 +0100, Thomas Kellerer wrote:
> You also have to make sure you assign different listener ports for
> both servers in postgresql.conf
... or use different unix_socket_directory for each. Make sure that they
are not under /tmp, since /tmp will be cleaned up every 15 days
Adrian Klaver wrote on 28.03.2009 23:37:
On Saturday 28 March 2009 3:27:15 pm Eric Smith wrote:
All,
I'm trying to run two database clusters on a single machine, and am
failing. I use initdb to create the two clusters... each has their
own directory structure. I can start one server or the ot
On Saturday 28 March 2009 3:27:15 pm Eric Smith wrote:
> All,
>
> I'm trying to run two database clusters on a single machine, and am
> failing. I use initdb to create the two clusters... each has their
> own directory structure. I can start one server or the other with
> pg_ctl, but once the fir
All,
I'm trying to run two database clusters on a single machine, and am
failing. I use initdb to create the two clusters... each has their
own directory structure. I can start one server or the other with
pg_ctl, but once the first starts, the second just hangs on "waiting
for server t
15 matches
Mail list logo
