Re: [GENERAL] could not create shared memory segment in Windows XP

2006-04-07 Thread Ben Trewern
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

2006-04-07 Thread Merlin Moncure
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

2006-04-05 Thread Andrus
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