Hi, I'm running replication server of postgreSQL and I 'm getting this is the error I'm getting when I'm running Replicate master slave
"Undefined subroutine &Pg::connectdb called at ./Replicate line 49." now I got perl modules that needed to be run rserv ,i got it compiled and I make sure that everything runs fine llike when I did make test they run fine,I printed out the out put below this mail. one thing I set the environment variables as this POSTGRES_INCLUDE=/usr/local/pgsql/include POSTGRES_LIB=/usr/local/pgsql/lib LD_LIBRARY_PATH=/usr/local/pgsql/lib export POSTGRES_INCLUDE POSTGRES_LIB LD_LIBRARY_PATH I'm not understanding where I went wrong ,will you pls help me out thx a bunch Sarath. 703-362-8134. -------------------------Versions---------- postgreSQL version ----- 7.1.3 DBI-1.21 DBI version -------1.21DBI-1.21 DBD-Pg-0.95 DBD version ---------0.95 perl versions [root@sky2 DBD-Pg-0.95]# perl -v This is perl, v5.6.0 built for i386-linux Copyright 1987-2000, Larry Wall Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5.0 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using `man perl' or `perldoc perl'. If you have access to the Internet, point your browser at http://www.perl.com/, the Perl Home Page. [root@sky2 DBD-Pg-0.95]# perl -V Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration: Platform: osname=linux, osvers=2.2.17-8smp, archname=i386-linux uname='linux porky.devel.redhat.com 2.2.17-8smp #1 smp fri nov 17 16:12:17 est 2000 i686 unknown ' config_args='-des -Doptimize=-O2 -march=i386 -mcpu=i686 -Dcc=gcc -Dcccdlflags=-fPIC -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux -Dd_dosuid -Dd_semctl_semun -Di_db -Di_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Uuselargefiles' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=undef use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef Compiler: cc='gcc', optimize='-O2 -march=i386 -mcpu=i686', gccversion=2.96 20000731 (Red Hat Linux 7.1 2.96-79) cppflags='-fno-strict-aliasing' ccflags ='-fno-strict-aliasing' stdchar='char', d_stdstdio=define, usevfork=false intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=4 alignbytes=4, usemymalloc=n, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib libs=-lnsl -ldl -lm -lc -lcrypt libc=/lib/libc-2.2.2.so, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic' cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: Built under linux Compiled at Mar 23 2001 12:49:50 @INC: /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl ------------------------make test ----DBI-1.21 [root@sky2 DBI-1.21]# make test cp Changes blib/lib/DBI/Changes.pm PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/basics............ok t/dbidrv............ok t/examp.............ok t/meta..............ok t/preparse..........ok t/proxy.............skipped test on this platform t/shell.............ok t/subclass..........ok All tests successful, 1 test skipped. Files=8, Tests=301, 2 wallclock secs ( 1.54 cusr + 0.05 csys = 1.59 CPU) PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 test.pl test.pl DBI test application $Revision: 11.3 $ Using /usr/lib/perl5/5.6.0/DBI-1.21/blib Switch: DBI 1.21 by Tim Bunce, 1.21 Available Drivers: ExampleP, Pg, Proxy dbi:ExampleP:: testing 5 sets of 20 connections: Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Made 100 connections in 0 wallclock secs ( 0.05 usr + 0.00 sys = 0.05 CPU) Testing handle creation speed... 5000 NullP statement handles cycled in 0.8 cpu+sys seconds (6024 per sec) test.pl done [root@sky2 DBI-1.21]# ----------------------------------make test DBD-Pg-0.95--------------------- root@sky2 DBD-Pg-0.95]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 test.pl OS: linux DBI->data_sources .......... ok DBI->connect ............... ok $dbh->{Name} ............... ok $dbh->ping ................. ok $dbh->do ................... ok $dbh->table_info ........... ok $dbh->tables ............... ok $dbh->pg_table_attributes .. ok $dbh->prepare .............. ok $dbh->execute .............. ok $sth->{pg_oid_status} ...... ok $sth->{pg_cmd_status} ...... ok $sth->finish ............... ok $sth->bind_param ........... ok $sth->fetchrow_array ....... ok $sth->fetchrow_arrayref .... ok $sth->fetchrow_hashref ..... ok $sth->{NAME} ............... ok $sth->{TYPE} ............... ok $sth->{pg_size} ............ ok $sth->{pg_type} ............ ok $sth->bind_columns ......... ok $sth->fetch ................ ok $sth->bind_col ............. ok $sth->fetch ................ ok $sth->{ChopBlanks} ......... ok $sth->rows ................. ok $dbh->func(putline) ........ ok $dbh->func(getline) ........ ok $dbh->func(lo_import) ...... ok $sth->blob_read ............ ok $dbh->func(lo_open) ........ ok $dbh->func(lo_lseek) ....... ok $dbh->func(lo_read) ........ ok $dbh->func(lo_tell) ........ ok $dbh->func(lo_close) ....... ok $dbh->func(lo_unlink) ...... ok compare blobs .............. ok $dbh->disconnect ........... ok test sequence finished. [root@sky2 DBD-Pg-0.95]# -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
