salman salmanb at quietcaresystems.com
Tue Nov 25 09:27:47 PST 2008
Hello,

While attempting to upgrade to 2.0, I'm getting this error when running 
slonik_update_nodes. Can I simply symlink the first .sql (see below) 
file into usr/share to get around this?

I see the file at the following locations:
/usr/src/slony1-2.0.0/src/backend/slony1_funcs.sql (md5: 
5c47555b5e2ae556ed6958a4d5f9bfa2)
/usr/local/postgresql/8.3.1/share/slony1_funcs.sql (md5: 
538bc6f60dda20fcde704a673f89afbe)

pg_config output is as follows:
BINDIR = /usr/local/postgresql/8.3.1/bin
DOCDIR = /usr/local/postgresql/8.3.1/doc
INCLUDEDIR = /usr/local/postgresql/8.3.1/include
PKGINCLUDEDIR = /usr/local/postgresql/8.3.1/include
INCLUDEDIR-SERVER = /usr/local/postgresql/8.3.1/include/server
LIBDIR = /usr/local/postgresql/8.3.1/lib
PKGLIBDIR = /usr/local/postgresql/8.3.1/lib
LOCALEDIR =
MANDIR = /usr/local/postgresql/8.3.1/man
SHAREDIR = /usr/local/postgresql/8.3.1/share
SYSCONFDIR = /usr/local/postgresql/8.3.1/etc
PGXS = /usr/local/postgresql/8.3.1/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr/local/postgresql/8.3.1' '--with-python' 
'--with-perl' '--enable-thread-safety' '--enable-depend' '--with-openssl'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline 
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-rpath,'/usr/local/postgresql/8.3.1/lib'
LDFLAGS_SL =
LIBS = -lpgport -lssl -lcrypto -lz -lreadline -ltermcap -lcrypt -ldl -lm
VERSION = PostgreSQL 8.3.1

slony config string:
./configure --prefix=/usr --sysconfdir=/etc/slony --with-perltools 
--with-pgconfigdir=/usr/local/postgresql/current/bin/

-salman


More information about the Slony1-general mailing list