This is the mail archive of the cygwin mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

[ANNOUNCEMENT] Experimental package: postgresql-8.0.0cvs-1


I've made the latest snapshot of postgresql-8.0.0 available for 
download. This is a test release to test several new features and gain 
more feedback to be fixed upstream.

PostgreSQL is an advanced Object-Relational database management system
(DBMS) that supports almost all SQL constructs (including transactions,
subselects and user-defined types and functions).
This is based on the current beta3 plus some more late fixes, a CVS 
snapshot from 2004-10-02, which fixes most but not all of the cygwin 
issues.

KNOWN PROBLEMS
==============
tablespace doesn't work yet.  (Just a minor symlink directories problem 
not yet solved)
This is a new 8.0 feature, similar to the oracle tablespace.
http://developer.postgresql.org/docs/postgres/catalog-pg-tablespace.html
It specifies the physical layout for a table, implemented as simple 
symlink on directories. To share a db across discs probably.

contrib/earthdistance has been temporarily disabled. (It was not in 
previous packages neither)

tcl has been removed upstream.

It will not work on Win95 due to remaining cygserver problems. This will 
hopefully be fixed by the next upcoming cygwin release.

NEWS
====
Maintainership changed from Jason Tishler to Reini Urban.
nls and charset translation support (not only -E Latin1). Building via gbs.
Improved IPC and signals handling. Up to 50 max_connections
possible, but 5-10 are still recommended. max 63 hardlimit on cygwin.
Added new postinstall and preremove recipes to save and restore the
old databases into /var/tmp/db.out.gz. (this might turn out to be 
problematic)
Added contrib binaries, libs, data and docs.

Upstream news
=============

Win32 Native Server, Savepoints, Point-In-Time Recovery, Tablespaces,
Improved Buffer Management, CHECKPOINT, VACUUM, Change Column Types,
New Perl Server-Side Language, CSV support in COPY, timezones.

The main PostgreSQL project plans to add support for a native Windows
version with our version 8 release. This will probably be released in
late 2004.

See http://momjian.postgresql.org/main/writings/pgsql/win32.html
for the PostgreSQL Native Win32 Status Report (mingw build).
However the cygwin port also benefits from the version 8 changes,
which comes with better IPC support, and improved signal handling.

See 
http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-0
for the full list of major changes with 8.0, and the steps for migration 
to version 8.0.

Deprecated features:

* The 8.1 release will remove the function to_char(interval).

* By default, tables in PostgreSQL 8.0 and earlier are created with
   OIDs. In the next release, this will not be the case: to create a
   table that contains OIDs, the WITH OIDS clause must be specified or
   the default_with_oids configuration parameter must be enabled. Users
   are encouraged to explicitely specify WITH OIDS if their tables
   require OIDs for compatibility with future releases of PostgreSQL.


TODO
====
add /usr/lib/postgresql/ to the postmaster service path.
add init.d service installer/uninstaller as with clamav.
fix tablespace breakage. (cygwin symlinks to work across physical discs)

INSTALLATION
============

To update your installation, click on the "Install Cygwin now" link on
the http://cygwin.com/ web page.  This downloads setup.exe to your
system.  Then, run setup, fill in all of the options, and make
appropriate choices on the "Select Packages" screen.  You'll need to
select the Database category or [View] until Full to see postgresql and 
click on [Exp].

If you have questions or comments, please send them to the Cygwin
mailing list, <http://cygwin.com/list.html>.

               *** CYGWIN-ANNOUNCE UNSUBSCRIBE INFO ***

If you want to unsubscribe from the cygwin-announce mailing list, look
at the "List-Unsubscribe: " tag in the email header of this message.
Send email to the address specified there.  It will be in the format:

cygwin-announce-unsubscribe-you=yourdomain.com@cygwin.com

If you need more information on unsubscribing, start reading here:

http://sources.redhat.com/lists.html#unsubscribe-simple

Please read *all* of the information on unsubscribing that is available
starting at this URL.
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]