PostgreSQL Discussion - could not create shared memory segment in Windows XP

Author

could not create shared memory segment in Windows XP

Andrus

2006-04-05, 11:31 am

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_SUPERUSERNA
ME=postgres
POSTGRES_BKI=C:/pgsql/share/postgres.bki
POSTGRES_DESCR=C:/pgsql/share/postgres.description
POSTGRESQL_CONF_SAMP
LE=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"

Ben Trewern

2006-04-07, 7:34 am

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@n
ews.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_SUPERUSERNA
ME=postgres
> POSTGRES_BKI=C:/pgsql/share/postgres.bki
> POSTGRES_DESCR=C:/pgsql/share/postgres.description
> POSTGRESQL_CONF_SAMP
LE=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"
>
>
>

Merlin Moncure

2006-04-07, 8:25 pm

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links