PostgreSQL not working from start

PostgreSQL not working from start

[Wynfield Henman]

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

Re: PostgreSQL not working from start

[marco atzeri]

On 3/22/2013 8:17 AM, Wynfield Henman wrote:
> 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]


have you started cygserver before ?

$ cygrunsrv.exe -S cygserver

If still it does not work, please follow:
> Problem reports:       http://cygwin.com/problems.html


"Run cygcheck -s -v -r > cygcheck.out and include that file as an 
attachment in your report. Please do not compress or otherwise encode 
the output. Just attach it as a straight text file so that it can be 
easily viewed. "

Regards
Marco



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