responding to my own post... the only way I was able to make parallel mode functional: downgrade to pgpool-II-2.0.1, replace its pool_rewrite_query.c with version of this file from pgpool-II-2.1-beta2, and recompile.
in my experience neither version of pgpool-II-2.x worked with parallel mode without tweaking hopefully pgpool-II-2.1 stable release will fix the issue. is there a tentative release date for pgpool-II-2.1 stable ? Thanks, V. I found Vlad Kosilov wrote: > I'm experimenting with pgpool-II-2.1-beta2 in parallel mode with two > back-end databases running pgsql-8.3.1, and 3rd host running pgpool and > pgsql-8.3.1 system/pgpool db. > I'm having with loading following file where only first insert > successfully gets through and second insert hangs. > > /usr/local/pgsql-8.3.1/bin/psql -e -U postgres -h 192.168.0.102 -p 9999 > -d MONSOONAUDIT -f ./tcp_audit_0.dmp > INSERT INTO tcp_audit_vlad (id, beacon_id, message, flow, "timestamp", > unique_id, byte_count) VALUES (531391045, 0, 'message_0', 'in', > 1212303601, '352023005147018', 297); > INSERT 0 1 > INSERT INTO tcp_audit_vlad (id, beacon_id, message, flow, "timestamp", > unique_id, byte_count) VALUES (531391046, 0, 'message_1', 'in', > 1212303601, '352023005147018', 100); > ... hangs here .. > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
