Обсуждение: initdb - Error FATAL: shmat(id=1179648) failed
I am trying to (for the first time) setup PostgreSQL version 7.4.3) on windows 98. I have cygwin version 1.5.10 installed and running. However, when I give "initdb -D /usr/local/pgsql/data" command in a cygwin window, I get an error "initdb failed" $ initdb -D /var/lib/pgsql/data The files belonging to this database system will be owned by user "EVANDRO". This user must also own the server process. The database cluster will be initialized with locale C. creating directory /var/lib/pgsql/data... ok creating directory /var/lib/pgsql/data/base... ok creating directory /var/lib/pgsql/data/global... ok creating directory /var/lib/pgsql/data/pg_xlog... ok creating directory /var/lib/pgsql/data/pg_clog... ok selecting default max_connections... 10 selecting default shared_buffers... 50 creating configuration files... ok creating template1 database in /var/lib/pgsql/data/base/1... FATAL: shmat (id=1179648) failed: Invalid argument initdb: failed initdb: removing data directory "/var/lib/pgsql/data" Comments: The cygserver is running in other DOS window (according "How to start Cygserver" in cygserver.README) Checking the most recent posts on the postgresql mailing list (apparently this error happens only in Windows 98/Me), I try modify the cygserver.conf: kern.srv.sharedmem no kern.ipc.semmns 100 But don�t works.... Any pointers ? It will be great help! _________________________________________________________ Voce quer um iGMail protegido contra v�rus e spams? Clique aqui: http://www.igmailseguro.ig.com.br Ofertas imperd�veis! Link: http://www.americanas.com.br/ig/
Hi Evandro ! There is a bug in the PostgreSQL 7.4.3. Visit the following link (on the official mailing list of Cygwin) : http://cygwin.com/ml/cygwin/2004-08/msg00060.html Project co-leader works on this. I installed Cygwin without PostgreSQL using setup.exe. Then I install postgresql 7.4.2 available in the packages from Cygwin. : This works seems to works fine. Attention : Installation directory are not the same than with the 7.4.3 version. A DAVID "Evandro Spader" <evspader@ig.com.br> a �crit dans le message de news:20040803224013.4C24DD1B171@svr1.postgresql.org... > I am trying to (for the first time) setup PostgreSQL > version 7.4.3) on windows 98. > I have cygwin version 1.5.10 installed and running. > > However, when I give "initdb -D /usr/local/pgsql/data" > command in a cygwin window, I get an error "initdb failed" > > $ initdb -D /var/lib/pgsql/data > The files belonging to this database system will be > owned by user "EVANDRO". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > creating directory /var/lib/pgsql/data... ok > creating directory /var/lib/pgsql/data/base... ok > creating directory /var/lib/pgsql/data/global... ok > creating directory /var/lib/pgsql/data/pg_xlog... ok > creating directory /var/lib/pgsql/data/pg_clog... ok > selecting default max_connections... 10 > selecting default shared_buffers... 50 > creating configuration files... ok > creating template1 database > in /var/lib/pgsql/data/base/1... FATAL: shmat > (id=1179648) failed: Invalid argument > > initdb: failed > initdb: removing data directory "/var/lib/pgsql/data" > > Comments: > > The cygserver is running in other DOS window > (according "How to start Cygserver" in cygserver.README) > > Checking the most recent posts on the postgresql > mailing list (apparently this error happens only in > Windows 98/Me), I try modify the cygserver.conf: > > kern.srv.sharedmem no > kern.ipc.semmns 100 > > But don�t works.... > > Any pointers ? It will be great help! > > _________________________________________________________ > Voce quer um iGMail protegido contra v�rus e spams? > Clique aqui: http://www.igmailseguro.ig.com.br > Ofertas imperd�veis! Link: http://www.americanas.com.br/ig/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >