<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre wrap="">slonik_init_cluster |slonik
</pre>
bijayant kumar wrote:
<blockquote cite="mid:212398.88459.qm@web32705.mail.mud.yahoo.com"
type="cite">
<pre wrap="">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 - <a class="moz-txt-link-abbreviated" href="mailto:bijayant@192.168.99.23">bijayant@192.168.99.23</a>');
# STORE NODE
store node (id = 2, event node = 1, comment = 'Node 2 - <a class="moz-txt-link-abbreviated" href="mailto:bijayant@192.168.99.134">bijayant@192.168.99.134</a>');
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 <a class="moz-txt-link-rfc2396E" href="mailto:m.eriksson@albourne.com"><m.eriksson@albourne.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">From: Martin Eriksson <a class="moz-txt-link-rfc2396E" href="mailto:m.eriksson@albourne.com"><m.eriksson@albourne.com></a>
Subject: Re: [Slony1-general] Node is not initialized properly
To:
Cc: <a class="moz-txt-link-abbreviated" href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>
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:
</pre>
<blockquote type="cite">
<pre wrap="">Hello list,
I am a very new user of slony1 so please forgive me if
</pre>
</blockquote>
<pre wrap="">i am asking very stupid question.
</pre>
<blockquote type="cite">
<pre wrap="">I have installed Postgresql and Slony1 on two gentoo
</pre>
</blockquote>
<pre wrap="">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
</pre>
<blockquote type="cite">
<pre wrap="">test database with one single table and only one entry
</pre>
</blockquote>
<pre wrap="">into it. But when i start slony1 i get error like
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST ERROR cannot get
</pre>
</blockquote>
<pre wrap="">sl_local_node_id - ERROR: schema "_bijayant"
does not exist
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST FATAL main: Node is not
</pre>
</blockquote>
<pre wrap="">initialized properly - sleep 10s
</pre>
<blockquote type="cite">
<pre wrap="">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"
</pre>
</blockquote>
<pre wrap="">=> [
</pre>
<blockquote type="cite">
<pre wrap=""> '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" => [
</pre>
</blockquote>
<pre wrap="">'public.kavach',
</pre>
<blockquote type="cite">
<pre wrap=""> ],
},
};
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
</pre>
</blockquote>
<pre wrap="">both the machine it generates lots of logs with errors line
like
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST DEBUG2 slon_retry() from
</pre>
</blockquote>
<pre wrap="">pid=19007
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST DEBUG1 slon: retry requested
2008-06-30 15:54:55 IST DEBUG2 slon: notify worker
</pre>
</blockquote>
<pre wrap="">process to shutdown
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST DEBUG2 slon: child terminated
</pre>
</blockquote>
<pre wrap="">status: 0; pid: 19007, current worker pid: 19007
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST DEBUG1 slon: restart of worker
2008-06-30 15:54:55 IST CONFIG main: slon version
</pre>
</blockquote>
<pre wrap="">1.2.10 starting up
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST DEBUG2 slon: watchdog process
</pre>
</blockquote>
<pre wrap="">started
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST DEBUG2 slon: watchdog ready -
</pre>
</blockquote>
<pre wrap="">pid = 19005
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST DEBUG2 slon: worker process
</pre>
</blockquote>
<pre wrap="">created - pid = 19034
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST ERROR cannot get
</pre>
</blockquote>
<pre wrap="">sl_local_node_id - ERROR: schema "_bijayant"
does not exist
</pre>
<blockquote type="cite">
<pre wrap="">2008-06-30 15:54:55 IST FATAL main: Node is not
</pre>
</blockquote>
<pre wrap="">initialized properly - sleep 10s
</pre>
<blockquote type="cite">
<pre wrap="">I am sure that i am not understanding some basic
</pre>
</blockquote>
<pre wrap="">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.
</pre>
<blockquote type="cite">
<pre wrap="">Thanks & Regards,
Bijayant Kumar
Send instant messages to your online friends
</pre>
</blockquote>
<pre wrap=""><a class="moz-txt-link-freetext" href="http://uk.messenger.yahoo.com">http://uk.messenger.yahoo.com</a>
</pre>
<blockquote type="cite">
<pre wrap="">_______________________________________________
Slony1-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a>
</pre>
</blockquote>
<pre wrap=""><a class="moz-txt-link-freetext" href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a>
</pre>
<blockquote type="cite">
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">_______________________________________________
Slony1-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a>
<a class="moz-txt-link-freetext" href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a>
</pre>
</blockquote>
<pre wrap=""><!---->
Send instant messages to your online friends <a class="moz-txt-link-freetext" href="http://uk.messenger.yahoo.com">http://uk.messenger.yahoo.com</a>
_______________________________________________
Slony1-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a>
<a class="moz-txt-link-freetext" href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a>
</pre>
</blockquote>
<br>
</body>
</html>