This is the mail archive of the
mailing list for the Cygwin project.
[ANNOUNCEMENT] Experimental package: postgresql-8.0.0cvs-1
- From: Reini Urban <rurban at x-ray dot at>
- To: cygwin at cygwin dot com
- Date: Tue, 5 Oct 2004 11:11:00 -0500 (CDT)
- 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
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.
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.
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
Added contrib binaries, libs, data and docs.
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
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.
for the full list of major changes with 8.0, and the steps for migration
to version 8.0.
* 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.
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)
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:
If you need more information on unsubscribing, start reading here:
Please read *all* of the information on unsubscribing that is available
starting at this URL.
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Problem reports: http://cygwin.com/problems.html