Thread: postgresSql cygwin

postgresSql cygwin

From
Javier@t-online.de (Xaver)
Date:
Hi,

I'm tryind to run postgres, but when I start the "initdb -d -D
/var/postgres/base
I receive the following error message:

Running with debug mode on.

initdb variables:
  PGDATA=eror
  datadir=/usr/share/postgresql
  PGPATH=/usr/bin
  ENCODING=
  ENCODINGID=0
  POSTGRES_SUPERUSERNAME=Administrator
  POSTGRES_BKI=/usr/share/postgresql/postgres.bki
  POSTGRES_DESCR=/usr/share/postgresql/postgres.description
  POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample
  PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample
  PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample
The files belonging to this database system will be owned by user
"Administrator".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory eror... ok
creating directory eror/base... ok
creating directory eror/global... ok
creating directory eror/pg_xlog... ok
creating directory eror/pg_clog... ok
creating template1 database in eror/base/1... DEBUG:  invoking
IpcMemoryCreate(size=942080)
IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not
implemented
DEBUG:  proc_exit(1)
DEBUG:  shmem_exit(1)
DEBUG:  exit(1)

initdb failed.

 I got a look on the FAQ, I found the following: If the error message is
IpcSemaphoreCreate: semget failed (No space
   left on device) then your kernel is not configured with enough
   semaphores. Postgres needs one semaphore per potential backend
   process. A temporary solution is to start postmaster with a smaller
   limit on the number of backend processes. Use -N with a parameter less
   than the default of 32. A more permanent solution is to increase your
   kernel's SEMMNS and SEMMNI parameters.

But again when I try to run initdb with the -N16 parameter postgres says,
Invalid option -N16.

Pls. Help

Xaver


Re: postgresSql cygwin

From
Justin Clift
Date:
Hi Xaver,

Xaver wrote:
<snip>
> creating directory eror... ok
> creating directory eror/base... ok
> creating directory eror/global... ok
> creating directory eror/pg_xlog... ok
> creating directory eror/pg_clog... ok
> creating template1 database in eror/base/1... DEBUG:  invoking
> IpcMemoryCreate(size=942080)
> IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not
> implemented
> DEBUG:  proc_exit(1)
> DEBUG:  shmem_exit(1)
> DEBUG:  exit(1)
>
> initdb failed.

Have you installed the required ipc daemon software yet?  Instructions
about getting PostgreSQL up and running on cygwin are available at:

http://www.tishler.net/jason/software/postgresql/postgresql-7.3.2.README

Hope this helps.

:-)

Regards and best wishes,

Justin Clift


<snip>
> Xaver


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi