database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
ㆍPostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
PostgreSQL News 6023 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 6023
PostgreSQL 8.0.2 Released
작성자
김상기(ioseph)
작성일
2005-04-08 14:42
조회수
7,279

첫번째 소식이 드디어 8.0 작업의 마지막으로 클라이언트 쪽 라이브러리 버전이 바뀌었답니다. 그래서 필요하다면, 새로 컴파일을 해야할 경우도 생긴다는 군요.

 

perl 쪽의 DBD(?) 쪽, python 쪽의 _pg.so, php의 pgsql.so ... 등등. 사용하고 있는 각종 클라이언트들의 새 컴파일이 필요한지 확인해 보셔야할 듯싶습니다.

 

그 이하 자질구레한 이야기들은 (개인적으로 판단으로는 실 사용자 입장에서 보면 중요한 이야기들이 없음) 생략합니다. 릴리즈 문서를 참조하세요.

 

아무튼 반가운 소식은 plpython 작업을 이제는 pgAdmin 에서 해도 되겠네요. :)

 

이 글에 대한 댓글이 총 2건 있습니다.

ftp://ftp.postgresql.org/pub/source/v8.0.2/ 에 올라와 있네여~ ㅎㅎ

신기배(소타)님이 2005-04-08 17:44에 작성한 댓글입니다.

Release Notes

Release 8.0.2

Release date: 2005-04-07

This release contains a variety of fixes from 8.0.1.

__________________________________________________________________

Migration to version 8.0.2

A dump/restore is not required for those running 8.0.*. This release

updates the major version number of the PostgreSQL libraries, so it

might be necessary to re-link some user applications if they cannot

find the properly-numbered shared library.

__________________________________________________________________

Changes

* Increment the major version number of all interface libraries

(Bruce)

This should have been done in 8.0.0. It is required so 7.4.X

versions of PostgreSQL client applications, like psql, can be used

on the same machine as 8.0.X applications. This might require

re-linking user applications that use these libraries.

* Add Windows-only wal_sync_method setting of "fsync_writethrough"

(Magnus, Bruce)

This setting causes PostgreSQL to write through any disk-drive

write cache when writing to WAL. This behavior was formerly called

"fsync", but was renamed because it acts quite differently from

"fsync" on other platforms.

* Enable the wal_sync_method setting of "open_datasync" on Windows,

and make it the default for that platform (Magnus, Bruce)

Because the default is no longer "fsync_writethrough", data loss is

possible during a power failure if the disk drive has write caching

enabled. To turn off the write cache on Windows, from the Device

Manager, choose the drive properties, then Policies.

* New cache management algorithm 2Q replaces ARC (Tom)

This was done to avoid a pending US patent on ARC. The 2Q code

might be a few percentage points slower than ARC for some work

loads. A better cache management algorithm will appear in 8.1.

* Planner adjustments to improve behavior on freshly-created tables

(Tom)

* Allow plpgsql to assign to an element of an array that is initially

NULL (Tom)

Formerly the array would remain NULL, but now it becomes a

single-element array. The main SQL engine was changed to handle

"UPDATE" of a null array value this way in 8.0, but the similar

case in plpgsql was overlooked.

* Convert \r\n and \r to \n in plpython function bodies (Michael

Fuhr)

This prevents syntax errors when plpython code is written on a

Windows or Mac client.

* Allow SPI cursors to handle utility commands that return rows, such

as "EXPLAIN" (Tom)

* Fix "CLUSTER" failure after "ALTER TABLE SET WITHOUT OIDS" (Tom)

* Reduce memory usage of "ALTER TABLE ADD COLUMN" (Neil)

* Fix "ALTER LANGUAGE RENAME" (Tom)

* Document the Windows-only register and unregister options of pg_ctl

(Magnus)

* Ensure operations done during backend shutdown are counted by

statistics collector

This is expected to resolve reports of pg_autovacuum not vacuuming

the system catalogs often enough -- it was not being told about

catalog deletions caused by temporary table removal during backend

exit.

* Change the Windows default for configuration parameter

log_destination to "eventlog" (Magnus)

By default, a server running on Windows will now send log output to

the Windows event logger rather than standard error.

* Make Kerberos authentication work on Windows (Magnus)

* Allow "ALTER DATABASE RENAME" by superusers who aren't flagged as

having CREATEDB privilege (Tom)

* Modify WAL log entries for "CREATE" and "DROP DATABASE" to not

specify absolute paths (Tom)

This allows point-in-time recovery on a different machine with

possibly different database location. Note that "CREATE TABLESPACE"

still poses a hazard in such situations.

* Fix crash from a backend exiting with an open transaction that

created a table and opened a cursor on it (Tom)

* Fix array_map() so it can call PL functions (Tom)

* Several "contrib/tsearch2" and "contrib/btree_gist" fixes (Teodor)

* Fix crash of some "contrib/pgcrypto" functions on some platforms

(Marko Kreen)

* Fix "contrib/intagg" for 64-bit platforms (Tom)

* Fix ecpg bugs in parsing of "CREATE" statement (Michael)

* Work around gcc bug on powerpc and amd64 causing problems in ecpg

(Christof Petig)

* Do not use locale-aware versions of upper(), lower(), and initcap()

when the locale is C (Bruce)

This allows these functions to work on platforms that generate

errors for non-7-bit data when the locale is C.

* Fix quote_ident() to quote names that match keywords (Tom)

* Fix to_date() to behave reasonably when CC and YY fields are both

used (Karel)

* Prevent to_char(interval) from failing when given a zero-month

interval (Tom)

* Fix wrong week returned by date_trunc('week') (Bruce)

date_trunc('week') returned the wrong year for the first few days

of January in some years.

* Use the correct default mask length for class D addresses in INET

data types (Tom)

__________________________________________________________________

조성준(openphp)님이 2005-04-09 02:45에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
6030DBD::Pg 1.41 released
신기배
2005-04-10
6520
6029ExtenDB Announces Clustered Partitioned PostgreSQL
신기배
2005-04-10
6089
6028Bla-bla List: free, secure, simple and sharable To-do lists
신기배
2005-04-10
6722
6023PostgreSQL 8.0.2 Released [2]
김상기
2005-04-08
7279
5987Compiere ERP & CRM Open Source now with PostgreSQL
신기배
2005-03-24
6255
5972New pgExpress Driver v3.0 released
신기배
2005-03-16
6674
5971EMS PostgreSQL Data Pump, DB Comparer and Extract released.
신기배
2005-03-16
6460
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2023 DSN, All rights reserved.
작업시간: 0.049초, 이곳 서비스는
	PostgreSQL v16.1로 자료를 관리합니다