Re: pgsql 7.4

Please post instead of sending private email

On Fri, Nov 28, 2003 at 03:34:50PM +0700, Kairos wrote:
> Hi jason, i can't create a database cluster with initdb, below are the
> error messages,
> can you help me ? I'm using WinXP prof with cygwin
>
> ---------------
> creating template1 database in /usr/local/pgsql//base/1... FATAL: could
> not create shared memory segment: Not enough core
> DETAIL: Failed system call was shmget(key=1, size=1081344, 03600).
> HINT: 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 1081344 bytes), reduce PostgreSQL's shared_buffers
> parameter (currently 50) and/or its max_connections parameter (currently
> 10).
> The PostgreSQL documentation contains more information about
> shared memory configuration.
>
> initdb: failed
> -----------------

Please read the README. Specifically, the following:

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.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6