Thread: initdb - Error FATAL: shmat(id=1179648) failed

initdb - Error FATAL: shmat(id=1179648) failed

From
Evandro Spader
Date:
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/


Re: initdb - Error FATAL: shmat(id=1179648) failed

From
"A DAVID"
Date:
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
>