Sun.betty alanxzq
Thu Jul 28 09:05:55 PDT 2005
Ian Burrell :
           How are you!
     Thanks for your answer at first !
     after much more practice ! 
     at command line :
use :
cvs -d:pserver:anonymous at gborg.postgresql.org:/usr/local/cvsroot/slony1 co slony1-engine
 
I download SlonyI patch success !
I new install a PostgreSQL database and new install a slonyI 1.1.0
then download slonyI CVS patch , configure is success
but make error :
 
In file included from /u2/slave/pgsql/include/server/c.h:53,
                 from misc.c:33:
/u2/slave/pgsql/include/server/pg_config.h:624:1: warning: "_FILE_OFFSET_BITS" redefined
In file included from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3/include/sys/types.h:28,
                 from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3/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 -g -O2 -D_REENTRANT -pthreads -I../.. -I../../src/slon -I/u2/slave/pgsql/include -o slon slon.o runtime_config.o local_listen.o remote_listen.o remote_worker.o sync_thread.o cleanup_thread.o scheduler.o dbutils.o conf-file.o confoptions.o misc.o -D_REENTRANT -pthreads -L/u2/slave/pgsql/lib -L/u2/slave/pgsql/lib -lpq -R/u2/slave/pgsql/lib  -L/u2/slave/pgsql/lib -lpq
Undefined                       first referenced
 symbol                             in file
piperead                            scheduler.o
pipewrite                           slon.o
pgpipe                              slon.o
ld: fatal: Symbol referencing errors. No output written to slon
collect2: ld returned 1 exit status
make[2]: *** [slon] Error 1
make[2]: Leaving directory `/u2/slave/slony1-engine/src/slon'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/u2/slave/slony1-engine/src'
make: *** [all] Error 2
 
after exec : crle -l /lib -l /usr/lib -l /usr/local/lib  -l /u2/slave/pgsql/lib
the make command exec report as the same error still .
 
compile info :
$ ./configure --with-pgconfigdir=/u2/slave/pgsql/bin --with-pgbindir=/u2/slave/pgsql/bin --with-pgincludedir=/u2/slave/pgsql/inclu
de --with-pgincludeserverdir=/u2/slave/pgsql/include/server --with-pglibdir=/u2/slave/pgsql/lib --with-pgpkglibdir=/u2/slave/pgsql/l
ib --with-pgsharedir=/u2/slave/pgsql/share --bindir=/u2/slave/pgsql/bin --datadir=/u2/slave/pgsql/share --libdir=/u2/slave/pgsql/lib
 --sysconfdir=/u2/slave/pgsql/etc --with-perltools=/u2/slave/pgsql/admin/bin --with-docs
## --------- ##
## Platform. ##
## --------- ##
hostname = testdb
uname -m = sun4u
uname -r = 5.8
uname -s = SunOS
uname -v = Generic_117350-06
/usr/bin/uname -p = sparc
/bin/uname -X     = System = SunOS
Node = testdb
Release = 5.8
KernelID = Generic_117350-06
Machine = sun4u
BusType = <unknown>
Serial = <unknown>
Users = <unknown>
OEM# = 0
Origin# = 1
NumCPU = 6
/bin/arch              = sun4
/usr/bin/arch -k       = sun4u
/usr/convex/getsysinfo = unknown
hostinfo               = unknown
/bin/machine           = unknown
/usr/bin/oslevel       = unknown
/bin/universe          = unknown
PATH: /u2/slave/pgsql/bin
PATH: /usr/bin
PATH: /u2/slave/pgsql/bin
PATH: /usr/bin
PATH: /usr/java1.4
PATH: /usr/ccs/bin
PATH: /usr/local/bin
PATH: /usr/bin
PATH: /usr/ucb
PATH: /etc
PATH: /usr/ccs/bin
PATH: .
PATH: /u3/ldap/openldap/bin
PATH: /u3/ldap/BerkeleyDB4.2.52/bin
PATH: /u3/ldap/openldap/sbin
PATH: /u3/ldap/openldap/libexec
PATH: /usr/local/bin
PATH: .
PATH: /usr/local/bin
PATH: .
 
I beg your pardon for  hinder you , but I am really don't know how to resolve it !if you have free time , Please give me some prompt or advise. Thanks very much ! 
 
Best regard!


Ian Burrell <ianburrell at gmail.com> ???
On 7/24/05, Sun.betty wrote:
> 
> 
> Hello! 
> 
> All "prawn" for SlonyI of Steady improvement. 
> 
> at first! Thanks very much for help all along. I have a very importance
> question! 
> 
> Haven't anybody befell about chinese handled question?
> and I test find when the encoding is "UNICODE" ! the sync of english and
> chinese no problem!
> but for encoding is "EUC_CN" the sync of english is correct !but for chinese
> is sync not happen!
> if you know !Please help me! now my product system use slonyI do sync.
> encoding not allow to change.
> really no way to resolve? 
> 

I found a bug in the slon triggers which truncated strings with
multibyte characters. This was with UTF-8 (UNICODE encoding) but I
bet it affects EUC_CN. The patch was committed to CVS. You might try
building slony from CVS and see if that fixes the problem.

- Ian

		
---------------------------------
DO YOU YAHOO!?
  ????G??????????????????? 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050728/7875f49d/attachment-0001.html


More information about the Slony1-general mailing list