Re: pgsql on cygwin problem
"jmbigi (sent by Nabble.com)" <[email protected]> Sun, 29 Jan 2006 22:52:42 -0800 (PST)
| Newsgroups | gmane.comp.db.postgresql.cygwin |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_4475_30635335.1138603962488
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
keywords: cygwin postgresql windows 98 start iniciar arrancar SHMMAX
After 10 hours, despues de 10 horas...
Steps (all are mandatory) - Pasos (todos son obligatorios)
1. Configure cygserver (C:\cygwin\etc\cygserver.conf) - configurar:
=09See configuration's example in Note 1 - Ver ejemplo de configuraci=C3=B3=
n en Nota 1
2. Type these commands - escribir estos comandos:
=09$ export CYGWIN=3Dserver
=09$ unset LANG
=09$ export PATH=3D/usr/bin:/usr/sbin:/usr/local/pgsql/bin:$PATH
=09$ export PGDATA=3D/usr/local/pgsql/data
3. Start cygserver - iniciar cygserver:
$ cygserver &
4. Initialize PostgreSQL - inicializar PostgreSQL:
$ initdb
5. Start the PostgreSQL postmaster - iniciar el postmaster de PostgreSQL:
$ postmaster &
6. Connect to PostgreSQL - conectar a PostgreSQL:
$ psql template1
Note 1 - Nota 1
# cygserver.conf, Copyright(C) 2003, 2005 Red Hat Inc.
#
# Contains configurable parameters for the cygserver.
#
# The format of this file is easy. Lines beginning with a hash `#' are
# comments and ignored. Lines consisting of only whitespaces are ignored.
# Any other line is a setting for cygserver.
# A setting consists of a name/value pair, separated by whitespace.
# Each line must only consist of one name/value pair.
# Lines must not be longer than 1023 characters.
#
# Some settings can be overridden by a command line switch. If so, it's
# mentioned below.
#
# Settings which are commented out will use the default values. These are
# mentioned below, too.
# kern.srv.cleanup_threads: No. of cygserver threads used for cleanup tasks=
.
# Default: 2, Min: 1, Max: 16, command line option -c, --cleanup-threads
#kern.srv.cleanup_threads 1
# kern.srv.request_threads: No. of cygserver threads used to serve
# application requests.
# Default: 10, Min: 1, Max: 310, command line option -r, --request-threads
#kern.srv.request_threads 1
# kern.srv.process_cache_size: No. of concurrent processes which can be han=
dled
# by Cygserver concurrently.
# Default: 62, Min: 1, Max: 310, command line option -p, --process-cache
#kern.srv.process_cache_size 1
# kern.srv.msgqueues: Determines whether XSI Message Queue support should b=
e
# started, "yes" (or "true", "y", "t", "1") or "no" (or "false", "n", "f", =
"0").
# These values are valid for all binary type options.
# Default is "yes". Command line option -q, --no-msgqueues
#kern.srv.msgqueues yes
# kern.srv.semaphores: Determines whether XSI Semaphore support should be
# started. Default is "yes". Command line option -s, --no-semaphores
#kern.srv.semaphores yes
# kern.srv.sharedmem: Determines whether XSI Shared Memory support should b=
e
# started. Default is "yes". Command line option -m, --no-sharedmem
#kern.srv.sharedmem yes
# LOGGING
# kern.log.syslog: Determines whether logging should go to the syslog,
# Default is "yes", if stderr is no tty, "no" otherwise.
# Command line option -y, --syslog or -Y, --no-syslog.
#kern.log.syslog no
# kern.log.stderr: Determines whether logging should go to stderr,
# Default is "yes", if stderr is a tty, "no" otherwise.
# Command line option -e, --stderr or -E, --no-stderr.
#kern.log.stderr no
# kern.log.level: Logging level. Valid values are 1 to 7 with a bigger
# value emitting more logging output. Default level is 6.
# Command line option -l, --log-level.
#kern.log.level 6
# kern.log.debug: Determines whether debug output should be printed to stde=
rr.
# Default is "no". Command line option -d, --debug
#kern.log.debug no
# XSI message queue parameters.
#
# Each message is broken up and stored in segments that are msgssz bytes
# long. For efficiency reasons, this should be a power of two. Also,
# it doesn't make sense if it is less than 8 or greater than about 256.
# kern.ipc.msgseg: Maximum no. of message queue segments hold concurrently.
# Default: 2048, Min: 256, Max: 65535
#kern.ipc.msgseg 256
# kern.ipc.msgssz: Size of segment in bytes. Must be a power of 2 value.
# Default: 8, Min: 8, Max: 1024
#kern.ipc.msgssz 8
# kern.ipc.msgmnb: Maximum no. of bytes in a single message queue.
# Default: 2048, Min: 1, Max: 65535
#kern.ipc.msgmnb 2048
# kern.ipc.msgmni: Maximum no. of message queue identifiers hold concurrent=
ly.
# Default: 40, Min: 1, Max: 1024
#kern.ipc.msgmni 1
# kern.ipc.msgtql: Maximum no. of messages hold concurrently.
# Default: 40, Min: 1, Max: 1024
#kern.ipc.msgtql 1
# XSI semaphore parameters
# kern.ipc.semmni: Maximum no. of semaphore identifiers hold concurrently.
# Default: 10, Min: 1, Max: 1024
kern.ipc.semmni 1024
# kern.ipc.semmns: Maximum no. of semaphores hold concurrently.
# Default: 60, Min: 1, Max: 1024
kern.ipc.semmns 1024
# kern.ipc.semmnu: Total no. of undo structures hold by server.
# Default: 30, Min: 1, Max: 1024
kern.ipc.semmnu 1024
# kern.ipc.semmsl: Maximum no. of semaphores per semaphore id.
# Default: 60, Min: 1, Max: 1024
kern.ipc.semmsl 1024
# kern.ipc.semopm: Maximum no. of operations per semop call.
# Default: 100, Min: 1, Max: 1024
kern.ipc.semopm 1024
# kern.ipc.semume: Maximum no. of undo entries per process.
# Default: 10, Min: 1, Max: 1024
kern.ipc.semume 1024
# kern.ipc.semvmx: Maximum value of a semaphore.
# Default: 32767, Min: 1, Max: 32767
#kern.ipc.semvmx 32767
# kern.ipc.semaem: Maximum value to adjust on process exit.
# Default: 16384, Min: 1, Max: 32767
#kern.ipc.semaem 16384
# XSI shared memory parameters
# kern.ipc.shmmaxpgs: Maximum pages available for XSI shared memory.
# Changing shmmaxpgs immediately affects setting SHMMAX. The relation
# between shmmaxpgs and SHMMAX is: SHMMAX =3D shmmaxpgs * getpagesize().
# Default: 8192, Min: 1, Max: 32767
kern.ipc.shmmaxpgs 32767
# kern.ipc.shmmni: Maximum number of shared memory segments, system wide.
# Default: 192, Min: 1, Max: 32767
kern.ipc.shmmni 32767
# kern.ipc.shmseg: Maximum number of shared memory segments per process.
# Default: 128, Min: 1, Max: 32767
kern.ipc.shmseg 32767
----
Thanks [email protected]
--
View this message in context: http://www.nabble.com/pgsql-on-cygwin-problem=
-t276962.html#a2655267
Sent from the PostgreSQL - cygwin forum at Nabble.com.
------=_Part_4475_30635335.1138603962488
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
keywords: cygwin postgresql windows 98 start iniciar arrancar SHMMAX
<br>
<br>After 10 hours, despues de 10 horas...
<br>
<br>Steps (all are mandatory) - Pasos (todos son obligatorios)
<br>
<br>1. Configure cygserver (C:\cygwin\etc\cygserver.conf) - configurar:
<br>
<br> See configuration's example in Note 1 - Ver=
ejemplo de configuraci=C3=B3n en Nota 1
<br>
<br>2. Type these commands - escribir estos comandos:
<br>
<br> $ export CYGWIN=3Dserver
<br> $ unset LANG
<br> $ export PATH=3D/usr/bin:/usr/sbin:/usr/loc=
al/pgsql/bin:$PATH
<br> $ export PGDATA=3D/usr/local/pgsql/data
<br>
<br>3. Start cygserver - iniciar cygserver:
<br>
<br> $ cygserver &
<br>
<br>4. Initialize PostgreSQL - inicializar PostgreSQL:
<br>
<br> $ initdb
<br>
<br>5. Start the PostgreSQL postmaster - iniciar el postmaster de PostgreSQ=
L:
<br>
<br> $ postmaster &
<br>
<br>6. Connect to PostgreSQL - conectar a PostgreSQL:
<br>
<br> $ psql template1
<br>
<br>
<br>Note 1 - Nota 1
<br>
<br># cygserver.conf, Copyright(C) 2003, 2005 Red Hat Inc.
<br>#
<br># Contains configurable parameters for the cygserver.
<br>#
<br># The format of this file is easy. Lines beginning with a hash `#=
' are
<br># comments and ignored. Lines consisting of only whitespaces are =
ignored.
<br># Any other line is a setting for cygserver.
<br># A setting consists of a name/value pair, separated by whitespace.
<br># Each line must only consist of one name/value pair.
<br># Lines must not be longer than 1023 characters.
<br>#
<br># Some settings can be overridden by a command line switch. If so=
, it's
<br># mentioned below.
<br>#
<br># Settings which are commented out will use the default values. T=
hese are
<br># mentioned below, too.
<br>
<br># kern.srv.cleanup_threads: No. of cygserver threads used for cleanup t=
asks.
<br># Default: 2, Min: 1, Max: 16, command line option -c, --cleanup-thread=
s
<br>#kern.srv.cleanup_threads 1
<br>
<br># kern.srv.request_threads: No. of cygserver threads used to serve
<br># =
application requests.
<br># Default: 10, Min: 1, Max: 310, command line option -r, --request-thre=
ads
<br>#kern.srv.request_threads 1
<br>
<br># kern.srv.process_cache_size: No. of concurrent processes which can be=
handled
<br># =
by Cygserver concurrently.
<br># Default: 62, Min: 1, Max: 310, command line option -p, --process-cach=
e
<br>#kern.srv.process_cache_size 1
<br>
<br># kern.srv.msgqueues: Determines whether XSI Message Queue support shou=
ld be
<br># started, "yes" (or "true", "y", "t=
", "1") or "no" (or "false", "n&quo=
t;, "f", "0").
<br># These values are valid for all binary type options.
<br># Default is "yes". Command line option -q, --no-msgque=
ues
<br>#kern.srv.msgqueues yes
<br>
<br># kern.srv.semaphores: Determines whether XSI Semaphore support should =
be
<br># started. Default is "yes". Command line option =
-s, --no-semaphores
<br>#kern.srv.semaphores yes
<br>
<br># kern.srv.sharedmem: Determines whether XSI Shared Memory support shou=
ld be
<br># started. Default is "yes". Command line option =
-m, --no-sharedmem
<br>#kern.srv.sharedmem yes
<br>
<br># LOGGING
<br>
<br># kern.log.syslog: Determines whether logging should go to the syslog,
<br># Default is "yes", if stderr is no tty, "no" other=
wise.
<br># Command line option -y, --syslog or -Y, --no-syslog.
<br>#kern.log.syslog no
<br>
<br># kern.log.stderr: Determines whether logging should go to stderr,
<br># Default is "yes", if stderr is a tty, "no" otherw=
ise.
<br># Command line option -e, --stderr or -E, --no-stderr.
<br>#kern.log.stderr no
<br>
<br># kern.log.level: Logging level. Valid values are 1 to 7 with a b=
igger
<br># value emitting more logging output. Default level is 6.
<br># Command line option -l, --log-level.
<br>#kern.log.level 6
<br>
<br># kern.log.debug: Determines whether debug output should be printed to =
stderr.
<br># Default is "no". Command line option -d, --debug
<br>#kern.log.debug no
<br>
<br># XSI message queue parameters.
<br>#
<br># Each message is broken up and stored in segments that are msgssz byte=
s
<br># long. For efficiency reasons, this should be a power of two. &n=
bsp;Also,
<br># it doesn't make sense if it is less than 8 or greater than about 256.
<br>
<br># kern.ipc.msgseg: Maximum no. of message queue segments hold concurren=
tly.
<br># Default: 2048, Min: 256, Max: 65535
<br>#kern.ipc.msgseg 256
<br>
<br># kern.ipc.msgssz: Size of segment in bytes. Must be a power of 2=
value.
<br># Default: 8, Min: 8, Max: 1024
<br>#kern.ipc.msgssz 8
<br>
<br># kern.ipc.msgmnb: Maximum no. of bytes in a single message queue.
<br># Default: 2048, Min: 1, Max: 65535
<br>#kern.ipc.msgmnb 2048
<br>
<br># kern.ipc.msgmni: Maximum no. of message queue identifiers hold concur=
rently.
<br># Default: 40, Min: 1, Max: 1024
<br>#kern.ipc.msgmni 1
<br>
<br># kern.ipc.msgtql: Maximum no. of messages hold concurrently.
<br># Default: 40, Min: 1, Max: 1024
<br>#kern.ipc.msgtql 1
<br>
<br># XSI semaphore parameters
<br>
<br># kern.ipc.semmni: Maximum no. of semaphore identifiers hold concurrent=
ly.
<br># Default: 10, Min: 1, Max: 1024
<br>kern.ipc.semmni 1024
<br>
<br># kern.ipc.semmns: Maximum no. of semaphores hold concurrently.
<br># Default: 60, Min: 1, Max: 1024
<br>kern.ipc.semmns 1024
<br>
<br># kern.ipc.semmnu: Total no. of undo structures hold by server.
<br># Default: 30, Min: 1, Max: 1024
<br>kern.ipc.semmnu 1024
<br>
<br># kern.ipc.semmsl: Maximum no. of semaphores per semaphore id.
<br># Default: 60, Min: 1, Max: 1024
<br>kern.ipc.semmsl 1024
<br>
<br># kern.ipc.semopm: Maximum no. of operations per semop call.
<br># Default: 100, Min: 1, Max: 1024
<br>kern.ipc.semopm 1024
<br>
<br># kern.ipc.semume: Maximum no. of undo entries per process.
<br># Default: 10, Min: 1, Max: 1024
<br>kern.ipc.semume 1024
<br>
<br># kern.ipc.semvmx: Maximum value of a semaphore.
<br># Default: 32767, Min: 1, Max: 32767
<br>#kern.ipc.semvmx 32767
<br>
<br># kern.ipc.semaem: Maximum value to adjust on process exit.
<br># Default: 16384, Min: 1, Max: 32767
<br>#kern.ipc.semaem 16384
<br>
<br># XSI shared memory parameters
<br>
<br># kern.ipc.shmmaxpgs: Maximum pages available for XSI shared memory.
<br># Changing shmmaxpgs immediately affects setting SHMMAX. The rela=
tion
<br># between shmmaxpgs and SHMMAX is: SHMMAX =3D shmmaxpgs * getpage=
size().
<br># Default: 8192, Min: 1, Max: 32767
<br>kern.ipc.shmmaxpgs 32767
<br>
<br># kern.ipc.shmmni: Maximum number of shared memory segments, system wid=
e.
<br># Default: 192, Min: 1, Max: 32767
<br>kern.ipc.shmmni 32767
<br>
<br># kern.ipc.shmseg: Maximum number of shared memory segments per process=
.
<br># Default: 128, Min: 1, Max: 32767
<br>kern.ipc.shmseg 32767
<br>
<br>----
<br>
<br>Thanks [email protected]
<br>
<br><hr align=3D"left" width=3D"300">
View this message in context: <a href=3D"http://www.nabble.com/pgsql-on-cyg=
win-problem-t276962.html#a2655267">Re: pgsql on cygwin problem</a><br>
Sent from the <a href=3D"http://www.nabble.com/PostgreSQL---cygwin-f767.htm=
l">PostgreSQL - cygwin</a> forum at Nabble.com.
------=_Part_4475_30635335.1138603962488--