<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have issues for creating regclass and also <span style="color:#1F497D">
pgpool-recovery</span>.<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Pgpool is installed only on our master server. I am trying the create a regclass functions used internally by pgpool-II, I don’t see any proper solutions in your community.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Can you please show us some light on this issue.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$ cd pgpool-II-x.x.x/sql/pgpool-regclass<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$ make<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$ make install<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">After this:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$ psql -f pgpool-regclass.sql template1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">or<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$ psql template1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">=# CREATE EXTENSION pgpool_regclass;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Executing pgpool-regclass.sql or CREATE EXTENSION should be performed on every databases accessed with pgpool-II. You do not need to do this for a database created after the execution of "psql -f pgpool-regclass.sql
template1" or CREATE EXTENSION, as this template database will be cloned to create new databases.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">bash-4.1$ psql -f pgpool_regclass--1.0.sql template1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Use "CREATE EXTENSION pgpool_regclass" to load this file.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">bash-4.1$ psql<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">psql (8.4.20, server 9.4.4)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">WARNING: psql version 8.4, server version 9.4.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> Some psql features might not work.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Type "help" for help.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">postgres=# \q<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">bash-4.1$ psql -template1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">psql: invalid option -- 'm'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Try "psql --help" for more information.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">bash-4.1$ psql -d template1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">psql (8.4.20, server 9.4.4)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">WARNING: psql version 8.4, server version 9.4.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> Some psql features might not work.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Type "help" for help.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">template1=# CREATE EXTENSION pgpool_regclass;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">ERROR: could not access file "$libdir/pgpool-regclass": No such file or directory<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">template1=# pwd<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">template1-#<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I have same issue for installating pgpool_recovery same errors<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">mnt/gpfs/stage/disk/postgres/pgpool/pgpool-II-3.3.3/sql<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">[sas@aoaapld00103 sql]$ cd pgpool-recovery<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">[sas@aoaapld00103 pgpool-recovery]$ ls -lrt<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">total 64<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">-rwxr-xr-x. 1 postgres postgres 136 Mar 24 2014 uninstall_pgpool-recovery.sql<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">-rwxr-xr-x. 1 postgres postgres 527 Mar 24 2014 pgpool-recovery.sql.in<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">-rwxr-xr-x. 1 postgres postgres 160 Mar 24 2014 pgpool_recovery.control<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">-rwxr-xr-x. 1 postgres postgres 8149 Mar 24 2014 pgpool-recovery.c<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">-rwxr-xr-x. 1 postgres postgres 791 Mar 24 2014 pgpool_recovery--1.0.sql<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">-rwxr-xr-x. 1 postgres postgres 680 Mar 24 2014 Makefile<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">-rwxr-xr-x. 1 postgres postgres 35814 Oct 29 16:01 pgpool-recovery.so<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">-rwxr-xr-x. 1 postgres postgres 594 Oct 29 16:15 pgpool-recovery.sql<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">[sas@aoaapld00103 pgpool-recovery]$ pwd<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">/mnt/gpfs/stage/disk/postgres/pgpool/pgpool-II-3.3.3/sql/pgpool-recovery<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">[sas@aoaapld00103 pgpool-recovery]$ sudo su postgres<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">[sudo] password for sas:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">bash-4.1$ psql -f pgpool-recovery.sql template1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">psql:pgpool-recovery.sql:4: ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">psql:pgpool-recovery.sql:9: ERROR: syntax error at or near "public"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">LINE 3: AS '$libdir/pgpool-recovery', public.'pgpool_remote_start'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> ^<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">psql:pgpool-recovery.sql:14: ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">psql:pgpool-recovery.sql:19: ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">bash-4.1$<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">All the libraries are there under /usr/pgsql-9.4/lib<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">[sas@aoaapld00103 lib<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Your help is much appreciated.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>