X-Recipient:	archive-cygwin AT delorie DOT com
DomainKey-Signature:	a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:date:message-id:subject:from:to
	:content-type; q=dns; s=default; b=gXy9RSEXzLgrcPr9puSu6dfZL/XcL
	lN6IQGn/IJPucB1VpsS74nuAerB6rQO3D0O3rDIvMMaFvBbJLJMkyBLmIrahOJ5H
	+wfVP9TfleEcaT3Dv2JEur/jzD67FNRqy+6gsfc85Ggauvc9QJ9e7f73g2LGAuKA
	j8WuuNotDVNR/0=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:date:message-id:subject:from:to
	:content-type; s=default; bh=R5TVHQSpiRmRPTDE6XLM5SilnpI=; b=F7b
	rYFF/aUXln9W3ZvUktHt9x5iJBNhEnwE+xYlN1+sNK2y8932SM+wTHRCWkWIkadt
	wjSICKze8tQaB/vlZhvtud9soPxr1dlgVnmYw+RewtQ95/1VQTLCQsD4C0CSBYB+
	cxG0PTXS7MHlL5l5vlFLFICIj+2fqKl0WbdS2dLo=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
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
X-Spam-SWARE-Status:	No, score=-3.0 required=5.0 tests=AWL,BAYES_00,FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,TW_TD autolearn=ham version=3.3.1
MIME-Version:	1.0
X-Received:	by 10.112.49.3 with SMTP id q3mr565474lbn.92.1363936632389; Fri, 22 Mar 2013 00:17:12 -0700 (PDT)
Date:	Fri, 22 Mar 2013 16:17:12 +0900
Message-ID:	<CAM-A7MCJC5PHFpFOYOtkeuihwTWiqTreeDob-s=qey0iJOPCZg@mail.gmail.com>
Subject:	PostgreSQL not working from start
From:	Wynfield Henman <wynfield AT gmail DOT com>
To:	cygwin AT cygwin DOT com

This is apparently a common problem.
I' m trying to install and get PostgreSQL up and running.

Yes, CYGWIN, the environment variable is set to "server" and file/dir
permissions are set for the user and have r/w permissions.

No matter if I use:

   initdb or  pg_ctl initdb -D $DBDIR -l $DB_ADMINLOG -o "-X $XLOGDIR
-U $DB_OWNER"

No database is initialized and the "Bad system call" messages in a
downward counting loop of shared_buffers appears on the screen. ending
with]
...creating configuration files ... ok
creating template1 database in /usr/local/share/db-datadir/base/1 ...
child process was terminated by signal 12: Bad system call
initdb: removing contents of data directory "/usr/local/share/db-datadir"
initdb: removing contents of transaction log directory
"/usr/local/share/db-logdir"

---

Then tried to use  pg_ctl start -D $DBDIR -l $DB_ADMINLOG
to get the server up and it failed (it did say it was looking in
$DBDIR for the config file which makes, sense as initdb failed and
deletes the contents it just made)

Still should be able to start the server, I think, so tried
$ pg_ctl start -
server starting

It says server starting.  But, no server was started or if it did it
did in its infancy, but no event logs show a service being started.

What are steps to use to get this database up and running. Would not
using pg_ctl or init_db and just starting a server and create by hand
a new database be easier an workable, or if now who to make them work
or fix them.?

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

- Raw text -