PostgreSQL 8.0 beta1 依然有大 BUG

wwashington

postgres=# \du
                  List of database users
User name | User ID |         Attributes         | Groups
-----------+---------+----------------------------+--------
postgres  |       1 | superuser, create database |
zhongxb   |     100 | create database            |
(2 rows)

postgres=# \dp
LOG:  server process (PID 252 was terminated by signal 5
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
server closed the connection unexpectedly
        This probabLOG:  database system was interrupted at 2004-08-11 18:27:28 中国标准时间
ly means the serveLOG:  checkpoint record is at 0/AB49C0
LOG:  redo record is at 0/AB49C0; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 505; next OID: 17230
LOG:  database system was not properly shut down; automatic recovery in progress
r terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: LOG:  record with zero length at 0/AB4A00
LOG:  redo is not required
FATAL:  the database system is starting up
Failed.
!>; LOG:  database system is ready

wwashington

D:\Documents and Settings\Jacky Zhong>;sqp

D:\Documents and Settings\Jacky Zhong>;psql -U postgres
Welcome to psql 8.0.0beta1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# select version();
                                            version
-----------------------------------------------------------------------------------------------
PostgreSQL 8.0.0beta1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.0 (mingw special)
(1 row)

bitbird

我这里好好的：
template1=# \du
                  List of database users
User name | User ID |         Attributes         | Groups
-----------+---------+----------------------------+--------
postgres  |       1 | superuser, create database |
(1 row)

template1=# \dp
Access privileges for database "template1"
Schema | Name | Type | Access privileges
--------+------+------+-------------------
(0 rows)

template1=# select version();
                                                version

--------------------------------------------------------------------------------
------------------------
PostgreSQL 8.0devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mi
ngw special 20030504-1)
(1 row)

系统是win2k AS SP4，自己制作的。比beta1还稍微早几天。
据我所知，后面的修改不应该有这些问题。我更怀疑是gcc3.4的问题。

piaos3d

我的也没有问题 只是PGadmin不能用了

wwashington

请问楼上两位的 token 和 timezone 问题是怎样解决的?除了 \dp 的问题外,要初始化数据库必然要过这两关啊.\dp 的问题我会用3.3.3试一下.

wwashington

呵呵,已经证实 gcc 3.4.0 确实有问题,我把 bitwalk 的 mingw_045.exe 和 mingw_tools_042.exe 卸载了,安装早一点的 mingw_041.exe 和 mingw_tools_039.exe,一切正常. 感谢 bitbird 的提醒,否则偶还不知道 gcc 的新版有毛病,以为版本越高越强呢...

postgres=# select version();
                                            version
-----------------------------------------------------------------------------------------------
PostgreSQL 8.0.0beta1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.3.3 (mingw special)
(1 row)

postgres=# \du
                  List of database users
User name | User ID |         Attributes         | Groups
-----------+---------+----------------------------+--------
postgres  |       1 | superuser, create database |
zhongxb   |     100 | create database            |
(2 rows)

postgres=# \dp
Access privileges for database "postgres"
Schema | Name | Type | Access privileges
--------+------+------+-------------------
(0 rows)