Skip site navigation (1) Skip section navigation (2)

Re: signal 12 -SOLVED - solution included!! - with max_connections

From: "zuhans(at)iname(dot)com" <zuhans(at)iname(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: signal 12 -SOLVED - solution included!! - with max_connections
Date: 2004-07-05 09:35:33
Message-ID: 40E920E5.1070807@iname.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
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:

>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(at)iname(dot)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
>>    
>>
>
>  
>

pgsql-cygwin by date

Next:From: Kevin MarthDate: 2004-07-05 11:46:27
Subject: Re: initdb fails with invalid argument to shmat
Previous:From: Larry WippermanDate: 2004-07-05 08:16:50
Subject: initdb error: create shared memory segment: Function not implemented

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group