Thread: can't get postgresql to start on cygwin...

Howdy all!

I have an updated cygwin installation including postgres, but when I
try and start it (according the the instructions here:
http://www.postgresql.org/docs/faqs.FAQ_CYGWIN.htmlhttp://www.postgresql.org/docs/faqs.FAQ_CYGWIN.html),
I get a bunch of errors when trying to run initdb:

initdb -D /usr/local/pgsql/data -W -E LATIN1
The files belonging to this database system will be owned by user
"Ed".
This user must also own the server process.

The database cluster will be initialized with locale ENU.

creating directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
selecting default max_connections... /usr/bin/initdb: line 572:   172
Bad system call         "$PGPATH"/postgres -boot -x0 $TEST_OPT
template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 572:   820 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 572:  1272 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 572:  1780 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 572:   460 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 572:   956 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
10
selecting default shared_buffers... /usr/bin/initdb: line 585:  1060
Bad system call         "$PGPATH"/postgres -boot -x0 $TEST_OPT
template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 585:  1508 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 585:  1352 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 585:   420 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 585:  1760 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 585:   312 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 585:   232 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 585:  1796 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 585:   496 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 585:  1888 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
/usr/bin/initdb: line 585:  1512 Bad system call
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null
2>&1
50
creating configuration files... ok
creating template1 database in /usr/local/pgsql/data/base/1... FATAL:
invalid value for parameter "lc_messages": "ENU"

initdb: failed
initdb: removing data directory "/usr/local/pgsql/data"
bash-3.00$


--
Ed Hartnett  -- ed@unidata.ucar.edu

Hi,

I just sent this for another person (just subscribed to the list and
read all this from the web site so my replies are not really RE).

Hope this helps, but if not, let me know.

Iv

--

It seems that you are missing cygserver.

I am just doing some testing of 8.0.4 vs 8.1.2 under cygwin and I get
the same when I forget cygserver.

After you install cygwin, do the following -

export CYGWIN=server (not clear if needed, try without it)
unset LANG (not clear if needed, try without it)
export PATH=/usr/bin:/usr/sbin:/usr/local/pgsql/bin:$PATH
/usr/bin/cygserver-config
cygserver &

Then you do -

./configure
make
make install

in the source directory.

Then -

export CYGWIN=server (makes initdb use the cygserver)
initdb -D /usr/local/pgsql/data

This should work.