PostgreSQL for Windows - can't get postgresql to start on cygwin...

Author

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

Ed Hartnett

2005-10-03, 3:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

pobox@verysmall.org

2006-01-30, 3:23 am

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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

renu_p_r@yahoo.com

2006-02-02, 1:24 pm

Hi,
I have a question regarding CYGWIN/X. I downloaded and installed
cygwin. Then added CYGWIN/X. Then I tried to run the default
/usr/X11R6/bin/startxwin.bat to open a x-windows session. I got the
error : could not find xterm anywhere. I do have xterm on the UNIX
server. Do I need to download xterm for my PC?
Basically : I want to open a x-windows session. Anyother way. or any
other freeware I can use? Thanks for your help.

"pobox@verysmall.org" wrote:
> 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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

Sponsored Links