Postgres Pro
Downloads
Home   >   mailing lists

Thread: could not create shared memory segment in Windows XP

could not create shared memory segment in Windows XP

From
"Andrus"
Date:
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"

Re: could not create shared memory segment in Windows XP

From
"Ben Trewern"
Date:
Have you got Cygwin installed?  I had similar problems due to Cygwin being
eariler in my PATH than Pg.

Regards,

Ben

"Andrus" <eetasoft@online.ee> wrote in message
news:e10r6s$11km$1@news.hub.org...
> 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"
>
>
>

Re: could not create shared memory segment in Windows XP

From
"Merlin Moncure"
Date:
On 4/5/06, Andrus <eetasoft@online.ee> wrote:
> 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 ?


are you trying to initdb from terminal services?  if so, create a one
line batch file containing the initdb startup, and run it with
postgres user login.

merlin