postgreSQL v8.0 RC3 NLS for OS/2

WARNING do not run these programs under 4OS2 they will not work - use CMD  \WARNING

WARNING the software will not work on K6-2 or Pentium Pro machines         \WARNING
WARNING this is caused by the use of the FXSAVE instruction in fork()      \WARNING
WARNING other machines affected are Pentium I and early PII machines < 333 \WARNING

----------------------------------------------------------------------
New things

- updated to RC3 code level
- added support for NLS messages

Problems fixed in RC3 update
- locale handling fixed so that string handing for order by, group by, distinct,
  and any other character comparisons work.

Problems fixed in update D
- character string comparisons were failing in ordey, group by, distinct
  and any other character comparisons. This is possibly a locale support
  problem in the C runtime. Collating sequence is set to C for all locales.

Problems fixed in update C
- stats collection re-enabled
- "socket leak" in stats collection fixed

Problems fixed in update B
- pg_ctl with the -l logfile option resulted in a never ending database
  function after pg_ctl stop was issued

Problems fixed in update A
- Turned off stats collection to avoid listen sockets problem and/or start up error
- fixed problem with false shared memory allocation error when memory allocated over
  the 2 gigabyte boundary
- fixed problem with wrong shared memory header definitions being used

RC 2 Update
- Updated build with release candidate 2 code
- fixed problems with pg_ctl starting the database

-------- notes on usage ----------------------------------------------


WARNING - using the package with kernel 14.062 caused failures in
building a database. Using 14.100c (2004-10-29) solved the problem.

WARNING - using a language setting with a trailing _EURO does not
work properly. Instead of

set LANG=de_DE_EURO

use

set LANG=de_DE

or use the --locale switch on initdb
initdb --locale=de_DE


Please refer to the documentation in doc\html for all kinds of
good information that you may need to know

This is just a zip of the install directory

\pgsqlrc2\bin is the executables
\pgsqlrc2\doc is the documentation
\pgsqlrc2\include is the developemnt headers
\pgsqlrc2\lib is DLLs that postgreSQL loads
\pgsqlrc2\man is the man pages
\pgsqlrc2\share is SQL scripts and samples

Unzip this thing somewhere (as you undoubtably have to read this)


the \pgsqlrc2\bin directory contains the LIBC06b2.dll file that is 
a C runtime for gcc 3.3.5 beta2

NOTES

When you start the program you may get LOG notices that a directory or
filename cannot be found. This is related to problems locating time zone
data for the TZ variable setting on the machine.

The environment variable PGDATA can be used to set the database directory

NOTE - the PGDATA value can contain driver letters like 
set PGDATA=G:\newdata
The executables and the databases can reside on different disk drives.

ALWAYS use the SET USE_HOSTS_FIRSTS=Y setting in the config.sys file
or enter it before starting the postmaster. There is a HUGE timeout
otherwise while it trys to find "localhost". Make sure the \mptn\etc\hosts
file has an entry for 127.0.0.1 as localhost

OPERATATION

to start
set PGDATA=x:/whatever
cd to \pgsqlrc2\bin
initdb

to run postmaster 
set PGDATA=x:/whatever
cd to \pgsqlrc2\bin
postmaster

The default owner ID is postgres

to create a database
set PGDATA=x:/whatever
cd to \pgsqlrc2\bin
createdb -U postgres database-name


to run the query interface
set PGDATA=x:/whatever
cd to \pgsqlrc2\bin
psql -U postgres -d database-name


Please send all bug reports to me

lsunley@mb.sympatico.ca

