Jan:
        How are you!
    Thank you for your patience and all answer!Thank you very much !
I had subscribe Slony-I General discussion mailing list via this web:http://gborg.postgresql.org/mailman/listinfo/slony1-general
I register email is : ambetty at sina.com
name is : sun.betty

and after submit :
Slony1-general Subscription results
Your subscription request has been received, and will soon be acted upon. Depending on the configuration of this mailing list, your subscription request may have to be first confirmed by you via email, or approved by the list moderator. If confirmation is required, you will soon get a confirmation email which contains further instructions. 

but up to the present,I have not receive confirm email.
I meet new question and this question is urgent,if you know please tell me.Thank you.

I read slony1-1.0.5\doc\howto\slony-I-failover.txt more than three times over.
but I not understand Failover chapter .
question1: 
when time should use Failover chapter's slonik command and step?
question2: 
how to stop slon process (start with : slon golf "dbname=db2 user=posta host=10.10.11.12 port=9543" &).
except for use ps command find out pid and then kill -9 pid command. whether or not have slon command carry out stop function.
question3:
if had exec (slonik command : drop node (id = 1, event node = 2);) at node1. slon process
was stop and cluster was delete,now at node1 start slon process (slonik command : slon golf "dbname=db2 user=posta host=10.10.11.12 port=9543" &)
show error info :  
CONFIG main: slon version 1.0.5 starting up
ERROR  cannot get sl_local_node_id - ERROR:  schema "_golf" does not exist
FATAL  main: Node is not initialized properly

how to recover node1's cluster ? because I only set up two node slon replicate(one Master another is Slave).

