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=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
MIME-Version: 1.0
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
Content-Type: text/plain; charset=ISO-8859-1

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