<div dir="ltr"><font face="courier new, monospace">
<p style="font-size:small;margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt">Installed "PostgreSQL 9.1.11" from Source Code as per URL - <a href="http://www.postgresql.org/docs/9.1/interactive/installation.html">http://www.postgresql.org/docs/9.1/interactive/installation.html</a></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><font>After </font>passing<font> all test results in “gmake check", DB is installed and running.</font></p>
<p style="font-size:small;margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"> </span></p>
<p style="font-size:small;margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt">My
next step is to install user defined functions used by pgpool-II. Here
while trying to "install-functions.sh" as per URL – </span><span class=""><a href="http://pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/"><font size="3">http://pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/</font></a></span><span style="font-size:10pt"></span></p>
<p style="font-size:small;margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt">I
am facing path error for "</span><span style="font-size:13px">uninstall_pgpool-recovery.sql"</span></p><p style="font-size:small;margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><br></span></p>
<p style="font-size:small;margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt">My sequences of commands are –</span></p></font><font>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:12pt"><font face="courier new, monospace"> </font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace">[postgres@postgres-s
pgpool-recovery]$ whoami<br>postgres</font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><font face="courier new, monospace"><span style="font-size:10pt"><br>[postgres@postgres-s
pgpool-recovery]$ pwd<br>/tmp/pgpool-II-3.1.1/sql/pgpool-recovery</span><span style="font-size:12pt"></span></font></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace"> </font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><font face="courier new, monospace"><span style="font-size:10pt">[postgres@postgres-s
pgpool-recovery]$ dir<br>Makefile pgpool-recovery.c pgpool-recovery.so
pgpool-recovery.sql <a href="http://pgpool-recovery.sql.in">pgpool-recovery.sql.in</a>
uninstall_pgpool-recovery.sql</span><span style="font-size:12pt"></span></font></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace"> </font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><font face="courier new, monospace"><span style="font-size:10pt">vi
/tmp/pgpool-II-3.1.1/sql/pgpool-recovery/Makefile</span><span style="font-size:12pt"></span></font></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:12pt"><font face="courier new, monospace"> </font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><font face="courier new, monospace"><span style="font-size:10pt">MODULES
= pgpool-recovery<br>DATA_built = pgpool-recovery.sql<br>DATA =
uninstall_pgpool-recovery.sql<br>PG_CONFIG = pg_config # added by me<br>#USE_PGXS = true<br># set
top_builddir to the PostgreSQL build source tree top.<br># (for example
/usr/local/src/postgresql-8.4) <br>top_builddir =
/tmp/postgresql-9.1.11/build_dir # added by me<br>ifdef USE_PGXS<br>PGXS =
$(shell pg_config --pgxs)<br>include $(PGXS)<br>else<br>subdir =
contrib/pgpool-recovery<br>#top_builddir = ../..<br>include
$(top_builddir)/src/Makefile.global<br>include
$(top_srcdir)/contrib/<a href="http://contrib-global.mk">contrib-global.mk</a><br>endif</span><span style="font-size:12pt"> </span></font></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace"><br>[postgres@postgres-s
pgpool-recovery]$ make<br>sed 's,MODULE_PATHNAME,$libdir/pgpool-recovery,g'
<a href="http://pgpool-recovery.sql.in">pgpool-recovery.sql.in</a> >pgpool-recovery.sql<br>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<br>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<br>rm
pgpool-recovery.o</font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:12pt"><font face="courier new, monospace"> </font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace">[postgres@postgres-s
pgpool-recovery]$ make install<br>/bin/mkdir -p
'/usr/local/pgsql/share/contrib'<br>/bin/mkdir -p
'/usr/local/pgsql/lib'<br>/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/'<br>/tmp/postgresql-9.1.11/config/install-sh:
/tmp/postgresql-9.1.11/contrib/pgpool-recovery/uninstall_pgpool-recovery.sql
does not exist.<br>make: *** [install] Error 1</font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace"> </font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace">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”</font></span><span style="font-family:'Times New Roman',serif;font-size:12pt"></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace"><br></font></span></p><p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace">Thanks & regards,</font></span></p>
<p style="margin:0in 0in 0pt" class="MsoNormal"><span style="font-size:10pt"><font face="courier new, monospace">Dave C</font></span></p></font></div>