----- Original Message -----
From:Jan Wieck <JanWieck at Yahoo.com>
To:betty_sun0 <ambetty at sina.com>
Subject:Re: [Slony1-general] Slony-I Error! Please help me!Thank you!
Date:Mon, 6 Dec 2004 22:16:51 +0800
 >On 12/6/2004 2:54 AM, betty_sun0 wrote:
 >> Jan:
 >>      Sorry! I look for public mailing list but not found at
 >> http://gborg.postgresql.org/project/slony1/projdisplay.php
 >> Please tell me how to contact with your team.Thank you very much.
 >
 >Subscribe to the Slony-I General discussion mailing list via this web 
 >interface:
 >
 >     http://gborg.postgresql.org/mailman/listinfo/slony1-general
 >
 >You will get a confirmation email to ensure that the subscription was 
 >not done accidentially by a robot. Follow the instructions in that email 
 >to finally activate the subscription.
 >
 > From then on, send your questions to 
 >slony1-general at gborg.postgresql.org and all the members in the Slony-I 
 >team will be able to help you.
 >
 >
 >Jan
 >
 >
 >> 
 >>     Now.my question was resolve. your answer help me more .so Thank you a lot.I am not good at English .Thank you very much .
 >> 
 >> ---- Original Message -----
 >> From:Jan Wieck <JanWieck at Yahoo.com>
 >> To:betty_sun0 <ambetty at sina.com>
 >> Subject:Re: [Slony1-general] Slony-I Error! Please help me!Thank you!
 >> Date:Mon, 6 Dec 2004 10:57:09 +0800
 >>  >Please send your questions to the public mailing list so that everyone 
 >>  >in our team can help you.
 >>  >
 >>  >
 >>  >Jan
 >>  >
 >>  >
 >>  >On 12/5/2004 9:52 PM, betty_sun0 wrote:
 >>  >> Jan:
 >>  >>       I still have some question about slony-I and postgres
 >>  >>       first question :
 >>  >>       about threadsafe-libpq-742.diff.gz how to patch?
 >>  >>       (1)I try to : pkgadd -d threadsafe-libpq-742.diff
 >>  >>       show error:
 >>  >>       pkgadd: ERROR: attempt to process datastream failed
 >>  >>     - bad format in datastream table-of-contents
 >>  >> pkgadd: ERROR: could not process datastream from </data/postc/threadsafe-libpq-742.diff>
 >>  >>       (2)I try to : 
 >>  >> /usr/local/bin/patch -d ./postgresql-7.4 < threadsafe-libpq-742.diff
 >>  >> show this:
 >>  >> patching file aclocal.m4
 >>  >> patching file acx_pthread.m4
 >>  >> can't find file to patch at input line 219
 >>  >> Perhaps you should have used the -p or --strip option?
 >>  >> The text leading up to this was:
 >>  >> --------------------------
 >>  >> |diff -crN pgsql-server-REL7_4_2/config/c-library.m4 pgsql-server-threadsafe-libpq/config/c-library.m4
 >>  >> |*** pgsql-server-REL7_4_2/config/c-library.m4  Wed Jul 23 19:30:39 2003
 >>  >> |--- pgsql-server-threadsafe-libpq/config/c-library.m4  Thu Mar 25 12:57:16 2004
 >>  >> --------------------------
 >>  >> File to patch:
 >>  >> what File ? ???
 >>  >> (3) I watch postgresql's configure --help :
 >>  >> --enable-thread-safety  make client libraries thread-safe
 >>  >> this option not have value not like this:--build=BUILD
 >>  >> so I not understand how to patch threadsafe-libpq-742.diff.gz
 >>  >> 
 >>  >> second question:
 >>  >> I run slon show error:
 >>  >> $ slon test3 "dbname=db3 user=postgre host=10.10.11.12"
 >>  >> CONFIG main: slon version 1.0.5 starting up
 >>  >> CONFIG main: local node id = 1
 >>  >> CONFIG main: loading current cluster configuration
 >>  >> CONFIG storeNode: no_id=2 no_comment='Slave node'
 >>  >> CONFIG storePath: pa_server=2 pa_client=1 pa_conninfo="dbname=db3 host=10.10.11.21 user=postgre" pa_connretry=10
 >>  >> CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2
 >>  >> CONFIG storeSet: set_id=1 set_origin=1 set_comment='All pgbench tables'
 >>  >> CONFIG main: configuration complete - starting threads
 >>  >> CONFIG enableNode: no_id=2
 >>  >> ERROR  remoteListenThread_2: "select ev_origin, ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid, ev_xip,        ev_type,        ev_data1, ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8 from "_test3".sl_event e where (e.ev_origin = '2' and e.ev_seqno > '0') order by e.ev_origin, e.ev_seqno" - could not receive data from server: Error 0
 >>  >> ERROR  remoteListenThread_2: "select ev_origin, ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid, ev_xip,        ev_type,        ev_data1, ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8 from "_test3".sl_event e where (e.ev_origin = '2' and e.ev_seqno > '0') order by e.ev_origin, e.ev_seqno" - could not receive data from server: Error 0
 >>  >> ERROR  remoteListenThread_2: "select ev_origin, ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid, ev_xip,        ev_type,        ev_data1, ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8 from "_test3".sl_event e where (e.ev_origin = '2' and e.ev_seqno > '0') order by e.ev_origin, e.ev_seqno" - could not receive data from server: Error 0
 >>  >> ERROR  remoteListenThread_2: "select ev_origin, ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid, ev_xip,        ev_type,        ev_data1, ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8 from "_test3".sl_event e where (e.ev_origin = '2' and e.ev_seqno > '0') order by e.ev_origin, e.ev_seqno" - could not receive data from server: Error 0
 >>  >> ERROR  remoteListenThread_2: "select ev_origin, ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid, ev_xip,        ev_type,        ev_data1, ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8 from "_test3".sl_event e where (e.ev_origin = '2' and e.ev_seqno > '0') order by e.ev_origin, e.ev_seqno" - could not receive data from server: Error 0
 >>  >> ERROR  remoteListenThread_2: "select ev_origin, ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid, ev_xip,        ev_type,        ev_data1, ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8 from "_test3".sl_event e where (e.ev_origin = '2' and e.ev_seqno > '0') order by e.ev_origin, e.ev_seqno" - could not receive data from server: Error 0
 >>  >> ERROR  remoteListenThread_2: "select ev_origin, ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid, ev_xip,        ev_type,        ev_data1, ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8 from "_test3".sl_event e where (e.ev_origin = '2' and e.ev_seqno > '0') order by e.ev_origin, e.ev_seqno" - could not receive data from server: Error 0
 >>  >> 
 >>  >> show above error is libpq's reason?and what else reason?
 >>  >> 
 >>  >> Thank you for your help. I have advice about Slony-I , Slony-I not INSTALL document explain at Slony-I net.
 >>  >> "Replicating Your First Database" not include install and configure .may be could include this some content.That's perfect!
 >>  >> 
 >>  >> -----------------------------------------------------------
 >>  >> ----- Original Message -----
 >>  >> From:Jan Wieck <JanWieck at Yahoo.com>
 >>  >> To:betty_sun0 <ambetty at sina.com>
 >>  >> Subject:Re: [Slony1-general] Slony-I Error! Please help me!Thank you!
 >>  >> Date:Fri, 3 Dec 2004 23:36:43 +0800
 >>  >>  >CC'd to Slony-I general mailing list.
 >>  >>  >
 >>  >>  >You should patch, reconfigure and reinstall PostgreSQL (there is no such 
 >>  >>  >thing as postgre by the way, it is either Postgres or PostgreSQL, but 
 >>  >>  >never postgre).
 >>  >>  >
 >>  >>  >There is a patch for 7.4.x available on the Slony homepage that is 
 >>  >>  >required for Solaris in order to recompile the libpq with the right 
 >>  >>  >thread support. Without that, the slon process will not work on Solaris. 
 >>  >>  >Please apply that patch to your PostgreSQL source tree, reconfigure with 
 >>  >>  >the option --enable-thread-safety, recompile and reinstall. Then 
 >>  >>  >reconfigure Slony, pointing to that sourcetree.
 >>  >>  >
 >>  >>  >And you have to do this entire procedure on every machine that you want 
 >>  >>  >to become a Slony node, regardless of master or slave. Slony does not 
 >>  >>  >really have master and slave nodes. It is a network of nodes, some of 
 >>  >>  >them have tables originating locally and all others have replicas of 
 >>  >>  >those tables. But each table could originate on a different node.
 >>  >>  >
 >>  >>  >And please, keep discussions on the mailing lists so that they are 
 >>  >>  >archived in a public place searchable by others who might find themself 
 >>  >>  >in similar problems.
 >>  >>  >
 >>  >>  >
 >>  >>  >Jan
 >>  >>  >
 >>  >>  >
 >>  >>  >On 12/3/2004 2:44 AM, betty_sun0 wrote:
 >>  >>  >
 >>  >>  >> Jan:
 >>  >>  >>          How are you!
 >>  >>  >>     at the preview letter you say:
 >>  >>  >> I assume this error is in response to the "store node (id=2, ..." line. 
 >>  >>  >> The line breaks make it rather impossible to tell for real.
 >>  >>  >> 
 >>  >>  >> This would mean that on the server with IP address 10.10.11.21 the Slony 
 >>  >>  >> installation wasn't done correctly. Please note that $libdir does NOT 
 >>  >>  >> reference any environment variable presing in the slonik or even 
 >>  >>  >> postmaster environment. It is the compile time decided library directory 
 >>  >>  >> hard coded into the PostgreSQL server process. It is the same location 
 >>  >>  >> where PostgreSQL installed the plpgsql loadable object.
 >>  >>  >> --------------------------------------------------------
 >>  >>  >>> CLUSTERNAME=slony_db2
 >>  >>  >>> MASTERDBNAME=db2
 >>  >>  >>> SLAVEDBNAME=db2
 >>  >>  >>> MASTERHOST=10.10.11.12
 >>  >>  >>> SLAVEHOST=10.10.11.21
 >>  >>  >>> REPLICATIONUSER=postgre
 >>  >>  >>> PGBENCHUSER=postgre
 >>  >>  >> 
 >>  >>  >> IP : 10.10.11.21 is slave server and 10.10.11.12 is master server . Slony-I install on 10.10.11.12 host.Slave server not install Slony-I .10.10.11.12 and 10.10.11.21 is two different host.both host is SunOS5.8
 >>  >>  >> I try to Understand your letter mean.
 >>  >>  >> $libdir : This variable I found in postgresql.conf file .
 >>  >>  >> and this sentence:
 >>  >>  >> It is the same location where PostgreSQL installed the plpgsql loadable object.
 >>  >>  >> this location should is lib path of postgre db
 >>  >>  >> install Slony-I not found Error:
 >>  >>  >> $ ./configure --with-pgsourcetree=/u3/postgre/src/postgresql-7.4 --enable-thread-safety=threadsafe-libpq-742.diff --libdir=/u3/postgre/pgsql/lib
 >>  >>  >> checking build system type... sparc-sun-solaris2.8
 >>  >>  >> checking host system type... sparc-sun-solaris2.8
 >>  >>  >> checking which template to use... solaris
 >>  >>  >> checking for gcc... gcc
 >>  >>  >> checking for C compiler default output... a.out
 >>  >>  >> checking whether the C compiler works... yes
 >>  >>  >> checking whether we are cross compiling... no
 >>  >>  >> checking for suffix of executables... 
 >>  >>  >> checking for suffix of object files... o
 >>  >>  >> checking whether we are using the GNU C compiler... yes
 >>  >>  >> checking whether gcc accepts -g... yes
 >>  >>  >> checking for ld used by GCC... /usr/ccs/bin/ld
 >>  >>  >> checking if the linker (/usr/ccs/bin/ld) is GNU ld... no
 >>  >>  >> checking whether pthreads work with -pthread... no
 >>  >>  >> checking whether pthreads work with -pthreads... yes
 >>  >>  >> checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
 >>  >>  >> checking if more special flags are required for pthreads... -D_REENTRANT
 >>  >>  >> checking for cc_r... gcc
 >>  >>  >> pgsources in /u3/postgre/src/postgresql-7.4
 >>  >>  >> checking for PQfreemem() in libpq... yes
 >>  >>  >> checking for PQputCopyData() in libpq... yes
 >>  >>  >> checking for PQsetNoticeReceiver() in libpq... yes
 >>  >>  >> checking for typcache.h... yes
 >>  >>  >> configure: creating ./config.status
 >>  >>  >> config.status: creating Makefile.global
 >>  >>  >> config.status: creating GNUmakefile
 >>  >>  >> config.status: creating postgresql-slony1-engine.spec
 >>  >>  >> config.status: creating config.h
 >>  >>  >> $ make all
 >>  >>  >> for subdir in src doc ; do 
 >>  >>   make -C $subdir all || exit; 
 >>  >>     done && 
 >>  >> echo "All of Slony-I is successfully made. Ready to install"
 >>  >>  >> make[1]: Entering directory `/u3/postgre/slony1-1.0.5/src'
 >>  >>  >> for subdir in xxid slon slonik backend ducttape ; do 
 >>  >>   make -C $subdir all ; 
 >>  >>     done
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/xxid'
 >>  >>  >> /usr/local/bin/gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fPIC -I/u3/postgre/src/postgresql-7.4/src/include   -c -o xxid.o xxid.c
 >>  >>  >> /usr/ccs/bin/ld -G -Bdynamic -o xxid.so xxid.o
 >>  >>  >> cp xxid.v73.sql xxid.v74.sql
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/xxid'
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/slon'
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o slon.o slon.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from slon.c:27:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from slon.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o runtime_config.o runtime_config.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from runtime_config.c:27:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from runtime_config.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o local_listen.o local_listen.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from local_listen.c:27:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from local_listen.c:15:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> local_listen.c: In function `localListenThread_main':
 >>  >>  >> local_listen.c:664: warning: control reaches end of non-void function
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o remote_listen.o remote_listen.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from remote_listen.c:27:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from remote_listen.c:15:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> remote_listen.c: In function `remoteListenThread_main':
 >>  >>  >> remote_listen.c:391: warning: control reaches end of non-void function
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o remote_worker.o remote_worker.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from remote_worker.c:26:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from remote_worker.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> remote_worker.c: In function `remoteWorkerThread_main':
 >>  >>  >> remote_worker.c:1029: warning: control reaches end of non-void function
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o sync_thread.o sync_thread.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from sync_thread.c:26:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from sync_thread.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> sync_thread.c: In function `syncThread_main':
 >>  >>  >> sync_thread.c:188: warning: control reaches end of non-void function
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o cleanup_thread.o cleanup_thread.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from cleanup_thread.c:26:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from cleanup_thread.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> cleanup_thread.c: In function `cleanupThread_main':
 >>  >>  >> cleanup_thread.c:222: warning: control reaches end of non-void function
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o scheduler.o scheduler.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from scheduler.c:27:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from scheduler.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> scheduler.c: In function `sched_mainloop':
 >>  >>  >> scheduler.c:697: warning: control reaches end of non-void function
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o dbutils.o dbutils.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from dbutils.c:27:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from dbutils.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS -I/u3/postgre/src/postgresql-7.4/src/include   -c -o misc.o misc.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from misc.c:28:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/sys/types.h:28,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/pthread.h:21,
 >>  >>  >>                  from misc.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -D_POSIX_PTHREAD_SEMANTICS slon.o runtime_config.o local_listen.o remote_listen.o remote_worker.o sync_thread.o cleanup_thread.o scheduler.o dbutils.o misc.o -L/u3/postgre/src/postgresql-7.4/src/port  -R/u3/postgre/pgsql/lib -g -D_REENTRANT -pthreads -R/u3/postgre/pgsql/lib  -L/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -lpq -o slon
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/slon'
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/slonik'
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -DPGSHARE=""/u3/postgre/pgsql/share"" -I/u3/postgre/src/postgresql-7.4/src/include   -c -o slonik.o slonik.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from /u3/postgre/src/postgresql-7.4/src/include/postgres.h:48,
 >>  >>  >>                  from slonik.c:25:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/include/iso/stdio_iso.h:35,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/stdio.h:36,
 >>  >>  >>                  from slonik.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -DPGSHARE=""/u3/postgre/pgsql/share"" -I/u3/postgre/src/postgresql-7.4/src/include   -c -o dbutil.o dbutil.c
 >>  >>  >> In file included from /u3/postgre/src/postgresql-7.4/src/include/c.h:53,
 >>  >>  >>                  from /u3/postgre/src/postgresql-7.4/src/include/postgres.h:48,
 >>  >>  >>                  from dbutil.c:21:
 >>  >>  >> /u3/postgre/src/postgresql-7.4/src/include/pg_config.h:621:1: warning: "_FILE_OFFSET_BITS" redefined
 >>  >>  >> In file included from /usr/include/iso/stdio_iso.h:35,
 >>  >>  >>                  from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/include/stdio.h:36,
 >>  >>  >>                  from dbutil.c:14:
 >>  >>  >> /usr/include/sys/feature_tests.h:96:1: warning: this is the location of the previous definition
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -DPGSHARE=""/u3/postgre/pgsql/share"" -I/u3/postgre/src/postgresql-7.4/src/include   -c -o parser.o parser.c
 >>  >>  >> In file included from parser.y:1790:
 >>  >>  >> scan.c: In function `yylex':
 >>  >>  >> scan.c:841: warning: label `find_rule' defined but not used
 >>  >>  >> parser.y: At top level:
 >>  >>  >> scan.c:2117: warning: `yy_flex_realloc' defined but not used
 >>  >>  >> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -pthreads -I../.. -I/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -DPGSHARE=""/u3/postgre/pgsql/share"" slonik.o dbutil.o parser.o -L/u3/postgre/src/postgresql-7.4/src/port  -R/u3/postgre/pgsql/lib -R/u3/postgre/pgsql/lib -L/u3/postgre/src/postgresql-7.4/src/interfaces/libpq -lpq -o slonik
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/slonik'
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/backend'
 >>  >>  >> /usr/local/bin/gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -I../.. -fPIC -I/u3/postgre/src/postgresql-7.4/src/include   -c -o slony1_funcs.o slony1_funcs.c
 >>  >>  >> /usr/ccs/bin/ld -G -Bdynamic -o slony1_funcs.so slony1_funcs.o
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/backend'
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/ducttape'
 >>  >>  >> make[2]: Nothing to be done for `all'.
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/ducttape'
 >>  >>  >> make[1]: Leaving directory `/u3/postgre/slony1-1.0.5/src'
 >>  >>  >> make[1]: Entering directory `/u3/postgre/slony1-1.0.5/doc'
 >>  >>  >> make[1]: Nothing to be done for `all'.
 >>  >>  >> make[1]: Leaving directory `/u3/postgre/slony1-1.0.5/doc'
 >>  >>  >> All of Slony-I is successfully made. Ready to install
 >>  >>  >> $ make install
 >>  >>  >> for subdir in src doc ; do 
 >>  >>   make -C $subdir install || exit ; 
 >>  >>     done && 
 >>  >> echo "All of Slony-I is successfully installed"
 >>  >>  >> make[1]: Entering directory `/u3/postgre/slony1-1.0.5/src'
 >>  >>  >> for subdir in xxid slon slonik backend ducttape ; do 
 >>  >>   make -C $subdir install ; 
 >>  >>     done
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/xxid'
 >>  >>  >> /bin/sh /u3/postgre/src/postgresql-7.4/config/install-sh -c -m 755 xxid.so /u3/postgre/pgsql/lib
 >>  >>  >> for file in xxid.v73.sql xxid.v74.sql; do 
 >>  >>   /bin/sh /u3/postgre/src/postgresql-7.4/config/install-sh -c -m 755 $file /u3/postgre/pgsql/share || exit ; 
 >>  >> done
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/xxid'
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/slon'
 >>  >>  >> /bin/sh /u3/postgre/src/postgresql-7.4/config/install-sh -c -m 755 slon /u3/postgre/pgsql/bin
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/slon'
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/slonik'
 >>  >>  >> /bin/sh /u3/postgre/src/postgresql-7.4/config/install-sh -c -m 755 slonik /u3/postgre/pgsql/bin
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/slonik'
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/backend'
 >>  >>  >> /bin/sh /u3/postgre/src/postgresql-7.4/config/install-sh -c -m 755 slony1_funcs.so /u3/postgre/pgsql/lib
 >>  >>  >> for file in slony1_base.sql slony1_funcs.sql slony1_base.v73.sql slony1_funcs.v73.sql slony1_base.v74.sql slony1_funcs.v74.sql; do 
 >>  >>   /bin/sh /u3/postgre/src/postgresql-7.4/config/install-sh -c -m 755 $file /u3/postgre/pgsql/share || exit ; 
 >>  >> done
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/backend'
 >>  >>  >> make[2]: Entering directory `/u3/postgre/slony1-1.0.5/src/ducttape'
 >>  >>  >> make[2]: Leaving directory `/u3/postgre/slony1-1.0.5/src/ducttape'
 >>  >>  >> make[1]: Leaving directory `/u3/postgre/slony1-1.0.5/src'
 >>  >>  >> make[1]: Entering directory `/u3/postgre/slony1-1.0.5/doc'
 >>  >>  >> make[1]: Nothing to be done for `install'.
 >>  >>  >> make[1]: Leaving directory `/u3/postgre/slony1-1.0.5/doc'
 >>  >>  >> All of Slony-I is successfully installed
 >>  >>  >> 
 >>  >>  >> now ,I new install postgre db
 >>  >>  >> run ptop.sh
 >>  >>  >> -----script start-----------
 >>  >>  >> #!/bin/sh
 >>  >>  >> 
 >>  >>  >> CLUSTERNAME=test3
 >>  >>  >> MASTERDBNAME=db3
 >>  >>  >> SLAVEDBNAME=db3
 >>  >>  >> MASTERHOST=10.10.11.12
 >>  >>  >> SLAVEHOST=10.10.11.21
 >>  >>  >> REPLICATIONUSER=postgre
 >>  >>  >> PGBENCHUSER=postgre
 >>  >>  >> 
 >>  >>  >> slonik <<_EOF_
 >>  >>  >>     cluster name = $CLUSTERNAME;
 >>  >>  >> 
 >>  >>  >>     node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER';
 >>  >>  >>     node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$PGBENCHUSER';
 >>  >>  >>     
 >>  >>  >>     init cluster ( id = 1, comment = 'Master Node' );
 >>  >>  >> 
 >>  >>  >>     table add key (node id = 1, fully qualified name = 'public.history');
 >>  >>  >> 
 >>  >>  >>     create set ( id = 1, origin = 1, comment = 'All pgbench tables' );
 >>  >>  >> 
 >>  >>  >>     set add table (set id=1 , origin=1 , id=1 , fully qualified name = 'public.accounts' , comment='Table accounts');
 >>  >>  >>     set add table (set id=1 , origin=1 , id=2 , fully qualified name = 'public.branches' , comment='Table branches');
 >>  >>  >>     set add table (set id=1 , origin=1 , id=3 , fully qualified name = 'public.tellers' , comment='Table tellers');
 >>  >>  >>     set add table (set id=1 , origin=1 , id=4 , fully qualified name = 'public.history' , comment='history table' , key = serial);
 >>  >>  >> 
 >>  >>  >>     store node (id=2, comment = 'Slave node');
 >>  >>  >> 
 >>  >>  >>     store path (server = 1, client = 2, conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER');
 >>  >>  >> 
 >>  >>  >>     store path ( server = 2, client = 1, conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$PGBENCHUSER');
 >>  >>  >> 
 >>  >>  >>     store listen ( origin = 1, provider = 1, receiver = 2 );
 >>  >>  >>     store listen ( origin = 2, provider = 2, receiver = 1 );
 >>  >>  >> _EOF_
 >>  >>  >> -----script end-----------
 >>  >>  >> show the same error:
 >>  >>  >> $ ./ptop.sh
 >>  >>  >> NOTICE:  type "_test3.xxid" is not yet defined
 >>  >>  >> DETAIL:  Creating a shell type definition.
 >>  >>  >> NOTICE:  argument type _test3.xxid is only a shell
 >>  >>  >> NOTICE:  type "_test3.xxid_snapshot" is not yet defined
 >>  >>  >> DETAIL:  Creating a shell type definition.
 >>  >>  >> NOTICE:  argument type _test3.xxid_snapshot is only a shell
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_node-pkey" for table "sl_node"
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_set-pkey" for table "sl_set"
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_setsync-pkey" for table "sl_setsync"
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_table-pkey" for table "sl_table"
 >>  >>  >> NOTICE:  CREATE TABLE / UNIQUE will create implicit index "sl_table_tab_reloid_key" for table "sl_table"
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_trigger-pkey" for table "sl_trigger"
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_sequence-pkey" for table "sl_sequence"
 >>  >>  >> NOTICE:  CREATE TABLE / UNIQUE will create implicit index "sl_sequence_seq_reloid_key" for table "sl_sequence"
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_path-pkey" for table "sl_path"
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_listen-pkey" for table "sl_listen"
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_subscribe-pkey" for table "sl_subscribe"
 >>  >>  >> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sl_event-pkey" for table "sl_event"
 >>  >>  >> NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index "history__Slony-I_test3_rowID_key" for table "history"
 >>  >>  >> CONTEXT:  PL/pgSQL function "determineattkindserial" line 52 at execute statement
 >>  >>  >> <stdin>:27: PGRES_FATAL_ERROR load '$libdir/xxid';  - ERROR:  could not access file "$libdir/xxid": No such file or directory
 >>  >>  >> <stdin>:27: Error: the extension for the xxid data type cannot be loaded in database 'dbname=db3 host=10.10.11.21 user=postgre'
 >>  >>  >> 
 >>  >>  >> postgre configure option:
 >>  >>  >> ./configure --prefix=/u3/postgre/pgsql --without-readline --without-zlib --with-pgport=7432
 >>  >>  >> 
 >>  >>  >> os:SunOS5.8
 >>  >>  >> postgre version: 7.4
 >>  >>  >> 
 >>  >>  >> I am eager to wait for your answer.Thank you very much !
 >>  >>  >> 
 >>  >>  >> 
 >>  >>  >> 
 >>  >>  >> ______________________________________
 >>  >>  >> 
 >>  >>  >> ×¢²áÐÂÀËÃâ·ÑÓÊÏ䣬¼¤»î2G¿Õ¼ä£¡£¨ http://mail.sina.com.cn/chooseMode.html £©
 >>  >>  >> 
 >>  >>  >> ===================================================================
 >>  >>  >> Ï¢ÕÇÀû¶à£¬°²Ðľ۲Æ-º£¸»Í¨»õ±ÒÊг¡»ù½ðÔÚ·¢ÐУ¡ (http://ad4.sina.com.cn/wlw/all/zhuiyu.html)
 >>  >>  >
 >>  >>  >
 >>  >>  >-- 
 >>  >>  >#======================================================================#
 >>  >>  ># It's easier to get forgiveness for being wrong than for being right. #
 >>  >>  ># Let's break this rule - forgive me.                                  #
 >>  >>  >#================================================== JanWieck at Yahoo.com #
 >>  >>  >
 >>  >>  >
 >>  >> 
 >>  >> ______________________________________
 >>  >> 
 >>  >> ×¢²áÐÂÀËÃâ·ÑÓÊÏ䣬¼¤»î2G¿Õ¼ä£¡£¨ http://mail.sina.com.cn/chooseMode.html £©
 >>  >> 
 >>  >> ===================================================================
 >>  >> Ï¢ÕÇÀû¶à£¬°²Ðľ۲Æ-º£¸»Í¨»õ±ÒÊг¡»ù½ðÔÚ·¢ÐУ¡ (http://ad4.sina.com.cn/wlw/all/zhuiyu.html)
 >>  >
 >>  >
 >>  >-- 
 >>  >#======================================================================#
 >>  ># It's easier to get forgiveness for being wrong than for being right. #
 >>  ># Let's break this rule - forgive me.                                  #
 >>  >#================================================== JanWieck at Yahoo.com #
 >>  >
 >>  >
 >> 
 >> ______________________________________
 >> 
 >> ×¢²áÐÂÀËÃâ·ÑÓÊÏ䣬¼¤»î2G¿Õ¼ä£¡£¨ http://mail.sina.com.cn/chooseMode.html £©
 >> 
 >> ===================================================================
 >> ÓµÓÐÈ«ÐÂHP Compaq ÉÌÓĄ̃ʽ»ú£¬Ó®³¬ÖµË«ÖغÃÀñ£¡ (http://ad4.sina.com.cn/wx/ads/hpzhuiyu1206.html)
 >
 >
 >-- 
 >#======================================================================#
 ># It's easier to get forgiveness for being wrong than for being right. #
 ># Let's break this rule - forgive me.                                  #
 >#================================================== JanWieck at Yahoo.com #
 >
 >

______________________________________

×¢²áÐÂÀËÃâ·ÑÓÊÏ䣬¼¤»î2G¿Õ¼ä£¡£¨ http://mail.sina.com.cn/chooseMode.html £©

===================================================================
ÓµÓÐÈ«ÐÂHP Compaq ÉÌÓĄ̃ʽ»ú£¬Ó®³¬ÖµË«ÖغÃÀñ£¡ (http://ad4.sina.com.cn/wx/ads/hpzhuiyu1209.html)