Witam!
Wlasnie chcialam rozpoczac prace nad projektem, ktory mialbyc pisany w osadzonym sqlu.
zdecydowalam sie wiec na c i postgresa.
jednak jak sie szybko okazalo instalacja pod windowsem to prawdziwa zmora.
Najpierw zainstalowalam wresje 8.0.3 dla win ale tam nie ma prekompilatora!
Zainstalowalam wiec cygwina i pakiet cygipc i wszytsko byloby juz pieknie gdyby nie nastepujace bledy:
podczas inicjowania bazy danych
initdb -D /usr/local/pgsql/data
wyswietla mi nastepujacy blad:
===============================
creating template1 database in /usr/local/pgsql/data/base/1... FATAL: could not create semaphores: No space left on dev
ice
DETAIL: Failed system call was semget(1, 17, 03600).
HINT: This error does *not* mean that you have run out of disk space.
It occurs when either the system limit for the maximum number of semaphore sets (SEMMNI), or the system wide max
imum number of semaphores (SEMMNS), would be exceeded. You need to raise the respective kernel parameter. Alternativel
y, reduce PostgreSQL's consumption of semaphores by reducing its max_connections parameter (currently 10).
The PostgreSQL documentation contains more information about configuring your system for PostgreSQL.
initdb: failed
initdb: removing data directory "/usr/local/pgsql/data"
[1]+ Done ipc-daemon.exe
=================================
wczesniej mialam blad:
setting default max_connections signal 12
ale znalazlam w necie taki sposob ktory przez chwile dzialal:
===============================
I was having trouble with signal 12's. Lots of people have the problem. A recipe to fix is on top. A log of an erroneous trial and a successful trial are below...
These are cleaned up instructions. I got help from this message:
http://archives.postgresql.org/pgsql-bugs/...11/msg00174.php
# run cygserver-config
cygserver-config
# start the cygserver
cygrunsrv -S cygserver
# set the CYGWIN environment variable
export CYGWIN=server
# unset the LANG environment variable
unset LANG
# check [Control Panel] -> [Administrative Tools] ->
# [Services]. Should have a Service with name "CYGWIN cygserver"
# with STATUS = "Started"
# run initdb
initdb -d -D /cygdrive/e/david/pgdata
====================================
ale wowczas nie moglam polaczyc sie z serverem:
$ psql -test
psql: could not connect to server: Bad file descriptor
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
====================================
spedzilam juz caly dzien na probach konfiguracji.
mam do oddania projekt na wtorek i strasznie zalezy mi na czasie.
bylabym wam bardzo wdzieczna za pomoc
pozdrawiam
Eve