Re: Error starting postmaster

I'm not currently able to access my system but will try to do this from memory...

First, I'd do a man lookup on ipcclean (I think). This will attempt to
clean out the shared memory segments that may be reserved but not in use.

If that doesn't work, there is a startup option (-B nnn) where you can
specify the number of default buffers when you start the postmaster. I
don't know what the default is right off hand, but on Redhat I could
make it start by setting this number to around 100.

Unfortunately, the only way I found to _permanently_ get rid of this
problem with the Redhat distribution was to increase the value of SHMMAX
in /usr/src/linux/include/asm-i386/shmparam.h. After doing that I
recompiled the kernel and haven't had a problem since.

Now, two disclaimers on this. I have _no_ idea what other effects
making this kernel change will have on your system. I've been running
this way for 2+ months without seeing any problems. I could never find
anyone that could answer that question to my satisfaction. The second
disclaimer is that some say recompiling the kernel is not for the faint
of heart. It didn't bother me, but I had good backups... :-)

Hope this helps.

> Date: Sun, 03 Jan 1999 15:55:55 -0800
> From: Gregg Berkholtz <gregg(at)gbcomputers(dot)com>
> Subject: Error starting postmaster
>
> I am running Slackware 3.5, PostgreSQL 6.4.
> I was able to start and run PostgreSQL and run the initial regression
> test with only a failure in geometry and misc.
> Overall it worked well.
> I kill the postmaster process.
>
> I got an error:
> FATAL: StreamServerPort: bind() failed: errno=98
> Is another postmaster already running on that port?
> If not, remove socket node (/tmp/.s.PGSQL.5432) and retry
>
> I deleted this .s.PGSQL.5432 file and am now getting this error on
> startup:
> IpcMemoryCreate: shmget failed (Identifier removed) key=5432010,
> size=24588, per
> mission=700
> IpcMemoryIdGet: shmget failed (Identifier removed) key=5432010,
> size=24588, perm
> ission=0
> IpcMemoryAttach: shmat failed (Invalid argument) id=-2
> FATAL 1: AttachSLockMemory: could not attach segment
>
> I have also tried deleting the '/usr/local/pgsql/data' directory and
> then run initdb again -- didn't work.
>
> Any help please -- thanks greatly!
> - --
> - -----------------------------------------------------
> ///////////// Gregg Berkholtz - Owner/Consultant
> | G B | PC, Novell, and Linux Support/Sales
> | Computers | info: www.gbcomputers.com
> \\\\\\\\\\\\\
>
> ------------------------------
>
> End of pgsql-admin-digest V1 #122
> *********************************