> -----Original Message-----
> From: slony1-general-bounces at gborg.postgresql.org 
> [mailto:slony1-general-bounces at gborg.postgresql.org] On 
> Behalf Of Christopher Browne
> Sent: 09 June 2006 18:41
> To: slony
> Subject: [Slony1-general] Test results - 1.2.0 PRE-2 on AIX 5.3
> 
> New Generation tests, all run successfully:
>  - test1
>  - testddl
>  - testschemanames
>  - testseqnames
>  - testtabnames
>  - testutf8

All passed on XP SP2 with pgInstaller PostgreSQL 8.1.4, *except* testddl
which consistently hangs after Slony catches up during the second data
generation phase:

----------------------------
creating origin DB: postgres -h localhost -U postgres -p 5432
slonyregress1
add plpgsql to Origin
createlang: language "plpgsql" is already installed in database
"slonyregress1"
loading origin DB with testddl/init_schema.sql
done
creating subscriber 2 DB: postgres -h localhost -U postgres -p 5432
slonyregress2
add plpgsql to subscriber
createlang: language "plpgsql" is already installed in database
"slonyregress2"
loading subscriber 2 DB from slonyregress1
done
creating cluster
done
storing nodes
done
storing paths
done
launching originnode : /usr/local/pgsql/bin/slon -s500 -g10 -d2
slony_regress1 "dbname=slonyregress1 host=localhost user=postgres
port=5432"
launching: /usr/local/pgsql/bin/slon -s500 -g10 -d2 slony_regress1
"dbname=slonyregress2 host=localhost user=postgres port=5432"
subscribing
done
generating 448 tranactions of random data
0 %
5 %
10 %
15 %
20 %
25 %
30 %
35 %
40 %
45 %
50 %
55 %
60 %
65 %
70 %
75 %
80 %
85 %
90 %
95 %
100 %
done
launching polling script
loading data
execute DDL script
completed DDL script
Generate some more data
generating 748 tranactions of random data
0 %
slony is caught up
5 %
<hung here>
----------------------------

Any thoughts? In my experience the msys console can be a bit
tempremental (resizing the windows can hang it for example), so I'm
wondering if it's getting upset when poll_cluster.sh butts in with it's
caught up message.

Regards, Dave