could not create shared memory segment in Windows XP

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: could not create shared memory segment in Windows XP
Date: 2006-04-05 16:28:05
Message-ID: e10r6s$11km$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm unable to create database cluster in Windows 2000 server.

initdb returns error

FATAL: could not create shared memory segment: No such file or directory

any idea how to create cluster in Windows 2000 ?

Task MAnager shows physical memory:

Total: 392664
Available: 81860
System Cache: 157xxx

If available physical memory is too low, how to increate it (decrease system
cache) ?

Andrus.

C:\pgsql>bin\initdb -E=UTF8 -d -D data
Running in debug mode.
VERSION=8.1.3
PGDATA=data
share_path=C:/pgsql/share
PGPATH=C:/pgsql/bin
POSTGRES_SUPERUSERNAME=postgres
POSTGRES_BKI=C:/pgsql/share/postgres.bki
POSTGRES_DESCR=C:/pgsql/share/postgres.description
POSTGRESQL_CONF_SAMPLE=C:/pgsql/share/postgresql.conf.sample
PG_HBA_SAMPLE=C:/pgsql/share/pg_hba.conf.sample
PG_IDENT_SAMPLE=C:/pgsql/share/pg_ident.conf.sample
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale Estonian_Estonia.1257.

creating directory data ... ok
creating directory data/global ... ok
creating directory data/pg_xlog ... ok
creating directory data/pg_xlog/archive_status ... ok
creating directory data/pg_clog ... ok
creating directory data/pg_subtrans ... ok
creating directory data/pg_twophase ... ok
creating directory data/pg_multixact/members ... ok
creating directory data/pg_multixact/offsets ... ok
creating directory data/base ... ok
creating directory data/base/1 ... ok
creating directory data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in data/base/1 ... DEBUG: TZ "Europe/Helsinki"
matc
hes Windows timezone "FLE Daylight Time"
DEBUG: invoking IpcMemoryCreate(size=1327104)
DEBUG: mapped win32 error code 161 to 2
FATAL: could not create shared memory segment: No such file or directory
DETAIL: Failed system call was shmget(key=1, size=1327104, 03600).
DEBUG: proc_exit(1)
DEBUG: shmem_exit(1)
DEBUG: exit(1)
child process was terminated by signal 1
initdb: removing data directory "data"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonas F. Henriksen 2006-04-05 16:37:26 Re: full join question...
Previous Message Neil Conway 2006-04-05 16:19:16 Re: Oracle outer join syntax