Tue Jul 1 00:00:19 PDT 2008
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Thanks to all for the reply. Now i think that i am coming closer to run slonik. When i did as suggested by all bijayant ~ # slonik_init_cluster --config /etc/slon_tools.conf | slonik <stdin>:6: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: could not access file "$libdir/xxid": No such file or directory <stdin>:6: Error: the extension for the xxid data type cannot be loaded in database 'host=192.168.99.23 dbname=bijayant user=bijayant port=5432 password=bijayant' <stdin>:6: ERROR: no admin conninfo for node 134598992 The first two lines of the error i couldnot understand. The "admin conninfo" error, i think this parameter should be present in conf file, right? But in my case what should be there, as i am already giving the username and password to connect to the postgresql database. In this problem thread one gentleman has asked me to check whether "_bijayant" schema is created or not? I am sorry to ask but i really dont know about this. I have only created a user,database and table in the postgresql database nothing else. When we create database, schema is also created automatically, right? Please suggest me what should i do next. Sorry but i am very new to slonik and database. I am trying hard to understand the concept Thanks & Regards, 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, 8:34 PM > 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 > > > > _______________________________________________ > 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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list