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:	<4130583A.1020403@x-ray.at>
Date:	Sat, 28 Aug 2004 12:02:34 +0200
From:	Reini Urban <rurban AT x-ray DOT at>
User-Agent:	Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8a2) Gecko/20040714
MIME-Version:	1.0
To:	Superbiskit AT cox DOT net, Cygwin General Discussion <cygwin AT cygwin DOT com>
Subject:	Re: [BUG] Bad File Descriptor while trying to set up postgresql
References:	<412F9A8B DOT 5040305 AT cox DOT net>
In-Reply-To:	<412F9A8B.5040305@cox.net>
X-IsSubscribed:	yes

David A. Cobb schrieb:
> At first, this stopped me entirely from initializing postgres; however, 
> today the initdb & createdb succeeded -- I don't know what changed.  In 
> any case, references to the database directory during the initdb incur a 
> Bad File Descriptor complaint when trying to set permissions.
> 
> The partition where the database lives is FAT32 -- it needs to be 
> because it is also visible from my Linux dual-boot. I know permissions 
> on a FAT32 volume are, at best, faked.  But IMHO it shouldn't incur this 
> sort of error.

Win95 or NT?

> ------------------------------------------------------------------------
> 
> Running in debug mode.
> 
> initdb: internal variables:
>   PGDATA=/var/database/pgsql
>   datadir=/usr/share/postgresql
>   PGPATH=/usr/bin
>   ENCODING=UTF-8
>   ENCODINGID=6
>   POSTGRES_SUPERUSERNAME=postgres
>   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 "postgres".
> This user must also own the server process.
> 
> The database cluster will be initialized with locale C.
> 
> fixing permissions on existing directory /var/database/pgsql... chmod: changing permissions of `/var/database/pgsql': Bad file descriptor
> 
> initdb: failed
> total 0
> drwxr-xr-x    2 postgres None            0 Aug  5 11:27 Debian_Packages
> drwxr-xr-x    5 postgres None            0 Aug 25 13:25 Marathon
> drwxr-xr-x    3 postgres None            0 Aug 25 11:22 Zeos
> drwxr-xr-x    2 postgres None            0 Aug 25 22:24 pgsql

FAT is not supported.
See http://cygwin.com/cygwin-ug-net/highlights.html#OV-HI-PERM
Don't use the postgres user, use your own on FAT (file ownership doesn't 
work on FAT)

But this can be easily overcome since /bin/initdb is only a shell script.
find the line of your error: line 515

   chmod go-rwx "$PGDATA" || exit_nicely

apply the needed permissions by yourself, comment it out and run again.
CYGWIN=ntea should help to fake perms on a FAT IMHO, but I am not sure.

BTW: cygcheck must accompony a real bug report.
So I cannot see your CYGWIN and OS environment.
See http://cygwin.com/problems.html

real postgres bug reports should also go to pgsql-bugs AT postgresql DOT org, 
but the cygwin maintainer usually does that for you if he can verify that.
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

--
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/

- Raw text -