[pgpool-general: 2368] PgPool - install-functions.sh - Error

[Dave Chetan]

Installed "PostgreSQL 9.1.11" from Source Code as per URL -
http://www.postgresql.org/docs/9.1/interactive/installation.html

After passing all test results in “gmake check", DB is installed and
running.



My next step is to install user defined functions used by pgpool-II. Here
while trying to "install-functions.sh" as per URL –
http://pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/

I am facing path error for "uninstall_pgpool-recovery.sql"


My sequences of commands are –



[postgres at postgres-s pgpool-recovery]$ whoami
postgres


[postgres at postgres-s pgpool-recovery]$ pwd
/tmp/pgpool-II-3.1.1/sql/pgpool-recovery



[postgres at postgres-s pgpool-recovery]$ dir
Makefile  pgpool-recovery.c  pgpool-recovery.so  pgpool-recovery.sql
pgpool-recovery.sql.in  uninstall_pgpool-recovery.sql



vi /tmp/pgpool-II-3.1.1/sql/pgpool-recovery/Makefile



MODULES = pgpool-recovery
DATA_built = pgpool-recovery.sql
DATA = uninstall_pgpool-recovery.sql
PG_CONFIG = pg_config  # added by me
#USE_PGXS = true
# set top_builddir to the PostgreSQL build source tree top.
# (for example /usr/local/src/postgresql-8.4)
top_builddir = /tmp/postgresql-9.1.11/build_dir # added by me
ifdef USE_PGXS
PGXS = $(shell pg_config --pgxs)
include $(PGXS)
else
subdir = contrib/pgpool-recovery
#top_builddir = ../..
include $(top_builddir)/src/Makefile.global
include $(top_srcdir)/contrib/contrib-global.mk
endif


[postgres at postgres-s pgpool-recovery]$ make
sed 's,MODULE_PATHNAME,$libdir/pgpool-recovery,g'
pgpool-recovery.sql.in>pgpool-recovery.sql
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wformat-security
-fno-strict-aliasing -fwrapv -fpic -I.
-I/tmp/postgresql-9.1.11/contrib/pgpool-recovery
-I/tmp/postgresql-9.1.11/build_dir/src/include
-I/tmp/postgresql-9.1.11/src/include -D_GNU_SOURCE   -c -o
pgpool-recovery.o pgpool-recovery.c
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wformat-security
-fno-strict-aliasing -fwrapv -fpic
-L/tmp/postgresql-9.1.11/build_dir/src/port -Wl,--as-needed
-Wl,-rpath,'/usr/local/pgsql/lib',--enable-new-dtags  -shared -o
pgpool-recovery.so pgpool-recovery.o
rm pgpool-recovery.o



[postgres at postgres-s pgpool-recovery]$ make install
/bin/mkdir -p '/usr/local/pgsql/share/contrib'
/bin/mkdir -p '/usr/local/pgsql/lib'
/bin/sh /tmp/postgresql-9.1.11/config/install-sh -c -m 644
/tmp/postgresql-9.1.11/contrib/pgpool-recovery/uninstall_pgpool-recovery.sql
pgpool-recovery.sql '/usr/local/pgsql/share/contrib/'
/tmp/postgresql-9.1.11/config/install-sh:
/tmp/postgresql-9.1.11/contrib/pgpool-recovery/uninstall_pgpool-recovery.sql
does not exist.
make: *** [install] Error 1



Please let me know where to set path for “uninstall_pgpool-recovery.sql”
cause this file already exists in “/tmp/pgpool-II-3.1.1/sql/pgpool-recovery”


Thanks & regards,

Dave C
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140102/520f142c/attachment.html>