Tue Dec 27 14:42:35 PST 2005
- Previous message: [Slony1-general] sl_subscribe incorrect after failover
- Next message: [Slony1-general] Slonik : not found
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] sl_subscribe incorrect after failover
- Next message: [Slony1-general] Slonik : not found
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list