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

Re: Can't restart Postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thom Brown" <thombrown(at)gmail(dot)com>
Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Can't restart Postgres
Date: 2008-10-30 12:00:45
Message-ID: 8888.1225368045@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Thom Brown" <thombrown(at)gmail(dot)com> writes:
> The script is actually one which came with the Gentoo package.
> ...
> Okay, so I've manually tried starting the server now and told it to
> output any log to /tmp.  This is telling me that the request for a
> shared memory segment is higher than my kernel's SHMMAX parameter.  My
> bad, I've put my settings in incorrectly, and as it states in the
> config file, changes to that setting require a restart.  I've reset
> all values to back to how they were and it is running again.

Yeah, SHMMAX overrun is a pretty common problem.  You really need to
complain to whoever maintains the Gentoo package that their start script
is so utterly, noisily unhelpful in the presence of a postmaster startup
issue.

			regards, tom lane

In response to

pgsql-general by date

Next:From: Roberts, JonDate: 2008-10-30 12:56:22
Subject: Re: Piping CSV data to psql when executing COPY .. FROM STDIN (Solved)
Previous:From: Grzegorz JaƛkiewiczDate: 2008-10-30 11:59:15
Subject: Re: Are there plans to add data compression feature to postgresql?

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