forked from ssinger/slony1-engine
/
HISTORY-1.1
1779 lines (1146 loc) · 77.7 KB
/
HISTORY-1.1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
2004-10-28 xfade configure,config/acx_libpq.m4
Configure options should override the default searchpath.
=================================
2004-11-02 darcyb share/slon.conf-sample
Include a sample documented slon config file, Thanks Ed L. for the initail work
=================================
2004-11-02 darcyb GNUmakefile.in,share/Makefile
install the sample conf, when doing a make install
=================================
2004-11-08 cbbrowne src/backend/slony1_base.sql
Added documentation on columns that were not previously documented
=================================
2004-11-10 cbbrowne src/backend/slony1_funcs.c,src/backend/slony1_funcs.sql
Fixed typos, added further schema documentation to C functions
=================================
2004-11-10 cbbrowne src/backend/slony1_funcs.sql
Add in "draft" version of RebuildListenEntries() that generates
sl_listen entries automatically whenever sl_path and sl_subscribe
change
=================================
2004-11-10 cbbrowne doc/adminguide/README,doc/adminguide/SlonyAddThings.txt,doc/adminguide/SlonyAdministrationScripts.txt,doc/adminguide/SlonyConcepts.txt,doc/adminguide/SlonyDDLChanges.txt,doc/adminguide/SlonyDefineCluster.txt,doc/adminguide/SlonyDefineSet.txt,doc/adminguide/SlonyDropThings.txt,doc/adminguide/SlonyFAQ.txt,doc/adminguide/SlonyFAQ01.txt,doc/adminguide/SlonyFAQ02.txt,doc/adminguide/SlonyFAQ03.txt,doc/adminguide/SlonyFAQ04.txt,doc/adminguide/SlonyFAQ05.txt,doc/adminguide/SlonyFAQ06.txt,doc/adminguide/SlonyFAQ07.txt,doc/adminguide/SlonyFAQ08.txt,doc/adminguide/SlonyFAQ09.txt,doc/adminguide/SlonyFAQ10.txt,doc/adminguide/SlonyFAQ11.txt,doc/adminguide/SlonyFAQ12.txt,doc/adminguide/SlonyFAQ13.txt,doc/adminguide/SlonyFAQ14.txt,doc/adminguide/SlonyFAQ15.txt,doc/adminguide/SlonyFAQ16.txt,doc/adminguide/SlonyFAQ17.txt,doc/adminguide/SlonyFAQ18.txt,doc/adminguide/SlonyHandlingFailover.txt,doc/adminguide/SlonyHelp.txt,doc/adminguide/SlonyHowtoFirstTry.txt,doc/adminguide/SlonyIAdministration.txt,doc/adminguide/SlonyInstallation.txt,doc/adminguide/SlonyIntroduction.txt,doc/adminguide/SlonyListenPaths.txt,doc/adminguide/SlonyListenerCosts.txt,doc/adminguide/SlonyMaintenance.txt,doc/adminguide/SlonyPrerequisites.txt,doc/adminguide/SlonyReshapingCluster.txt,doc/adminguide/SlonySlonConfiguration.txt,doc/adminguide/SlonySlonik.txt,doc/adminguide/SlonyStartSlons.txt
Add in material from Slony-I wiki that will become an "Administration
Guide."
=================================
2004-11-12 cbbrowne src/ducttape/test_1_pgbench,src/ducttape/test_2_pgbench,src/ducttape/test_3_pgbench,src/ducttape/test_4_pgbench,src/ducttape/test_5_pgbench
Make "ducttape" scripts that use pgbench aware of varying GNU Make names
=================================
2004-11-12 cbbrowne src/backend/slony1_funcs.sql
Add FUNCTION generate_sync_event () - to try to add SYNCs even if slon isn't running
=================================
2004-11-13 wieck src/backend/slony1_funcs.sql,src/ducttape/test_1_pgbench,src/ducttape/test_2_pgbench,src/slon/local_listen.c,src/slon/remote_worker.c,src/slon/runtime_config.c,src/slon/slon.c,src/slon/slon.h
Here is a first full functional and activated rebuiltListenEntries().
Any change to sl_node, sl_path and sl_subscribe causes slon to reload
the listen configuration. The logic is slightly different from what
was first discussed and probably not in its final state. But it passes
various configurations without any need to restart slon.
Jan
=================================
2004-11-18 cbbrowne src/ducttape/test_6_autolisten
A gratuitously complex test case which generates 6 nodes, and
uses rebuildlistenentries() to generate the listen network
=================================
2004-11-19 cbbrowne doc/howto/slony-I-basic-mstr-slv.txt
Basic tutorial now allows having Slony-I nodes on separate hosts
=================================
2004-11-19 cbbrowne tools/altperl/create_set.pl,tools/altperl/init_cluster.pl
These scripts were at one point generating multiple slonik
scripts to set up clusters/sets.
As they only generate a single script, they now do so via one
opening of files, and don't bother having multiple preambles
=================================
2004-11-19 cbbrowne src/backend/slony1_base.sql,src/backend/slony1_funcs.c,src/backend/slony1_funcs.sql
Comments for sl_setsync, revisions to generate_sync_event(), new table maintenance function, add_missing_table_field(), textual and comment changes
=================================
2004-11-23 cbbrowne tools/altperl/reset_cluster.pl
The "reset_cluster.pl" script is broken and should become unnecessary
in 1.1...
=================================
2004-11-25 darcyb src/backend/slony1_funcs.sql
Make cbbrowne's functions work as conceptualy intended
=================================
2004-11-25 cbbrowne src/ducttape/test_1_pgbench,src/ducttape/test_2_pgbench,src/ducttape/test_3_pgbench,src/ducttape/test_4_pgbench,src/ducttape/test_5_pgbench
sh portability change - Use [ -z $WHATEVER ] ; rather than [[ $WHATEVER == "" ]];
=================================
2004-11-25 cbbrowne tools/generate_syncs.sh
branches: 1.1.2;
Add in "generate_syncs.sh" script to use the new "generate_sync_event()" procedure that can generate SYNCs even if the origin's slon is down.
=================================
2004-11-25 darcyb src/backend/slony1_funcs.sql
supply missing arg to function comment, make function parse properly
=================================
2004-11-25 darcyb src/backend/slony1_funcs.sql
Add a missing ' to correct parse error
=================================
2004-11-26 darcyb src/slon/conf-file.sample
Duplicate file, share/slon.conf-sample is the correct home for this
=================================
2004-11-29 darcyb src/slon/confoptions.c,src/slon/confoptions.h
Make it possible to easly obtain the value of a conf option
=================================
2004-12-01 darcyb src/slon/Makefile
clean should yank the corefile too
=================================
2004-12-01 wieck src/backend/slony1_base.sql,src/backend/slony1_funcs.sql,src/ducttape/test_1_update_functions,src/slonik/slonik.c
Added new function upgradeSchema(old_version). Slonik now determines
the currently loaded slony1_funcs.sql version by calling slonyVersion()
before updating the functions. It then calls upgradeSchema(old_version)
so that this function can perform all the required modifications to the
slony1_base schema depending on the old version.
Jan
=================================
2004-12-02 wieck src/backend/slony1_funcs.sql,src/slon/remote_worker.c,src/slonik/parser.y,src/slonik/scan.l,src/slonik/slonik.c,src/slonik/slonik.h
Added option "spoolnode = yes/no" to "store node" command.
If spoolnode=yes is specified, the sl_node entry will have
no_spool=true and slonik does not attempt to initialize a
database for it.
Jan
=================================
2004-12-02 cbbrowne README
Changes reflecting the build changes in 1.1
=================================
2004-12-02 cbbrowne doc/howto/slonik_commands.html
Minor rewordings
=================================
2004-12-02 wieck src/backend/slony1_funcs.sql,src/slonik/slonik.c
Changed so that subscribeSet() is called on the data provider
instead of the receiver. It should finally be called on the
set origin and replace ENABLE SUBSCRIPTION entirely, but that
is a way bigger change. With what we have so far it is possible
to create and subscribe a virtual spool node.
Jan
=================================
2004-12-02 cbbrowne tools/altperl/move_set.pl
Remove unnecessary UNLOCK SET from move set script
=================================
2004-12-02 cbbrowne src/slon/README
Added overview of what the components of slon do
=================================
2004-12-02 wieck doc/howto/slonik_commands.html
Added spoolnode option to slonik command doc.
Jan
=================================
2004-12-03 wieck src/slonik/slonik.c
Create confirm records for all old events when slonik creates
a spool node.
Jan
=================================
2004-12-04 cbbrowne tools/altperl/slon-tools.pm,tools/altperl/slon_watchdog2.pl
Added in node_is_subscribing() function to make watchdog less aggressive about restarting slon nodes
If a node is in the process of being subscribed, then you can get
long-running COPY requests that run for hours (this happens if it's a
very large database).
slon_watchdog2.pl therefore has two criteria to use to "throttle" its
slon; thus if there has not been a local event on the node in the
interval $killafter, then it will kill (and ultimately restart) the slon
UNLESS a subscription is in progress.
=================================
2004-12-06 cbbrowne doc/adminguide/Makefile,doc/adminguide/addthings.sgml,doc/adminguide/adminscripts.sgml,doc/adminguide/cluster.sgml,doc/adminguide/concepts.sgml,doc/adminguide/ddlchanges.sgml,doc/adminguide/defineset.sgml,doc/adminguide/dropthings.sgml,doc/adminguide/failover.sgml,doc/adminguide/filelist.sgml,doc/adminguide/firstdb.sgml,doc/adminguide/help.sgml,doc/adminguide/installation.sgml,doc/adminguide/intro.sgml,doc/adminguide/legal.sgml,doc/adminguide/listenpaths.sgml,doc/adminguide/maintenance.sgml,doc/adminguide/monitoring.sgml,doc/adminguide/prerequisites.sgml,doc/adminguide/reshape.sgml,doc/adminguide/slonconfig.sgml,doc/adminguide/slonik.sgml,doc/adminguide/slony.sgml,doc/adminguide/startslons.sgml,doc/adminguide/stylesheet-hh.xsl,doc/adminguide/stylesheet.css,doc/adminguide/stylesheet.dsl,doc/adminguide/stylesheet.xsl,doc/adminguide/subscribenodes.sgml
Transformed all Wiki material aside from the FAQ into DocBook SGML
=================================
2004-12-07 darcyb config/acx_pthread.m4
Prefer -lpthread to -pthread on systems that support it (FreeBSD 5.X and newer)
=================================
2004-12-07 darcyb aclocal.m4,configure,configure.ac,config/docbook.m4,config/docs.m4
add docbook tools to configure, add tools to build the concept docs (and friends) to configure as well
=================================
2004-12-07 darcyb Makefile.global.in,configure.ac,config/docbook.m4
Make cbb's docbook stuff fit into our build env
=================================
2004-12-10 cbbrowne doc/howto/slonik_commands.html
Fix to table of contents - SET MOVE (TABLE|SEQUENCE) was indexed as SET DROP
=================================
2004-12-10 cbbrowne doc/adminguide/faq.sgml
Add in FAQ to the admin guide
=================================
2004-12-10 darcyb Makefile.global.in,configure,config/acx_pthread.m4,src/slon/Makefile
Cleanup linking not done messages when compiling on FreeBSD 5 and 6
=================================
2004-12-10 cbbrowne tools/altperl/slon-tools.pm,tools/altperl/slon_watchdog2.pl
Made watchdog2 smarter
Instead of just "thumping" a slon once the latest _originating_ events
get pretty old, it now bases the decision on the time of the latest
_confirmation_ of an event from the provider...
=================================
2004-12-10 cbbrowne doc/adminguide/Makefile,doc/adminguide/SlonyAddThings.txt,doc/adminguide/SlonyAdministrationScripts.txt,doc/adminguide/SlonyConcepts.txt,doc/adminguide/SlonyDDLChanges.txt,doc/adminguide/SlonyDefineCluster.txt,doc/adminguide/SlonyDefineSet.txt,doc/adminguide/SlonyDropThings.txt,doc/adminguide/SlonyFAQ.txt,doc/adminguide/SlonyFAQ01.txt,doc/adminguide/SlonyFAQ02.txt,doc/adminguide/SlonyFAQ03.txt,doc/adminguide/SlonyFAQ04.txt,doc/adminguide/SlonyFAQ05.txt,doc/adminguide/SlonyFAQ06.txt,doc/adminguide/SlonyFAQ07.txt,doc/adminguide/SlonyFAQ08.txt,doc/adminguide/SlonyFAQ09.txt,doc/adminguide/SlonyFAQ10.txt,doc/adminguide/SlonyFAQ11.txt,doc/adminguide/SlonyFAQ12.txt,doc/adminguide/SlonyFAQ13.txt,doc/adminguide/SlonyFAQ14.txt,doc/adminguide/SlonyFAQ15.txt,doc/adminguide/SlonyFAQ16.txt,doc/adminguide/SlonyFAQ17.txt,doc/adminguide/SlonyFAQ18.txt,doc/adminguide/SlonyHandlingFailover.txt,doc/adminguide/SlonyHelp.txt,doc/adminguide/SlonyHowtoFirstTry.txt,doc/adminguide/SlonyIAdministration.txt,doc/adminguide/SlonyInstallation.txt,doc/adminguide/SlonyIntroduction.txt,doc/adminguide/SlonyListenPaths.txt,doc/adminguide/SlonyListenerCosts.txt,doc/adminguide/SlonyMaintenance.txt,doc/adminguide/SlonyPrerequisites.txt,doc/adminguide/SlonyReshapingCluster.txt,doc/adminguide/SlonySlonConfiguration.txt,doc/adminguide/SlonySlonik.txt,doc/adminguide/SlonyStartSlons.txt,doc/adminguide/addthings.html,doc/adminguide/addthings.sgml,doc/adminguide/adminscripts.sgml,doc/adminguide/altperl.html,doc/adminguide/cluster.html,doc/adminguide/cluster.sgml,doc/adminguide/concepts.html,doc/adminguide/concepts.sgml,doc/adminguide/ddlchanges.html,doc/adminguide/ddlchanges.sgml,doc/adminguide/defineset.sgml,doc/adminguide/dropthings.html,doc/adminguide/dropthings.sgml,doc/adminguide/failover.html,doc/adminguide/failover.sgml,doc/adminguide/faq.html,doc/adminguide/filelist.sgml,doc/adminguide/firstdb.html,doc/adminguide/firstdb.sgml,doc/adminguide/help.html,doc/adminguide/help.sgml,doc/adminguide/installation.html,doc/adminguide/installation.sgml,doc/adminguide/intro.sgml,doc/adminguide/legal.sgml,doc/adminguide/listenpaths.html,doc/adminguide/listenpaths.sgml,doc/adminguide/maintenance.html,doc/adminguide/maintenance.sgml,doc/adminguide/monitoring.html,doc/adminguide/monitoring.sgml,doc/adminguide/mysheet.dsl,doc/adminguide/prerequisites.sgml,doc/adminguide/requirements.html,doc/adminguide/reshape.html,doc/adminguide/reshape.sgml,doc/adminguide/slonconfig.html,doc/adminguide/slonconfig.sgml,doc/adminguide/slonik.html,doc/adminguide/slonik.sgml,doc/adminguide/slonstart.html,doc/adminguide/slony.html,doc/adminguide/slony.sgml,doc/adminguide/startslons.sgml,doc/adminguide/subscribenodes.html,doc/adminguide/subscribenodes.sgml,doc/adminguide/t24.html,doc/adminguide/x267.html,doc/adminguide/x931.html
Wiki data transformed to DocBook/SGML
=================================
2004-12-10 cbbrowne doc/adminguide/adminscripts.sgml,doc/adminguide/cluster.sgml,doc/adminguide/concepts.sgml,doc/adminguide/defineset.sgml,doc/adminguide/dropthings.sgml,doc/adminguide/failover.sgml,doc/adminguide/firstdb.sgml,doc/adminguide/help.sgml,doc/adminguide/installation.sgml,doc/adminguide/listenpaths.sgml,doc/adminguide/maintenance.sgml,doc/adminguide/monitoring.sgml,doc/adminguide/reshape.sgml,doc/adminguide/slonconfig.sgml,doc/adminguide/subscribenodes.sgml
Fix up formatting of inclusions in documentation set
=================================
2004-12-10 darcyb src/slon/confoptions.c
Fix cast to pointer from integer of different size on 64bit platforms
=================================
2004-12-10 darcyb src/slon/conf-file.h,src/slon/slon.h
Remove warning of ProcessConfigFile not defined.
=================================
2004-12-11 darcyb src/slon/Makefile,src/slonik/Makefile
Clean up maintainer-clean to remove the generated yacc/lex output
=================================
2004-12-11 darcyb src/slon/Makefile
Remove a not yet commited thread from building
=================================
2004-12-11 darcyb doc/Makefile
Build documentation
=================================
2004-12-13 darcyb src/backend/slony1_funcs.sql
Fix patch/diff's braindead off by 2 lines error
=================================
2004-12-13 darcyb Makefile,aclocal.m4,configure,configure.ac,config/compiler.m4,config/general.m4
Some more minor cleanups in the build environment, make building with debuging symbols optional
=================================
2004-12-13 cbbrowne doc/adminguide/addthings.html,doc/adminguide/bookindex.sgml,doc/adminguide/cluster.html,doc/adminguide/concepts.html,doc/adminguide/ddlchanges.html,doc/adminguide/defineset.sgml,doc/adminguide/dropthings.html,doc/adminguide/failover.html,doc/adminguide/faq.html,doc/adminguide/faq.sgml,doc/adminguide/filelist.sgml,doc/adminguide/firstdb.html,doc/adminguide/firstdb.sgml,doc/adminguide/help.html,doc/adminguide/help.sgml,doc/adminguide/installation.html,doc/adminguide/listenpaths.html,doc/adminguide/maintenance.html,doc/adminguide/monitoring.html,doc/adminguide/reference.sgml,doc/adminguide/requirements.html,doc/adminguide/reshape.html,doc/adminguide/slon.sgml,doc/adminguide/slonconfig.sgml,doc/adminguide/slonik.html,doc/adminguide/slonik.sgml,doc/adminguide/slonik_ref.sgml,doc/adminguide/slonstart.html,doc/adminguide/slony.html,doc/adminguide/slony.sgml,doc/adminguide/subscribenodes.html
Plenty of updates to documentation; consolidated in man pages for slon/slonik
=================================
2004-12-13 darcyb doc/howto/slonik_commands.html,src/backend/slony1_base.sql,src/backend/slony1_funcs.sql,src/slon/misc.c,src/slon/remote_worker.c,src/slon/slon.c,src/slonik/parser.y,src/slonik/scan.l,src/slonik/slonik.c,src/slonik/slonik.h
Due to lots of SIC regarding the pg_dump safe patches, I'll commit them.
New functionality allows you to REPAIR CONFIG() a node(s) after you have used pg_dump/restore on them.
slonik has a new statement REPAIR CONFIG(), and a new event class has been created REPAIR_CONFIG.
=================================
2004-12-13 darcyb src/slon/confoptions.c,src/slon/confoptions.h,src/slon/slon.c
Cleanup some more compiler warnings
=================================
2004-12-14 cbbrowne doc/adminguide/addthings.html,doc/adminguide/addthings.sgml,doc/adminguide/adminscripts.sgml,doc/adminguide/app-slon.html,doc/adminguide/app-slonik.html,doc/adminguide/cluster.html,doc/adminguide/cluster.sgml,doc/adminguide/concepts.html,doc/adminguide/concepts.sgml,doc/adminguide/ddlchanges.html,doc/adminguide/ddlchanges.sgml,doc/adminguide/defineset.sgml,doc/adminguide/definingsets.html,doc/adminguide/dropthings.html,doc/adminguide/dropthings.sgml,doc/adminguide/failover.html,doc/adminguide/failover.sgml,doc/adminguide/faq.html,doc/adminguide/faq.sgml,doc/adminguide/firstdb.html,doc/adminguide/firstdb.sgml,doc/adminguide/help.html,doc/adminguide/help.sgml,doc/adminguide/installation.html,doc/adminguide/installation.sgml,doc/adminguide/listenpaths.html,doc/adminguide/listenpaths.sgml,doc/adminguide/maintenance.html,doc/adminguide/maintenance.sgml,doc/adminguide/monitoring.html,doc/adminguide/monitoring.sgml,doc/adminguide/prerequisites.sgml,doc/adminguide/requirements.html,doc/adminguide/reshape.html,doc/adminguide/reshape.sgml,doc/adminguide/slon.sgml,doc/adminguide/slonik.sgml,doc/adminguide/slonstart.html,doc/adminguide/slony-commands.html,doc/adminguide/slony.html,doc/adminguide/slonyadmin.html,doc/adminguide/slonyintro.html,doc/adminguide/startslons.sgml,doc/adminguide/subscribenodes.html,doc/adminguide/subscribenodes.sgml
Enormous SGML cleanup/improvement
=================================
2004-12-15 cbbrowne doc/adminguide/adminscripts.sgml,doc/adminguide/faq.sgml,doc/adminguide/listenpaths.sgml
Added in docs on new Perl script to generate SET LISTEN requests
=================================
2004-12-15 cbbrowne tools/altperl/regenerate-listens.pl
regenerate-listens.pl - Perl script that generates Slonik "SET LISTEN" entries
based on the contents of a running Slony-I cluster.
Documentation to follow in the next CVS commit...
=================================
2004-12-16 cbbrowne doc/adminguide/addthings.sgml,doc/adminguide/adminscripts.sgml,doc/adminguide/cluster.sgml,doc/adminguide/concepts.sgml,doc/adminguide/ddlchanges.sgml,doc/adminguide/defineset.sgml,doc/adminguide/dropthings.sgml,doc/adminguide/failover.sgml,doc/adminguide/faq.sgml,doc/adminguide/filelist.sgml,doc/adminguide/listenpaths.sgml,doc/adminguide/maintenance.sgml,doc/adminguide/reference.sgml,doc/adminguide/reshape.sgml,doc/adminguide/slonik_ref.sgml,doc/adminguide/startslons.sgml,doc/adminguide/subscribenodes.sgml
Added full Slonik reference in DocBook form, along with a rich set of
linkages to it in the other materials in the admin guide.
=================================
2004-12-17 darcyb configure
make the features in the previous commit available
=================================
2004-12-17 darcyb src/backend/slony1_funcs.sql
More diff crazyness repairs
=================================
2004-12-17 darcyb doc/adminguide/Makefile
Add schemadoc building support
=================================
2004-12-17 darcyb aclocal.m4,configure.ac,config/docbook.m4,config/docs.m4
More docbook fixes, detect the correct version of docbook (4.2)
=================================
2004-12-17 darcyb doc/adminguide/filelist.sgml,doc/adminguide/localxid.sql,doc/adminguide/schemadoc.xml,doc/adminguide/slony.sgml
Add Internals section, this section has a references of all the tables/views and functions used internaly by slony-I. localxxid is a copy of that found in the how-to directory.
=================================
2004-12-17 darcyb Makefile.global.in,configure.ac,doc/Makefile,doc/adminguide/Makefile
More build environment changes to better support cbrowne's docbook work.
=================================
2004-12-20 darcyb doc/adminguide/Makefile,doc/adminguide/slony.sgml
collateindex is handled by ./configure no need to attempt to override it here
=================================
2004-12-20 darcyb doc/adminguide/SlonyAddThings.txt,doc/adminguide/SlonyAdministrationScripts.txt,doc/adminguide/SlonyConcepts.txt,doc/adminguide/SlonyDDLChanges.txt,doc/adminguide/SlonyDefineCluster.txt,doc/adminguide/SlonyDefineSet.txt,doc/adminguide/SlonyDropThings.txt,doc/adminguide/SlonyFAQ.txt,doc/adminguide/SlonyFAQ01.txt,doc/adminguide/SlonyFAQ02.txt,doc/adminguide/SlonyFAQ03.txt,doc/adminguide/SlonyFAQ04.txt,doc/adminguide/SlonyFAQ05.txt,doc/adminguide/SlonyFAQ06.txt,doc/adminguide/SlonyFAQ07.txt,doc/adminguide/SlonyFAQ08.txt,doc/adminguide/SlonyFAQ09.txt,doc/adminguide/SlonyFAQ10.txt,doc/adminguide/SlonyFAQ11.txt,doc/adminguide/SlonyFAQ12.txt,doc/adminguide/SlonyFAQ13.txt,doc/adminguide/SlonyFAQ14.txt,doc/adminguide/SlonyFAQ15.txt,doc/adminguide/SlonyFAQ16.txt,doc/adminguide/SlonyFAQ17.txt,doc/adminguide/SlonyFAQ18.txt,doc/adminguide/SlonyHandlingFailover.txt,doc/adminguide/SlonyHelp.txt,doc/adminguide/SlonyHowtoFirstTry.txt,doc/adminguide/SlonyIAdministration.txt,doc/adminguide/SlonyInstallation.txt,doc/adminguide/SlonyIntroduction.txt,doc/adminguide/SlonyListenPaths.txt,doc/adminguide/SlonyListenerCosts.txt,doc/adminguide/SlonyMaintenance.txt,doc/adminguide/SlonyPrerequisites.txt,doc/adminguide/SlonyReshapingCluster.txt,doc/adminguide/SlonySlonConfiguration.txt,doc/adminguide/SlonySlonik.txt,doc/adminguide/SlonyStartSlons.txt
Time to box the text files up and move them to the attic
=================================
2004-12-21 cbbrowne doc/adminguide/slonik_ref.sgml
Moved preamble material a bit to indicate that echo can't be used
in the "preamble" of a Slonik script
=================================
2004-12-21 darcyb doc/adminguide/Makefile,doc/adminguide/filelist.sgml,doc/adminguide/stylesheet.css,doc/adminguide/stylesheet.dsl
use the correct dsl when building docs
=================================
2004-12-21 darcyb doc/adminguide/Makefile,doc/adminguide/adminscripts.sgml,doc/adminguide/installation.sgml,doc/adminguide/intro.sgml,doc/adminguide/prerequisites.sgml,doc/adminguide/reference.sgml,doc/adminguide/schemadoc.xml,doc/adminguide/slonik_ref.sgml,doc/adminguide/slony.sgml
Convert book to parts + chapters
=================================
2004-12-22 cbbrowne doc/adminguide/slonik_ref.sgml
Put in proper <refpurpose> entries for each Slonik command
=================================
2004-12-22 cbbrowne doc/adminguide/slonik.sgml
Point to internal Slonik command reference, not the GBorg web site
=================================
2004-12-22 darcyb doc/adminguide/Makefile,doc/adminguide/addthings.sgml,doc/adminguide/adminscripts.sgml,doc/adminguide/app-slon.html,doc/adminguide/app-slonik.html,doc/adminguide/bookindex.sgml,doc/adminguide/cluster.html,doc/adminguide/cluster.sgml,doc/adminguide/concepts.html,doc/adminguide/concepts.sgml,doc/adminguide/ddlchanges.sgml,doc/adminguide/defineset.sgml,doc/adminguide/definingsets.html,doc/adminguide/dropthings.sgml,doc/adminguide/failover.sgml,doc/adminguide/faq.html,doc/adminguide/faq.sgml,doc/adminguide/firstdb.sgml,doc/adminguide/help.sgml,doc/adminguide/installation.html,doc/adminguide/installation.sgml,doc/adminguide/intro.sgml,doc/adminguide/legal.sgml,doc/adminguide/listenpaths.sgml,doc/adminguide/maintenance.sgml,doc/adminguide/monitoring.sgml,doc/adminguide/prerequisites.sgml,doc/adminguide/reference.sgml,doc/adminguide/requirements.html,doc/adminguide/reshape.sgml,doc/adminguide/schemadoc.xml,doc/adminguide/slon.sgml,doc/adminguide/slonik.sgml,doc/adminguide/slonik_ref.sgml,doc/adminguide/slony.sgml,doc/adminguide/slonyadmin.html,doc/adminguide/slonyintro.html,doc/adminguide/startslons.sgml,doc/adminguide/subscribenodes.sgml
Building of schemadoc.xml now removes the local schema name, (allow for better portability between developers), update the embeded references in faq to make use of this convention. add Id tages to all the sgml files.
=================================
2004-12-22 darcyb Makefile.global.in
Carry the docbook stuff through to the frontend
=================================
2004-12-22 cbbrowne doc/adminguide/prerequisites.sgml
SGML tagging fixes
=================================
2004-12-22 darcyb doc/adminguide/addthings.sgml,doc/adminguide/adminscripts.sgml,doc/adminguide/bookindex.sgml,doc/adminguide/cluster.sgml,doc/adminguide/concepts.sgml,doc/adminguide/ddlchanges.sgml,doc/adminguide/defineset.sgml,doc/adminguide/dropthings.sgml,doc/adminguide/failover.sgml,doc/adminguide/faq.sgml,doc/adminguide/firstdb.sgml,doc/adminguide/help.sgml,doc/adminguide/installation.sgml,doc/adminguide/intro.sgml,doc/adminguide/legal.sgml,doc/adminguide/listenpaths.sgml,doc/adminguide/maintenance.sgml,doc/adminguide/monitoring.sgml,doc/adminguide/prerequisites.sgml,doc/adminguide/reference.sgml,doc/adminguide/reshape.sgml,doc/adminguide/slon.sgml,doc/adminguide/slonik.sgml,doc/adminguide/slonik_ref.sgml,doc/adminguide/slony.sgml,doc/adminguide/startslons.sgml,doc/adminguide/subscribenodes.sgml
Validate using make check
=================================
2004-12-22 darcyb configure
More docbook tweeks
=================================
2004-12-22 cbbrowne doc/adminguide/faq.sgml
Added commentary on what happens to triggers and rules
=================================
2004-12-22 cbbrowne doc/adminguide/monitoring.sgml
Built a variablelist to list different threads that generate log messages
=================================
2004-12-22 cbbrowne doc/adminguide/adminscripts.sgml
Regrouped sections; doesn't need to be split into a bunch of pages...
=================================
2005-01-03 wieck configure
new configure script based on last acx_pthread.m4 change.
Jan
=================================
2005-01-03 wieck tools/Makefile,tools/slony1_extract_schema.sh
Added script to extract the user schema (without slony cruft)
from an existing node. The node must be the origin.
Jan
=================================
2005-01-03 wieck config/acx_pthread.m4
Don't know why actually using the pthread ld flags was commented out,
but I suppose it would break more platforms than just FreeBSD 4.9.
Jan
=================================
2005-01-04 cbbrowne tools/altperl/slon_start.pl
Add in startup script changes from Steve Simms...
- Support long option names
- Optionally don't start a watchdog
- Optionally specify where slon.env is
- Nodes can be specified in either the form "node123" or "123"
=================================
2005-01-04 cbbrowne tools/altperl/slon-tools.pm
Add in support for SSL connections
Thanks to Steve Simms <steve@deefs.net>
=================================
2005-01-07 cbbrowne doc/adminguide/maintenance.sgml,tools/log.pm,tools/run_rep_tests.sh,tools/test_slony_replication.pl
Added Perl/Bash scripts for testing how Slony-I replication is running.
Also added documentation on these scripts to the Admin guide.
=================================
2005-01-10 cbbrowne tools/altperl/drop_set.pl
Add Steve Simms usage, allow nodes to be 123 rather than node123
=================================
2005-01-10 cbbrowne tools/altperl/init_cluster.pl
Changes from Steve Simms to "init_cluster.pl"
- Allow location of tool config to be specified in the environment
- Have output that shouldn't go to Slonik be #commented out
=================================
2005-01-10 cbbrowne tools/altperl/subscribe_set.pl
Steve Simms changes - subscribe_set.pl - add usage printout, allow node to be
called 123 as well as node123
=================================
2005-01-10 cbbrowne tools/altperl/slon_kill.pl
Add usage output
Potentially use environment to determine where cluster information is
Turn reused logic into a function
=================================
2005-01-10 cbbrowne tools/altperl/README,tools/altperl/slon.env
Have a sequence parameter, $SEQUENCE_ID, to manage sequence IDs just like $TABLE_ID does for tables
=================================
2005-01-10 darcyb doc/adminguide/filelist.sgml,doc/adminguide/slonconf.sgml
document slon.conf configuration
=================================
2005-01-10 cbbrowne tools/altperl/create_set.pl
Use $SEQUENCE_ID rather than $SEQID, which will become an environment parameter.
Change suggested by Steve Simms
=================================
2005-01-10 cbbrowne tools/altperl/merge_sets.pl
Steve Simms changes - have usage, common config parameter, allow nodes
to be called 123 as well as node123
=================================
2005-01-10 cbbrowne doc/adminguide/slon.sgml,src/slon/confoptions.h,src/slon/remote_worker.c,src/slon/slon.c
Added a dynamic SYNC group "windowing" scheme, along with docs and
configuration option code.
This allows defining a target "desired_sync_time", defaulting to 1
minute, where, if replication is behind, slon will gradually increase
sync group sizes to try to get the expected time for the group to
take that period of time.
It backs off IMMEDIATELY, if there is a large or long running SYNC,
and starts at 1, and increases group sizes by the greater of 1 and
10% of the last group size. Once the node gets up to date, that
also causes it to back off to sync sizes of 1 or 2.
This makes it reasonable to have the maximum sync grouping set rather
high, as the groups will only get large gradually, in keeping with
how the system is performing.
=================================
2005-01-11 darcyb doc/adminguide/slonconf.sgml,share/slon.conf-sample
Document cbb's newly added desired_sync_time config option.
=================================
2005-01-12 cbbrowne doc/adminguide/faq.sgml
Add in discussion of the "long running idle transaction" problem.
=================================
2005-01-12 darcyb src/slon/cleanup_thread.c
fix copy/paste typo for deleteing from sl_log_* tables.
=================================
2005-01-12 cbbrowne doc/adminguide/reshape.sgml
Cleaned up SGML tagging a bit
=================================
2005-01-12 darcyb src/backend/slony1_funcs.c,src/slon/cleanup_thread.c,src/slon/conf-file.h,src/slon/confoptions.c,src/slon/confoptions.h,src/slon/dbutils.c,src/slon/local_listen.c,src/slon/misc.c,src/slon/misc.h,src/slon/remote_listen.c,src/slon/remote_worker.c,src/slon/runtime_config.c,src/slon/scheduler.c,src/slon/slon.c,src/slon/slon.h,src/slon/sync_thread.c,src/slonik/dbutil.c,src/slonik/slonik.c,src/slonik/slonik.h,src/xxid/xxid.c
pgindent run
=================================
2005-01-17 cbbrowne tools/altperl/slon_kill.pl
Mods per Steve Simms...
I also moved the "require $SLON_ENV_FILE" to a point *after*
the usage statement, so that it doesn't croak if slon.env isn't
present.
=================================
2005-01-18 cbbrowne doc/adminguide/faq.sgml,doc/adminguide/monitoring.sgml,tools/test_slony_state.pl
Added in a script to test the state of a Slony-I cluster, along with
some documentation
=================================
2005-01-18 cbbrowne doc/adminguide/faq.sgml
Added docs for a condition which breaks replication triggers
=================================
2005-01-18 cbbrowne doc/adminguide/ddlchanges.sgml,doc/adminguide/slonik_ref.sgml
Added some "best practices" material concerning how to better cope
with DDL changes.
This also pointed to documenting more precisely what the Slonik
"execute script" command does.
=================================
2005-01-19 darcyb share/DBITECH-SLONY-I-MIB.txt
Beginnings of snmp status and management interface for Slony
=================================
2005-01-21 darcyb share/DBITECH-SLONY-I-MIB.txt
Fix 2 typo's as pointed out by mastermind.
=================================
2005-01-23 cbbrowne doc/adminguide/faq.sgml,doc/adminguide/intro.sgml,doc/adminguide/listenpaths.sgml
Added FAQ entry, revised intro (textual revisions), fixed formatting of
listenpaths.sgml a bit
=================================
2005-01-24 cbbrowne doc/adminguide/README,doc/adminguide/addthings.html,doc/adminguide/altperl.html,doc/adminguide/app-slon.html,doc/adminguide/app-slonik.html,doc/adminguide/cluster.html,doc/adminguide/concepts.html,doc/adminguide/ddlchanges.html,doc/adminguide/definingsets.html,doc/adminguide/dropthings.html,doc/adminguide/failover.html,doc/adminguide/faq.html,doc/adminguide/firstdb.html,doc/adminguide/help.html,doc/adminguide/installation.html,doc/adminguide/listenpaths.html,doc/adminguide/maintenance.html,doc/adminguide/monitoring.html,doc/adminguide/requirements.html,doc/adminguide/reshape.html,doc/adminguide/slonconfig.html,doc/adminguide/slonik.html,doc/adminguide/slonstart.html,doc/adminguide/slony-commands.html,doc/adminguide/slony.html,doc/adminguide/slonyadmin.html,doc/adminguide/slonyintro.html,doc/adminguide/subscribenodes.html,doc/adminguide/t24.html,doc/adminguide/x267.html,doc/adminguide/x931.html
Apply changes from CVS HEAD admin guide into the stable branch as this
material will be useful for both versions
=================================
2005-01-24 cbbrowne doc/adminguide/addthings.sgml,doc/adminguide/adminscripts.sgml,doc/adminguide/concepts.sgml,doc/adminguide/faq.sgml,doc/adminguide/help.sgml,doc/adminguide/intro.sgml,doc/adminguide/monitoring.sgml,doc/adminguide/prerequisites.sgml,doc/adminguide/reference.sgml,doc/adminguide/slonik_ref.sgml,doc/adminguide/slony.sgml
Plenty of modifications to documentation; lots of textual changes.
=================================
2005-01-25 cbbrowne tools/altperl/slon_start.pl,tools/altperl/slon_watchdog.pl
slon_watchdog.pl.diff
- Added --config and --help options, as with other files
- Use a while loop instead of a recursive function for the watchdog process
- Allow node# to be given as just a number, as with other files
slon_start.pl.diff
- --help would fail if --config wasn't specified and slon.env wasn't in @INC
- Call slon_watchdog.pl using --config
--
Steve Simms
=================================
2005-01-26 darcyb src/slon/Makefile
Check for FLEX and bail if not present
=================================
2005-01-26 darcyb Makefile.global.in,aclocal.m4,configure.ac,config/perl.m4
Clean up detection of lex/yacc as well as check for perl's location
=================================
2005-01-26 darcyb configure
Bring sed detection forward
=================================
2005-01-26 darcyb Makefile.global.in,configure.ac
Add proper detection of sed since slonik relies on haveing sed available
=================================
2005-01-26 darcyb configure
Bring the previous configure.ac commit into the frontend
=================================
2005-01-26 darcyb src/slonik/Makefile,src/slonik/slonik.c
Use the detected version of sed
=================================
2005-01-26 darcyb tools/altperl/Makefile,tools/altperl/build_env.pl,tools/altperl/create_set.pl,tools/altperl/drop_node.pl,tools/altperl/drop_set.pl,tools/altperl/failover.pl,tools/altperl/init_cluster.pl,tools/altperl/merge_sets.pl,tools/altperl/move_set.pl,tools/altperl/regenerate-listens.pl,tools/altperl/restart_node.pl,tools/altperl/restart_nodes.pl,tools/altperl/show_configuration.pl,tools/altperl/show_nodes.pl,tools/altperl/slon-tools.pm,tools/altperl/slon.env,tools/altperl/slon_kill.pl,tools/altperl/slon_pushsql.pl,tools/altperl/slon_start.pl,tools/altperl/slon_watchdog.pl,tools/altperl/slon_watchdog2.pl,tools/altperl/subscribe_set.pl,tools/altperl/uninstall_nodes.pl,tools/altperl/unsubscribe_set.pl,tools/altperl/update_nodes.pl
Remove non required hash-bangs, and setup hash-bang substitution, provide method to remove .pl from scripts
=================================
2005-01-27 cbbrowne src/ducttape/test_1_pgbench_no_node1
Test where the nodes are numbered 11 and 22 rather than 1 and 2
to validate that you don't need a node #1
=================================
2005-01-28 cbbrowne src/slon/remote_listen.c
Reformatted function call contents to make indentation consistent
=================================
2005-01-28 cbbrowne src/slon/confoptions.h
Allow -t timeout parameter to be as much as 10 minutes long
=================================
2005-01-28 cbbrowne doc/adminguide/slon.sgml
Added comments about how SYNCs are not needed nearly as often on
subscriber nodes
=================================
2005-01-28 cbbrowne src/slon/remote_worker.c
A reference to last_sync_group_size was missed; added it back
And some reindentation...
=================================
2005-02-01 darcyb configure,configure.ac
Repair variable substitution problem with bison -y (remove trailing ,)
=================================
2005-02-02 cbbrowne doc/adminguide/failover.sgml,doc/adminguide/faq.sgml,doc/adminguide/slonik_ref.sgml
Improved discussion of FAILOVER and why it is vital that it abandon the
failed node.
=================================
2005-02-02 cbbrowne tools/altperl/README,tools/altperl/create_set.pl,tools/altperl/regenerate-listens.pl,tools/altperl/restart_nodes.pl,tools/altperl/show_configuration.pl,tools/altperl/slon-tools.pm,tools/altperl/slon.env,tools/altperl/slon_kill.pl,tools/altperl/slon_start.pl,tools/altperl/slon_watchdog.pl,tools/altperl/slon_watchdog2.pl,tools/altperl/uninstall_nodes.pl
Patches per Steve Simms to replace $SETNAME with $CLUSTER_NAME which
is really a much more consistent name to use to identify Slony-I
clusters...
Also, a change by Chris Browne that, for non-users of Apache log rotator,
puts the present timestamp in the name of the log file. That way there's
a rotation of sorts even if it isn't managed by "ALR".
=================================
2005-02-02 cbbrowne doc/adminguide/adminscripts.sgml
Alter documentation to reflect the renaming of "$SETNAME" to "$CLUSTER_NAME"
in the admin tools
=================================
2005-02-02 cbbrowne doc/adminguide/slony.sgml,doc/adminguide/usingslonik.sgml
Adding in a document to discuss "care and feeding" of embedding slonik
scripts
=================================
2005-02-02 cbbrowne tools/altperl/slon.env
Major additions to comments by Steve Simms
=================================
2005-02-02 cbbrowne doc/adminguide/addthings.sgml,doc/adminguide/adminscripts.sgml,doc/adminguide/ddlchanges.sgml,doc/adminguide/dropthings.sgml,doc/adminguide/failover.sgml,doc/adminguide/firstdb.sgml,doc/adminguide/help.sgml,doc/adminguide/listenpaths.sgml,doc/adminguide/maintenance.sgml,doc/adminguide/monitoring.sgml,doc/adminguide/reshape.sgml,doc/adminguide/slon.sgml,doc/adminguide/slonik.sgml,doc/adminguide/slony.sgml,doc/adminguide/startslons.sgml,doc/adminguide/subscribenodes.sgml
Whole bunch of Slony-I sections ought to be treated as a single
<ARTICLE> so that the table of contents is generated for the whole
lot of them rather than one for each section
=================================
2005-02-02 darcyb TODO
add request for upgrade docs, and more examples. remove cbb wik/fai now that it's intergrated
=================================
2005-02-07 cbbrowne doc/adminguide/ddlchanges.sgml
More commentary about pathologies
=================================
2005-02-07 cbbrowne doc/adminguide/installation.sgml,doc/adminguide/intro.sgml
Reshaped sectioning a bit to make things flow better
=================================
2005-02-07 cbbrowne doc/adminguide/defineset.sgml
Added some comments about how adding lots of sequences gets pathological
=================================
2005-02-07 cbbrowne doc/adminguide/prerequisites.sgml
Moved notes about PG 7.2 to new page on doing upgrades using Slony-I
=================================
2005-02-07 cbbrowne doc/adminguide/dropthings.sgml,doc/adminguide/plainpaths.sgml,doc/adminguide/slon.sgml,doc/adminguide/slonik.sgml
Added document on handling of plain paths...
Fixed tagging errors and such in various files
=================================
2005-02-07 cbbrowne doc/adminguide/slonik_ref.sgml
Retagging the intro material
=================================
2005-02-07 cbbrowne doc/adminguide/filelist.sgml
Added new documents
=================================
2005-02-07 cbbrowne doc/adminguide/slony.sgml
Reshaped it so it's only a few parts and a few articles
=================================
2005-02-07 cbbrowne doc/adminguide/versionupgrade.sgml
New article on using Slony-I to do version upgrades of PostgreSQL
=================================
2005-02-07 cbbrowne doc/adminguide/usingslonik.sgml
Reshaped sections a bit to improve flow of web pages
=================================
2005-02-07 cbbrowne doc/adminguide/faq.sgml
Evidently the "dup key" problem isn't SIG 11 and isn't (in an obvious way)
a corrupted index...
=================================
2005-02-09 cbbrowne doc/adminguide/addthings.sgml,doc/adminguide/adminscripts.sgml,doc/adminguide/cluster.sgml,doc/adminguide/concepts.sgml,doc/adminguide/ddlchanges.sgml,doc/adminguide/defineset.sgml,doc/adminguide/dropthings.sgml,doc/adminguide/failover.sgml,doc/adminguide/faq.sgml,doc/adminguide/firstdb.sgml,doc/adminguide/help.sgml,doc/adminguide/installation.sgml,doc/adminguide/intro.sgml,doc/adminguide/legal.sgml,doc/adminguide/listenpaths.sgml,doc/adminguide/maintenance.sgml,doc/adminguide/monitoring.sgml,doc/adminguide/plainpaths.sgml,doc/adminguide/reshape.sgml,doc/adminguide/slon.sgml,doc/adminguide/slonik.sgml,doc/adminguide/slony.sgml,doc/adminguide/startslons.sgml,doc/adminguide/subscribenodes.sgml,doc/adminguide/usingslonik.sgml,doc/adminguide/versionupgrade.sgml
Fix up tagging of documents; did a lot of SGML normalization.
=================================
2005-02-09 cbbrowne tools/altperl/regenerate-listens.pl
Vivek Khera updated this to use DBI
=================================
2005-02-10 smsimms tools/altperl/show_nodes.pl
This file was just a copy of init_cluster.pl, and had nothing to do
with showing node information.
=================================
2005-02-10 smsimms Makefile.global.in,tools/altperl/Makefile
Make sysconfdir and pglibdir available to sed
These will be used to store the altperl configuration file and
slon-tools.pm
=================================
2005-02-10 smsimms doc/adminguide/adminscripts.sgml,tools/altperl/README,tools/altperl/build_env.pl,tools/altperl/create_set.pl,tools/altperl/drop_node.pl,tools/altperl/drop_set.pl,tools/altperl/failover.pl,tools/altperl/init_cluster.pl,tools/altperl/merge_sets.pl,tools/altperl/move_set.pl,tools/altperl/restart_node.pl,tools/altperl/restart_nodes.pl,tools/altperl/show_configuration.pl,tools/altperl/slon.env,tools/altperl/slon_kill.pl,tools/altperl/slon_pushsql.pl,tools/altperl/slon_start.pl,tools/altperl/slon_tools.conf-sample,tools/altperl/slon_watchdog.pl,tools/altperl/slon_watchdog2.pl,tools/altperl/subscribe_set.pl,tools/altperl/uninstall_nodes.pl,tools/altperl/unsubscribe_set.pl,tools/altperl/update_nodes.pl
Use fixed paths for altperl tools configuration and library files.
The configuration file defaults to the "sysconfdir" argument to
configure (/usr/local/etc by default), and has been renamed to
slon_tools.conf, which seems to go along with the naming convention of
the configuration files in /usr/local/pgsql/data.
The slon-tools.pm library is installed in the pglibdir path.
I've also updated the relevant documentation to note the slon.env name
change.
=================================
2005-02-10 smsimms tools/altperl/Makefile,tools/altperl/slon_start.pl
Added an "install" target to Makefile. It copies the configuration
file, library, and slon start/stop/watch scripts to their relevant
directories. I'm holding off on the slonik scripts until we decide
where we want them to go.
Adjusted DISTDIRS to reflect the slon.env -> slon_tools.conf change.
Added a pgbindir substitution, and modified slon_start.pl so that it
uses that path to get to slon_watchdog.
=================================
2005-02-10 smsimms tools/altperl/build_env.pl,tools/altperl/drop_node.pl,tools/altperl/drop_set.pl,tools/altperl/failover.pl,tools/altperl/init_cluster.pl,tools/altperl/merge_sets.pl,tools/altperl/move_set.pl,tools/altperl/restart_node.pl,tools/altperl/restart_nodes.pl,tools/altperl/show_configuration.pl,tools/altperl/show_nodes.pl,tools/altperl/slon_kill.pl,tools/altperl/slon_pushsql.pl,tools/altperl/slon_start.pl,tools/altperl/slon_watchdog.pl,tools/altperl/slon_watchdog2.pl,tools/altperl/subscribe_set.pl,tools/altperl/uninstall_nodes.pl,tools/altperl/unsubscribe_set.pl,tools/altperl/update_nodes.pl
Removed Emacs hints from the #! line, which were preventing the
scripts from running on RH Linux.
=================================
2005-02-11 cbbrowne doc/adminguide/faq.sgml,doc/adminguide/prerequisites.sgml
Added documentation about how the slony user needs to not only be a
PostgreSQL "superuser" but to also have system table update privileges.
=================================
2005-02-11 darcyb share/Makefile,src/backend/Makefile,src/xxid/Makefile
Install .sql and .conf files as mode 644 not 755
=================================
2005-02-14 cbbrowne doc/adminguide/ddlchanges.sgml
More comments...
=================================
2005-02-14 smsimms tools/altperl/Makefile
Make "all" the default target.
Install slon_start, slon_kill, etc. instead of slon_start.pl,
slon_kill.pl, etc.
=================================
2005-02-14 smsimms tools/regenerate-listens.pl,tools/altperl/regenerate-listens.pl
Moved regenerate-listens.pl from tools/altperl to tools.
=================================
2005-02-15 cbbrowne doc/adminguide/faq.sgml
Added notes on a "missing OID" problem that can take place if you
drop a cluster but have some connection pool system (common for
Java apps) that keeps around connections that are pointing to
obsolete stored plans.
=================================
2005-02-15 cbbrowne doc/adminguide/faq.sgml,doc/adminguide/slonik_ref.sgml
Fix SGML tagging error, add link so that Slonik reference pages
point to the FAQ entry on 'missing OIDs' problem
=================================
2005-02-16 darcyb src/backend/slony1_funcs.sql
Fix cluster init, default log shipping to false, with cbb's blessing
=================================
2005-02-16 smsimms src/backend/slony1_funcs.sql
Provide a less cryptic error message when you pass a non-existent
tablename to determineIdxnameUnique or determineAttkindUnique.
=================================
2005-02-16 smsimms src/backend/slony1_funcs.sql
Add a missing WHERE clause that causes MOVE SET to fail when:
1. There are three or more nodes
2. Sets originate on at least two nodes
3. A set is being moved from a third node to one of the first two.
=================================
2005-02-17 cbbrowne src/ducttape/test_1_pgbench,src/ducttape/test_2_pgbench,src/ducttape/test_3_pgbench,src/ducttape/test_4_pgbench,src/ducttape/test_5_pgbench,src/ducttape/test_6_autolisten
Fix some misspellings
=================================
2005-02-17 wieck src/slon/confoptions.h,src/slon/remote_worker.c,src/slon/slon.c,tools/slony1_dump.sh
First cut on the log shipping mechanism.
The tools/slony1_dump.sh script can be used against a subscriber
to get a snapshot of a replica's user data plus minimal status
information.
If slon is started with -a <archivedir>, it will output an sql
script for every sync processing, containing statements that replicate
the changes plus keep the status information up to date. Note that these
scripts will have the same "grouping" of SYNC events that the replica
used.
Next steps:
Add output of archive files by slon for subscribing, unsubscribing
and merging of sets and for ddl script executions.
Jan
=================================
2005-02-17 cbbrowne doc/adminguide/slon.sgml,src/slon/remote_worker.c,src/slon/slon.c,src/slon/slon.h
1. Added DocBook documentation for "-a" slon option that writes log shipping
files
2. Added docs for "-a" option to slon runtime
3. Added SLON_MAX_PATH #define
4. Macro for TERMINATE_QUERY_AND_ARCHIVE; (This one may be dubious.)
=================================
2005-02-18 cbbrowne doc/adminguide/plainpaths.sgml
Docs on setting up STORE PATH entries versus ADMIN CONNINFO
=================================