Regression failure etc in 6.4 - Mailing list pgsql-ports
| From | postgres@roestock.demon.co.uk (Postgres database) |
|---|---|
| Subject | Regression failure etc in 6.4 |
| Date | |
| Msg-id | 3bdcac77a0bf4c894a7f3ddde2b38ffe Whole thread Raw |
| List | pgsql-ports |
I've just finished installing Postgresql v6.4, and
would like to feedback a few findings:
My system:
Linux i586-ELF kernel v2.0.36 (No particular distribution)
Processor AMD-K6
GCC 2.7.2.3
Libc 5.4.44
Flex 2.5.4
Postresql configured with ./configure --with-perl
I previously had 6.2.1.p7 installed.
Install observations:
6) pg_dumpall -z >db.out failed (hung).
I think this was because I had already deleted the 6.2.1.p7
sources, and I got the following line in the log file:
WARN:stat failed on file /free/fox/postgresql-6.2.1.p7/src/tutorial/complex.so
I hadn't got much past tinkering so it didn't matter much.
20) I copied the pg_hba.conf file across, but stage 21 wouldn't work
(Kept getting 'User authentication failed'). I then tried editting it and
merging in my lines from the previous version and discovered that the line
local all trust
wasn't in the old version which may be why nothing had worked.
21) & missing after postmaster -i ?
At the end of this section you don't say to kill the postmaster.
23) My system failed the horology checks. It looks like european time
problems. I've put the diffs at the end of this mail.
I'm looking forward to some serious playing now..
Thanks,
Peter.
*** expected/horology.out Tue Jan 6 19:24:59 1998
- --- results/horology.out Wed Dec 2 22:19:36 1998
***************
*** 854,860 ****
|Sat 01 Jan 17:32:01 2000 PST
|Sun 31 Dec 17:32:01 2000 PST
|Mon 01 Jan 17:32:01 2001 PST
! |Thu 13 Jun 00:00:00 1957 PDT
(63 rows)
QUERY: SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
- --- 854,860 ----
|Sat 01 Jan 17:32:01 2000 PST
|Sun 31 Dec 17:32:01 2000 PST
|Mon 01 Jan 17:32:01 2001 PST
! |Thu 13 Jun 00:00:00 1957 PST
(63 rows)
QUERY: SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
***************
*** 938,944 ****
|2000-01-01 17:32:01-08
|2000-12-31 17:32:01-08
|2001-01-01 17:32:01-08
! |1957-06-13 00:00:00-07
(63 rows)
QUERY: SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
- --- 938,944 ----
|2000-01-01 17:32:01-08
|2000-12-31 17:32:01-08
|2001-01-01 17:32:01-08
! |1957-06-13 00:00:00-08
(63 rows)
QUERY: SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
***************
*** 1022,1028 ****
|01/01/2000 17:32:01.00 PST
|31/12/2000 17:32:01.00 PST
|01/01/2001 17:32:01.00 PST
! |13/06/1957 00:00:00.00 PDT
(63 rows)
QUERY: SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
- --- 1022,1028 ----
|01/01/2000 17:32:01.00 PST
|31/12/2000 17:32:01.00 PST
|01/01/2001 17:32:01.00 PST
! |13/06/1957 00:00:00.00 PST
(63 rows)
QUERY: SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
***************
*** 1109,1115 ****
|Sat Jan 01 17:32:01 2000 PST
|Sun Dec 31 17:32:01 2000 PST
|Mon Jan 01 17:32:01 2001 PST
! |Thu Jun 13 00:00:00 1957 PDT
(63 rows)
QUERY: SELECT '' AS eight, f1 AS us_postgres FROM ABSTIME_TBL;
- --- 1109,1115 ----
|Sat Jan 01 17:32:01 2000 PST
|Sun Dec 31 17:32:01 2000 PST
|Mon Jan 01 17:32:01 2001 PST
! |Thu Jun 13 00:00:00 1957 PST
(63 rows)
QUERY: SELECT '' AS eight, f1 AS us_postgres FROM ABSTIME_TBL;
***************
*** 1191,1197 ****
|2000-01-01 17:32:01-08
|2000-12-31 17:32:01-08
|2001-01-01 17:32:01-08
! |1957-06-13 00:00:00-07
(63 rows)
QUERY: SELECT '' AS eight, f1 AS us_iso FROM ABSTIME_TBL;
- --- 1191,1197 ----
|2000-01-01 17:32:01-08
|2000-12-31 17:32:01-08
|2001-01-01 17:32:01-08
! |1957-06-13 00:00:00-08
(63 rows)
QUERY: SELECT '' AS eight, f1 AS us_iso FROM ABSTIME_TBL;
***************
*** 1275,1281 ****
|01/01/2000 17:32:01.00 PST
|12/31/2000 17:32:01.00 PST
|01/01/2001 17:32:01.00 PST
! |06/13/1957 00:00:00.00 PDT
(63 rows)
QUERY: SELECT '' AS eight, f1 AS us_sql FROM ABSTIME_TBL;
- --- 1275,1281 ----
|01/01/2000 17:32:01.00 PST
|12/31/2000 17:32:01.00 PST
|01/01/2001 17:32:01.00 PST
! |06/13/1957 00:00:00.00 PST
(63 rows)
QUERY: SELECT '' AS eight, f1 AS us_sql FROM ABSTIME_TBL;
***************
*** 1366,1373 ****
|Sat 01 Jan 17:32:01 2000 PST
|Sun 31 Dec 17:32:01 2000 PST
|Mon 01 Jan 17:32:01 2001 PST
! |Thu 13 Jun 00:00:00 1957 PDT
! |Thu 13 Jun 00:00:00 1957 PDT
(64 rows)
QUERY: SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
- --- 1366,1373 ----
|Sat 01 Jan 17:32:01 2000 PST
|Sun 31 Dec 17:32:01 2000 PST
|Mon 01 Jan 17:32:01 2001 PST
! |Thu 13 Jun 00:00:00 1957 PST
! |Thu 13 Jun 00:00:00 1957 PST
(64 rows)
QUERY: SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
***************
*** 1451,1458 ****
|2000-01-01 17:32:01-08
|2000-12-31 17:32:01-08
|2001-01-01 17:32:01-08
! |1957-06-13 00:00:00-07
! |1957-06-13 00:00:00-07
(64 rows)
QUERY: SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
- --- 1451,1458 ----
|2000-01-01 17:32:01-08
|2000-12-31 17:32:01-08
|2001-01-01 17:32:01-08
! |1957-06-13 00:00:00-08
! |1957-06-13 00:00:00-08
(64 rows)
QUERY: SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
***************
*** 1536,1543 ****
|01/01/2000 17:32:01.00 PST
|31/12/2000 17:32:01.00 PST
|01/01/2001 17:32:01.00 PST
! |13/06/1957 00:00:00.00 PDT
! |13/06/1957 00:00:00.00 PDT
(64 rows)
QUERY: SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
- --- 1536,1543 ----
|01/01/2000 17:32:01.00 PST
|31/12/2000 17:32:01.00 PST
|01/01/2001 17:32:01.00 PST
! |13/06/1957 00:00:00.00 PST
! |13/06/1957 00:00:00.00 PST
(64 rows)
QUERY: SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
- ----------------------
pgsql-ports by date: