Re: [GENERAL] could not create shared memory segment in Windows XP
Have you got Cygwin installed? I had similar problems due to Cygwin being eariler in my PATH than Pg. Regards, Ben Andrus [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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:\pgsqlbin\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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] could not create shared memory segment in Windows XP
On 4/5/06, Andrus [EMAIL PROTECTED] 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
[GENERAL] could not create shared memory segment in Windows XP
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:\pgsqlbin\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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly