Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com Date: Tue, 5 Oct 2004 11:11:00 -0500 (CDT) Message-Id: <200410051611.i95GB0g27929@esds.vss.fsi.com> From: Reini Urban To: cygwin AT cygwin DOT com Subject: [ANNOUNCEMENT] Experimental package: postgresql-8.0.0cvs-1 Reply-To: cygwin AT cygwin DOT com 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, . *** 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 DOT com AT cygwin DOT 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/