francescoboccacci at libero.it francescoboccacci at libero.it
Tue Dec 14 07:14:42 PST 2010
Hi,
sorry if i have no insert a slonik version. I'm a new user of Slonik.
My version is slon version 2.0.4 and i have postgresql 8.4 in my server.
I run subscribe.sh in putty and now my question is:
If i disconnect putty section what happend to my slonik process?
Can i write these log rows into a log files?
Thanks for your help.

Francesco

>----Messaggio originale----
>Da: ssinger at ca.afilias.info
>Data: 14/12/2010 15.58
>A: "francescoboccacci at libero.it"<francescoboccacci at libero.it>
>Cc: <slony1-general at lists.slony.info>
>Ogg: Re: [Slony1-general] Slony message
>
>On 10-12-14 09:01 AM, francescoboccacci at libero.it wrote:
>> Hi to all.
>> I have some doubts about how slony-I replication process works.
>> I Have one master and 4 slaves that share some tables.
>> I create a cluster script and run it. After i run slon daemon in all 
nodes.
>> At
>> the end i run subscribe script. After this operation my server (linux) 
show
>> messages but i don't undestand if this is normal or what are. After 2 
hours
>> it
>> still show me message like these:
>>
>
>All of the messages below are normal messages from slony during normal 
>operations of slony.  I don't see any indication of a problem.
>
>If you connect to your slaves, do you see your data replicated?
>
>If your still having a problem look at what the 
>_sql_cluster_1_2_3_4_9.sl_status table contains.
>
>Also it is good practice to include which version of slony your using 
>when posting messages to the list.
>
>
>
>>
>>
>>
>>
>> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>> NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
>> CONTEXT:  SQL statement "SELECT  "_sql_cluster_1_2_3_4_9".
logswitch_start()"
>> PL/pgSQL function "cleanupevent" line 101 at PERFORM
>> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>> NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
>> CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment
>>
>> ..
>> and so on.
>> What happen? I need to restart some process or wait the end of the 
process?
>>
>> Please help me.
>>
>> Thanks to all
>>
>> Francesco
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
>
>




More information about the Slony1-general mailing list