Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
Message-ID: <40FCC206.9050108@hq.astra.ph>
Date: Tue, 20 Jul 2004 14:56:06 +0800
From: Carlo Florendo y Flora <list-subscriber AT hq DOT astra DOT ph>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7) Gecko/20040616
MIME-Version: 1.0
To: Manuel Tejada <mantemu AT yahoo DOT com DOT mx>
Cc: cygwin AT cygwin DOT com
Subject: Re: I can't inicializate PostgreSQL
References: <20040720041019 DOT 20141 DOT qmail AT web53704 DOT mail DOT yahoo DOT com>
In-Reply-To: <20040720041019.20141.qmail@web53704.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes

Manuel Tejada wrote:

>Thanks Carlo Florendo y Flora and Igor Pechtchanski 
>for your very illustrative comments. Based on that I
>follow the procedure again for install PostgreSQL in
>my Window ME. Now I can run Cygserver but The
>initialization of PostgreSQL failled. See the output I
>got: 
>
>--------------------------------
>
>admin AT alejo ~
>$ CYGWIN=server
>
>admin AT alejo ~
>$ export CYGWIN
>
>admin AT alejo ~
>$ /usr/sbin/cygserver &
>[1] 901443
>
>admin AT alejo ~
>$ cygserver: Initialization complete.  Waiting for
>requests.
>// I had to press ENTER because the System really was
>wainting for something
>
>admin AT alejo ~
>$ initdb -D /usr/share/postgresql/data
>The files belonging to this database system will be
>owned by user "admin".
>This user must also own the server process.
>
>The database cluster will be initialized with locale
>C.
>
>creating directory /usr/share/postgresql/data... ok
>creating directory /usr/share/postgresql/data/base...
>ok
>creating directory
>/usr/share/postgresql/data/global... ok
>creating directory
>/usr/share/postgresql/data/pg_xlog... ok
>creating directory
>/usr/share/postgresql/data/pg_clog... ok
>selecting default max_connections... 10
>selecting default shared_buffers... 50
>creating configuration files... ok
>creating template1 database in
>/usr/share/postgresql/data/base/1... FATAL: 
>shmat(id=1179648) failed: Invalid argument
>
>initdb: failed
>initdb: removing data directory
>"/usr/share/postgresql/data"
>
>---------------------------------------
>
>Really I don't know what does meant the line "FATAL: 
>shmat(id=1179648) failed: Invalid argument".
>  
>
If you check the the most recent posts on the postgresql mailing list 
archive (pgsql-cygwin), a similar problem has been posted but a solution 
has not yet been proposed.
However, it says that there could be a need to modify the cygserver.conf 
file.

shmat has something to do with shared memory.   Thus, try disabling 
shared memory on cygserver.conf.  Look for the line which says:

#kern.srv.sharedmem yes

Uncomment it and change the yes to no.  Restart cygserver, remove the 
contents of /usr/share/postgresql/data and run  initdb.  Let's see what 
happens.

Thanks!

Best Regards,

Carlo
------
Carlo Florendo
Astra Philippines Inc.
www.astra.ph










--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/