Hans-Jürgen Schönig postgres
Tue Dec 27 14:42:35 PST 2005
i am about to setup a large slony system but i have encountered some 
problems with log shipping.
i set up a simple master slave scenario (pgbench) with one master and 
one slave (pgbench and pgbenchslave)
i managed to enable log shipping and all logs go to my desired location 
- no problems so far. the target is to replay the logs in a db called 
pgbenchlog

however, i got the following files:

...
-rw-rw-r--  1 hs hs  128903 27. Dez 13:54 
slony1_log_1_00000000000000000065.sql
-rw-rw-r--  1 hs hs   93106 27. Dez 13:54 
slony1_log_1_00000000000000000066.sql
-rw-rw-r--  1 hs hs    9165 27. Dez 13:54 
slony1_log_1_00000000000000000067.sql
-rw-rw-r--  1 hs hs   91986 27. Dez 13:54 
slony1_log_1_00000000000000000068.sql
-rw-rw-r--  1 hs hs    5050 27. Dez 13:54 
slony1_log_1_00000000000000000069.sql
-rw-rw-r--  1 hs hs     567 27. Dez 13:54 
slony1_log_1_00000000000000000070.sql
-rw-rw-r--  1 hs hs     567 27. Dez 13:54 
slony1_log_1_00000000000000000071.sql
-rw-rw-r--  1 hs hs     567 27. Dez 13:54 
slony1_log_1_00000000000000000072.sql
-rw-rw-r--  1 hs hs     567 27. Dez 13:54 
slony1_log_1_00000000000000000073.sql
-rw-rw-r--  1 hs hs     298 27. Dez 13:49 
slony1_log_2_00000000000000000007.sql
-rw-rw-r--  1 hs hs     299 27. Dez 13:49 
slony1_log_2_00000000000000000008.sql
-rw-rw-r--  1 hs hs     298 27. Dez 13:49 
slony1_log_2_00000000000000000009.sql
-rw-rw-r--  1 hs hs     302 27. Dez 13:50 
slony1_log_2_00000000000000000017.sql
-rw-rw-r--  1 hs hs 9490126 27. Dez 13:51 
slony1_log_2_00000000000000000018.sql
-rw-rw-r--  1 hs hs     302 27. Dez 13:43 
slony1_log_2_00000000000000000022.sql
-rw-rw-r--  1 hs hs      71 27. Dez 13:44 
slony1_log_2_00000000000000000023.sql.tmp

why do it get _1_ and _2_ files? as far as i have seen _%d_ gives me the 
number of the node. how can it be? all data should go to the same node ...
obviously the logs which are created when adding node2 will be in _2_ 
while ordinary pgbench operations are sent to _1_ ...

our greatest problem is: how can we replay those logs? to more precise? 
where shall i start?
i have seen slony1_dump.sh. it seems that the output of this script has 
to be applied on top of a dumped / restored database after running "DROP 
SCHEMA _slony_test CASCADE;".
we have read docs a couple of times but we have no idea how to replay 
properly (which dump shall we use to start?).

can anybody provide us with some more information? maybe somebody 
already has sample scripts to do the replay or to add a completely new 
(log shipping based) node to a working config.

	many thanks,

		hans



More information about the Slony1-general mailing list