Forum OpenACS Q&A: Could I install PostgreSQL under Windows 2000?

Hi:

In the Installation Guide for Windows2000, there is only instruction for Oracle 8. If that means only Oracle 8 could run under Windows2000 not PostgreSQL? If it's not the case, where could I find the installation guide for PostgreSQL for Windows2000?

Thanks so much

Winny

Collapse
Posted by Jamie Rasmussen on
If you want to install OpenACS on Windows, you probably want to try one of the installers first. See:
https://openacs.org/xowiki/openacs-system-install-windows-server
http://www.project-open.org/download/win/

I believe both of these use the Cygwin port of PostgreSQL. It is possible to install OpenACS on native PostgreSQL as well. I did it with 8.0, I don't think OpenACS supports PostgreSQL 8.1 yet.

I have old documentation on manually installing on PostgreSQL / Cygwin at http://www.jamierasmussen.com/documents/programming/openacs/install_postgresql.adp but it can be complicated, so I don't recommend it. I'm hoping to write an updated procedure for manual installation soon.

Collapse
Posted by Winny Zhang on
Hi Jamie:

Thanks a lot for your info. I need you clarify a little bit more.
The Windows installer says included all the necessary software, but not mentioned Cygwin. So I need download Cygwin and install it first or it's included already?

And what is native PostgreSQL? Is it PostgreSQL 8.0? Since you have done it, what you suggest?

Thank again.

Winny

Collapse
Posted by Jamie Rasmussen on
The installers should include the subset of Cygwin that is needed to run PostgreSQL. Native PostgreSQL is PostgreSQL compiled natively for Win32 instead of using the Cygwin emulation layer. 8.0 was the first version of PostgreSQL to have a native Win32 port.

The advantage to using one of the installers is that they include a compiled version of AOLserver and a version of OpenACS that they have been tested with. The versions of PostgreSQL and AOLserver they include are a few years old though.

I would suggest trying the installers first for anyone new to OpenACS on Win32. If you run into difficulties with the installer, or need the performance increase and bug fixes from newer versions of the pieces, switch to PostgreSQL 8.0 and a newer build of AOLserver.

Collapse
Posted by Winny Zhang on
Hi Jamie:

Thanks for your suggestion. Now I have the server ready and will try.

Thanks
Winny

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:

See configuration's example in Note 1 - Ver ejemplo de configuración en Nota 1

2. Type these commands - escribir estos comandos:

$ export CYGWIN=server
$ unset LANG
$ export PATH=/usr/bin:/usr/sbin:/usr/local/pgsql/bin:$PATH
$ export PGDATA=/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 handled
# 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 be
# 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 be
# 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 stderr.
# 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 concurrently.
# 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 = 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 mailto:pobox@verysmall.org