Thread: Re: signal 12 -SOLVED - solution included!! - with max_connections
hello mike,
thank your very much for your pointing me to the set-variable cygwin.
although i did "cygwin=server" in my script, i did too little. i missed the export-statement to the set-variable.
for everybody who is interested in my functioning scripts (on win-xp-home) i give it in here:
at first i do an initiation of my postgresql-db "pgini" and at the end i call my script "db-stop" to clean memory of processes (especially cygserver).
and after that i call my db with "db-start" every time i need it (i don't use it as a service, i don't use it for production just for programming), and at the end of my working with my db i call my "db-stop" again to clean memory. afterwards i exit cygwin or restart my db with "db-start".
now my scripts:
my "pgini":
#!/bin/sh
# the first very important set-variable
CYGWIN=server
export CYGWIN
# the second very important set-variable - to unset it worked for me (then language-setting is C).
unset LANG
echo
# the third very important set-variable
PATH=/usr/bin:/usr/sbin:$PATH
export PATH
#echo "IPC-Daemon starten..."
echo
echo "cygserver-config starting..."
cygserver-config
echo "sygserver starten..."
cygserver &
ps -f
echo
echo "initdb starting..."
initdb -D /var/postgresql/data
ps -f
./db-stop
now "db-start":
#!/bin/sh
CYGWIN=server
export CYGWIN
PATH=/usr/bin:/usr/sbin:$PATH
export PATH
echo
echo "sygserver starting..."
cygserver &
ps -f
echo
echo "PostgreSQL starting..."
postmaster -i -D /var/postgresql/data &
ps -f
and finally "db-stop":
#!/bin/sh
echo
echo "PostgreSQL finishing..."
pg_ctl stop -w -D /var/postgresql/data -s -m smart
ps -f
echo
echo "cygserver finishing..."
kill $(ps -f | grep cygserver | awk '{print $2}')
ps -f
greetings and thanks to all
hans
mike g schrieb:
thank your very much for your pointing me to the set-variable cygwin.
although i did "cygwin=server" in my script, i did too little. i missed the export-statement to the set-variable.
for everybody who is interested in my functioning scripts (on win-xp-home) i give it in here:
at first i do an initiation of my postgresql-db "pgini" and at the end i call my script "db-stop" to clean memory of processes (especially cygserver).
and after that i call my db with "db-start" every time i need it (i don't use it as a service, i don't use it for production just for programming), and at the end of my working with my db i call my "db-stop" again to clean memory. afterwards i exit cygwin or restart my db with "db-start".
now my scripts:
my "pgini":
#!/bin/sh
# the first very important set-variable
CYGWIN=server
export CYGWIN
# the second very important set-variable - to unset it worked for me (then language-setting is C).
unset LANG
echo
# the third very important set-variable
PATH=/usr/bin:/usr/sbin:$PATH
export PATH
#echo "IPC-Daemon starten..."
echo
echo "cygserver-config starting..."
cygserver-config
echo "sygserver starten..."
cygserver &
ps -f
echo
echo "initdb starting..."
initdb -D /var/postgresql/data
ps -f
./db-stop
now "db-start":
#!/bin/sh
CYGWIN=server
export CYGWIN
PATH=/usr/bin:/usr/sbin:$PATH
export PATH
echo
echo "sygserver starting..."
cygserver &
ps -f
echo
echo "PostgreSQL starting..."
postmaster -i -D /var/postgresql/data &
ps -f
and finally "db-stop":
#!/bin/sh
echo
echo "PostgreSQL finishing..."
pg_ctl stop -w -D /var/postgresql/data -s -m smart
ps -f
echo
echo "cygserver finishing..."
kill $(ps -f | grep cygserver | awk '{print $2}')
ps -f
greetings and thanks to all
hans
mike g schrieb:
Hello, My first guess would be that you added cygwin=server as a local user variable instead of a system variable. If you added it to the variable section in the top half of the screen then it was a user variable. Add it to the lower section instead. Mike On Sat, 2004-07-03 at 10:09, zuhans@iname.com wrote:hello, after downloading the latest cygwin and postgresql, adding cygwin=server and configuring and starting cygserver i want to do a dbinit but i get signal 12-errors: one when "selecting default max_connections" and one when "selecting default shared_buffers". what did i miss? greetings hans ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html