Re: PostgreSQL 9.2.7 on Power 8 / AIX 7.1
От | Rainer Tammer |
---|---|
Тема | Re: PostgreSQL 9.2.7 on Power 8 / AIX 7.1 |
Дата | |
Msg-id | 53D67140.1000709@spg.schulergroup.com обсуждение исходный текст |
Ответ на | Re: PostgreSQL 9.2.7 on Power 8 / AIX 7.1 (Rainer Tammer <pgsql@spg.schulergroup.com>) |
Список | pgsql-bugs |
Hello, PostgreSQL 9.3.5 does pass all regression tests on AIX 7.1 TL3 SP3: bash ./configure \ --with-includes=/opt/freeware/include/readline \ --with-libraries=/opt/freeware/lib \ --prefix=/usr/local/pgsql-9.3.5 \ --with-CC=cc_r \ --without-tcl \ --without-python ../../../src/test/regress/pg_regress --inputdir=. --temp-install=./tmp_check --top-builddir=../../.. --dlpath=. --schedule=./parallel_schedule ============== creating temporary installation ============== ============== initializing database system ============== ============== starting postmaster ============== running on port 57537 with PID 6357156 ============== creating database "regression" ============== CREATE DATABASE ALTER DATABASE ============== running regression test queries ============== test tablespace ... ok parallel group (18 tests): name char oid float4 float8 int2 int4 boolean varchar text money int8 txid bit uuid enum numeric rangetypes boolean ... ok char ... ok name ... ok varchar ... ok text ... ok int2 ... ok int4 ... ok int8 ... ok oid ... ok float4 ... ok float8 ... ok bit ... ok numeric ... ok txid ... ok uuid ... ok enum ... ok money ... ok rangetypes ... ok test strings ... ok test numerology ... ok parallel group (19 tests): lseg point path box polygon circle time comments timetz reltime abstime macaddr tinterval tstypes date interval inet timestamp timestamptz point ... ok lseg ... ok box ... ok path ... ok polygon ... ok circle ... ok date ... ok time ... ok timetz ... ok timestamp ... ok timestamptz ... ok interval ... ok abstime ... ok reltime ... ok tinterval ... ok inet ... ok macaddr ... ok tstypes ... ok comments ... ok parallel group (6 tests): geometry regex horology type_sanity oidjoins opr_sanity geometry ... ok horology ... ok regex ... ok oidjoins ... ok type_sanity ... ok opr_sanity ... ok test insert ... ok test create_function_1 ... ok test create_type ... ok test create_table ... ok test create_function_2 ... ok parallel group (2 tests): copyselect copy copy ... ok copyselect ... ok parallel group (2 tests): create_operator create_misc create_misc ... ok create_operator ... ok parallel group (2 tests): create_view create_index create_index ... ok create_view ... ok parallel group (11 tests): create_aggregate create_cast create_function_3 drop_if_exists typed_table vacuum constraints create_table_like triggers updatable_views inherit create_aggregate ... ok create_function_3 ... ok create_cast ... ok constraints ... ok triggers ... ok inherit ... ok create_table_like ... ok typed_table ... ok vacuum ... ok drop_if_exists ... ok updatable_views ... ok test sanity_check ... ok test errors ... ok test select ... ok parallel group (20 tests): select_distinct_on select_distinct select_implicit select_into select_having case update btree_index random namespace delete hash_index transactions portals union subselect aggregates arrays join prepared_xacts select_into ... ok select_distinct ... ok select_distinct_on ... ok select_implicit ... ok select_having ... ok subselect ... ok union ... ok case ... ok join ... ok aggregates ... ok transactions ... ok random ... ok portals ... ok arrays ... ok btree_index ... ok hash_index ... ok update ... ok namespace ... ok prepared_xacts ... ok delete ... ok parallel group (4 tests): security_label collate privileges matview privileges ... ok security_label ... ok collate ... ok matview ... ok parallel group (3 tests): psql alter_generic misc alter_generic ... ok misc ... ok psql ... ok test rules ... ok test event_trigger ... ok parallel group (16 tests): portals_p2 combocid tsdicts advisory_lock dependency xmlmap guc json functional_deps select_views cluster window tsearch foreign_data foreign_key bitmapops select_views ... ok portals_p2 ... ok foreign_key ... ok cluster ... ok dependency ... ok guc ... ok bitmapops ... ok combocid ... ok tsearch ... ok tsdicts ... ok foreign_data ... ok window ... ok xmlmap ... ok functional_deps ... ok advisory_lock ... ok json ... ok parallel group (19 tests): limit plancache conversion prepare xml returning temp polymorphism copy2 sequence without_oid with rowtypes domain largeobject rangefuncs truncate alter_table plpgsql plancache ... ok limit ... ok plpgsql ... ok copy2 ... ok temp ... ok domain ... ok rangefuncs ... ok prepare ... ok without_oid ... ok conversion ... ok truncate ... ok alter_table ... ok sequence ... ok polymorphism ... ok rowtypes ... ok returning ... ok largeobject ... ok with ... ok xml ... ok test stats ... ok ============== shutting down postmaster ============== ======================= All 136 tests passed. ======================= Bye Rainer On 25.07.2014 09:22, Rainer Tammer wrote: > Hello, > I have used an old version: > > root@aixtest06 rc:0 # gmake --version > GNU Make 3.80 > Copyright (C) 2002 Free Software Foundation, Inc. > This is free software; see the source for copying conditions. > There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A > PARTICULAR PURPOSE. > > But I can upgrade to a new version, that's no problem. > Which version do you recommend? > > Bye > Rainer > > On 25.07.2014 08:48, Tom Lane wrote: >> Rainer Tammer <pgsql@spg.schulergroup.com> writes: >>> I have tried to run a parallel build, but that was not successful. >>> Should a parallel build (make -j n; n > 1) work? >> Yes; I routinely do -j8 or so, and I think many of the buildfarm members >> are configured to use -j with various multipliers. Having said that, >> we have seen (and worked around) some bugs in the parallel-build support >> in some versions of gmake. There might be more :-(. What make version >> are you using, and what failure did you see exactly? >> >> (Of course, you could configure a buildfarm member with -j 1 as a >> first step, and worry about parallelism later ...) >> >> regards, tom lane >> >> > >
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Andres FreundДата:
Сообщение: Re: BUG #11032: Prepared transactions do not update pg_last_xact_replay_timestamp() anymore