Mon Jun 30 08:04:24 PDT 2008
- Previous message: [Slony1-general] Node is not initialized properly
- Next message: [Slony1-general] Node is not initialized properly
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
If you only run it like that, it only prints what it will execute, to actually execute this you need to | it to the slonik app.. eg. /data/pgsql/slony/slonik_init_cluster --config <file> | /data/pgsql/bin/slonik all scripts starting with "slonik_" doesn't actually do anything themself, its just a way to format a command correctly for the slonik parser, which actually does the work.. bijayant kumar wrote: > Thanks for the reply. I executed the command "slonik_init_cluster".It gives the output like > > # INIT CLUSTER > cluster name = bijayant; > node 1 admin conninfo='host=192.168.99.23 dbname=bijayant user=bijayant port=5432 password=bijayant'; > node 2 admin conninfo='host=192.168.99.134 dbname=bijayant user=bijayant port=5432 password=bijayant'; > init cluster (id = 1, comment = 'Node 1 - bijayant at 192.168.99.23'); > > # STORE NODE > store node (id = 2, event node = 1, comment = 'Node 2 - bijayant at 192.168.99.134'); > echo 'Set up replication nodes'; > > # STORE PATH > echo 'Next: configure paths for each node/origin'; > store path (server = 1, client = 2, conninfo = 'host=192.168.99.23 dbname=bijayant user=bijayant port=5432 password=bijayant'); > store path (server = 2, client = 1, conninfo = 'host=192.168.99.134 dbname=bijayant user=bijayant port=5432 password=bijayant'); > echo 'Replication nodes prepared'; > echo 'Please start a slon replication daemon for each node'; > > After that i run the slonik daemon and got the error mentioned. > > > Bijayant Kumar > > > --- On Mon, 30/6/08, Martin Eriksson <m.eriksson at albourne.com> wrote: > > >> From: Martin Eriksson <m.eriksson at albourne.com> >> Subject: Re: [Slony1-general] Node is not initialized properly >> To: >> Cc: slony1-general at lists.slony.info >> Date: Monday, 30 June, 2008, 7:18 PM >> Very basic, but saw no mention of it in the e-mail, >> >> I assume you ran the "slonik_init_cluster" before >> trying to start the >> slon daemons? as that does the slony setup on each of the >> dbs >> >> >> >> bijayant kumar wrote: >> >>> Hello list, >>> >>> I am a very new user of slony1 so please forgive me if >>> >> i am asking very stupid question. >> >>> I have installed Postgresql and Slony1 on two gentoo >>> >> machine. Postgresql is working fine no problem at all. I >> want to use Slony1 to replicate the two databases across >> the systems. To understand the slony1 concept i made a >> >>> test database with one single table and only one entry >>> >> into it. But when i start slony1 i get error like >> >>> 2008-06-30 15:54:55 IST ERROR cannot get >>> >> sl_local_node_id - ERROR: schema "_bijayant" >> does not exist >> >>> 2008-06-30 15:54:55 IST FATAL main: Node is not >>> >> initialized properly - sleep 10s >> >>> Now i am giving here my configuration details. >>> >>> /* Master Server */ >>> IP Address 192.168.99.23 >>> Database name bijayant >>> Table name kavach >>> >>> bijayant=# select * from kavach; >>> id | name | designation | address >>> ----+----------+-------------+------------- >>> 1 | Bijayant | consultant | Lakkasandra >>> (1 row) >>> >>> >>> vi /etc/slon_tools.conf >>> >>> if ($ENV{"SLONYNODES"}) { >>> require $ENV{"SLONYNODES"}; >>> } else { >>> $CLUSTER_NAME = 'bijayant'; >>> $LOGDIR = '/var/log/slony'; >>> $MASTERNODE = 1; >>> add_node(node => 1, >>> host => '192.168.99.23', >>> dbname => 'bijayant', >>> port => 5432, >>> user => 'bijayant', >>> password => 'bijayant'); >>> >>> add_node(node => 2, >>> host => '192.168.99.134', >>> dbname => 'bijayant', >>> port => 5432, >>> user => 'bijayant', >>> password => 'bijayant', >>> parent => 1 >>> ); >>> } >>> >>> $SLONY_SETS = { >>> "set1" => { >>> "set_id" => 1, >>> "pkeyedtables" >>> >> => [ >> >>> 'public.kavach', >>> ], >>> }, >>> if ($ENV{"SLONYSET"}) { >>> require $ENV{"SLONYSET"}; >>> } >>> >>> 1; >>> >>> vi /etc/conf.d/slony1 >>> USER=postgres >>> CLUSTER=bijayant >>> DBUSER=bijayant >>> DBNAME=bijayant >>> DBHOST=192.168.99.23 >>> LOGFILE=/var/lib/postgresql/data/slony1.log >>> LOGLEVEL=4 >>> >>> /* On the Slave Server */ >>> >>> IP Address 192.168.99.134 >>> Database name bijayant >>> Table name kavach >>> >>> vi /etc/slon_tools.conf >>> >>> if ($ENV{"SLONYNODES"}) { >>> require $ENV{"SLONYNODES"}; >>> } else { >>> $CLUSTER_NAME = 'bijayant'; >>> $LOGDIR = '/var/log/slony'; >>> # SYNC check interval (slon -s option) >>> # $SYNC_CHECK_INTERVAL = 1000; >>> $MASTERNODE = 1; >>> add_node(node => 1, >>> host => '192.168.99.23', >>> dbname => 'bijayant', >>> port => 5432, >>> user => 'bijayant', >>> password => 'bijayant'); >>> >>> add_node(node => 2, >>> host => '192.168.99.134', >>> dbname => 'bijayant', >>> port => 5432, >>> user => 'bijayant', >>> password => 'bijayant', >>> parent => 1 >>> ); >>> } >>> $SLONY_SETS = { >>> "set1" => { >>> "set_id" => 1, >>> "pkeyedtables" => [ >>> >>> >> 'public.kavach', >> >>> ], >>> }, >>> }; >>> >>> if ($ENV{"SLONYSET"}) { >>> require $ENV{"SLONYSET"}; >>> } >>> >>> 1; >>> >>> vi /etc/conf.d/slony1 >>> USER=postgres >>> CLUSTER=bijayant >>> DBUSER=bijayant >>> DBNAME=bijayant >>> DBHOST=192.168.99.23 >>> LOGFILE=/var/lib/postgresql/data/slony1.log >>> LOGLEVEL=4 >>> >>> When i start the slony1 /etc/init.d/slony1 start on >>> >> both the machine it generates lots of logs with errors line >> like >> >>> 2008-06-30 15:54:55 IST DEBUG2 slon_retry() from >>> >> pid=19007 >> >>> 2008-06-30 15:54:55 IST DEBUG1 slon: retry requested >>> 2008-06-30 15:54:55 IST DEBUG2 slon: notify worker >>> >> process to shutdown >> >>> 2008-06-30 15:54:55 IST DEBUG2 slon: child terminated >>> >> status: 0; pid: 19007, current worker pid: 19007 >> >>> 2008-06-30 15:54:55 IST DEBUG1 slon: restart of worker >>> 2008-06-30 15:54:55 IST CONFIG main: slon version >>> >> 1.2.10 starting up >> >>> 2008-06-30 15:54:55 IST DEBUG2 slon: watchdog process >>> >> started >> >>> 2008-06-30 15:54:55 IST DEBUG2 slon: watchdog ready - >>> >> pid = 19005 >> >>> 2008-06-30 15:54:55 IST DEBUG2 slon: worker process >>> >> created - pid = 19034 >> >>> 2008-06-30 15:54:55 IST ERROR cannot get >>> >> sl_local_node_id - ERROR: schema "_bijayant" >> does not exist >> >>> 2008-06-30 15:54:55 IST FATAL main: Node is not >>> >> initialized properly - sleep 10s >> >>> I am sure that i am not understanding some basic >>> >> things about the slony1. Can anybody help me to understand >> the logic, i will be very helpful for you all. Please tell >> me what i am doing wrong here, what should i do. I have >> read the documentation at the website but not able to >> understand fully. Please help me out. >> >>> Thanks & Regards, >>> Bijayant Kumar >>> >>> Send instant messages to your online friends >>> >> http://uk.messenger.yahoo.com >> >>> _______________________________________________ >>> Slony1-general mailing list >>> Slony1-general at lists.slony.info >>> >>> >> http://lists.slony.info/mailman/listinfo/slony1-general >> >>> >>> >> _______________________________________________ >> Slony1-general mailing list >> Slony1-general at lists.slony.info >> http://lists.slony.info/mailman/listinfo/slony1-general >> > > Send instant messages to your online friends http://uk.messenger.yahoo.com >
- Previous message: [Slony1-general] Node is not initialized properly
- Next message: [Slony1-general] Node is not initialized properly
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list