-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stuart Henderson Sent: Thursday, August 28, 2008 10:58 AM To: misc@openbsd.org Subject: Re: 4.2-stable & Postgres
On 2008-08-28, Morris, Roy <[EMAIL PROTECTED]> wrote: > Hi, I am hoping someone here has run into this before, I didn't see anything > worth while > (or that I understood) via a google search. > I guess specs first. I have running OpenBSD 4.2-stable with postgres 8.2.4. >speaking from experience: don't forget to dumpall before you >upgrade this machine. I like to add reminders about things like >that to /etc/motd in case I have a spare half-hour in the future >and think it might be a good idea to upgrade the machine, at which >point I've usually forgotten about these things... Thanks, good idea for sure! > Aug 12 20:46:29 logdb postgres[30182]: [1-1] FATAL: could not create shared > memory segment: Invalid argument > Aug 12 20:46:29 logdb postgres[30182]: [1-2] DETAIL: Failed system call was > shmget(key=4225001, size=74702848, 03600). >>the 72MB requested here doesn't fit in the 32MB you get by default. >>/usr/local/share/doc/postgresql/README.OpenBSD tells you a bit about >>the kern.shminfo.shmmax sysctl... Yep, just read this again and I will try changing the value (now 50) to kern.shminfo.shmmax=83886080 and see how that goes. Thanks again.