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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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