Fri Dec 3 15:37:04 PST 2004
- Previous message: [Slony1-general] Just stop'd working ...
- Next message: [Slony1-general] large objects
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 #
- Previous message: [Slony1-general] Just stop'd working ...
- Next message: [Slony1-general] large objects
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list