OpenVZ Forum


Home » Mailing lists » Users » PostgreSQL can't allocate shared memory
PostgreSQL can't allocate shared memory [message #12026] Mon, 16 April 2007 05:42 Go to previous message
Gregor Mosheh is currently offline  Gregor Mosheh
Messages: 62
Registered: April 2007
Member
Hi, all.
First: OpenVZ; nice. A slick alternative to VMWare, less overhead. Nice.
But, a hitch in my first experiments...

I have PostgreSQL 8.1 in a VE (Fedora Core 6, for what it's worth), and I
cannot set shared_buffers higher than 3700 (about 30 MB) and have it
start. Anything higher and it complains that it can't allocate the shared
memory.

In the UBC, I verified that I set shmpages to 32000, which should be 128
MB at 4k apiece (or 256 MB if it's 8k pages; I'm not sure which it is for
shared memory pages) and therefore more than enough for PgSQL's request. I
have tried raising shmpages, but it doesn't change anything. The
privvmpages is 262144 (1 GB) so this should also be plenty.

The UBC is showing 0 failcount across the board.

And the HN's kernel.shmmax is set to 1 GB. (Is that relevant in a VE?)

I'd be very appreciative of any help. And thanks for the software!

--
HostGIS
Cartographic development and hosting services
707-822-9355
http://www.HostGIS.com/

"Remember that no one cares if you can back up, only if you can restore."
- AMANDA
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Asterisk
Next Topic: Asterisk
Goto Forum:
  


Current Time: Wed Feb 28 01:53:24 GMT 2024

Total time taken to generate the page: 0.02439 seconds