Alexei,
Please keep your replies on-list!
On Tue, Mar 05, 2002 at 02:48:31PM +1300, Alexei Tenitski wrote:
> I've installed psql 7.2, have done everything as written in README
>
> Postmaster starts (as a service) but when i try to access it
> it dies. Log contains following:
>
> DEBUG: database system is ready
> DEBUG: server process (pid 1720) exited with exit code 128
> DEBUG: terminating any other active server processes
> DEBUG: all server processes terminated; reinitializing shared memory
> and semaphores
> IpcMemoryCreate: shmget(key=5432001, size=606208, 03600) failed: Not
> enough memory
>
> This error usually means that PostgreSQL's request for a shared
> memory segment exceeded available memory or swap space.
> To reduce the request size (currently 606208 bytes), reduce
> PostgreSQL's shared_buffers parameter (currently 16) and/or
> its max_connections parameter (currently 5).
>
> The PostgreSQL Administrator's Guide contains more information about
> shared memory configuration.
>
> I tried to edit this params (max conns & buffers) but this
> doesn't seem to change situation.
>
> Have you got any ideas about what could be the problem?
Did you change the user account under which postmaster is running?
If so, then heed the warning in the README:
2. It is recommended to delete all cygipc temporary files
(/tmp/cygipc* and /tmp/MultiFile*) before starting postmaster under
a different user account. Otherwise, postmaster will fail to start
due to IPC errors.
If not, then sorry but I have no idea what the problem is.
Jason