<div dir="ltr">Hello Tatsuo Ishii,<div><br></div><div>I was able to start the Standby Database and Successfully Installed pgpoolAdmin. But 'postgres' is showing down and 'Stop', 'Restart', 'Reload' and 'Remove' buttons are disabled.</div><div><br></div><div>pgpool.log and the screen shot is attached with this email.</div><div><br></div><div>-- <br><div class="gmail_signature"><div dir="ltr"><div class="gmail_signature"><div dir="ltr">Best regards,<div>Giles Cornelius Gomes</div><div>Database Administrator</div><div>Impel IT Solutions Ltd.</div><div>Phone: +88 01 714329389 </div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 16 September 2015 at 21:24, Giles Gomes <span dir="ltr"><<a href="mailto:giles.gomes@retailephant.com" target="_blank">giles.gomes@retailephant.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">Hi Tatsuo,<div><br></div><div>Thanks for your response. <span style="color:rgb(80,0,80);font-size:12.8px">install-functions.sh has worked properly after installing </span><font color="#500050"><span style="font-size:12.8px">postgresql-server-dev-9.3.</span></font></div><div><font color="#500050"><span style="font-size:12.8px"><br></span></font></div><div><font color="#500050"><span style="font-size:12.8px">I was also able to run </span></font><span style="font-size:12.8px">basebackup.sh, although "mkdir: cannot create directory ‘/var/lib/postgresql/9.3/main/pg_xlog’: File exists" is showing while running this as following:</span></div><div><span style="font-size:12.8px">-------------------------------------------------------------------------------------------</span></div><div><span style="font-size:12.8px">postgres@osspc17:~/9.3/main$ ./basebackup.sh</span></div><div><span style="font-size:12.8px"> pg_start_backup</span></div><div><span style="font-size:12.8px">-----------------</span></div><div><span style="font-size:12.8px"> 0/1C000028</span></div><div><span style="font-size:12.8px">(1 row)</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">mkdir: cannot create directory ‘/var/lib/postgresql/9.3/main/pg_xlog’: File exists</span></div><div><span style="font-size:12.8px">mytemp23915 100% 153 0.2KB/s 00:00</span></div><div><span style="font-size:12.8px">NOTICE: pg_stop_backup complete, all required WAL segments have been archived</span></div><div><span style="font-size:12.8px"> pg_stop_backup</span></div><div><span style="font-size:12.8px">----------------</span></div><div><span style="font-size:12.8px"> 0/1C0000F0</span></div><div><span style="font-size:12.8px">(1 row)</span></div><div><span style="font-size:12.8px">--------------------------------------------------------------------------------------------</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">After running this script I have restarted the standby database as following:</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">$ service postgresql restart</span><br></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">After restarting the database I am unable to login to database. following error is showing:</span></div><div><span style="font-size:12.8px">--------------------------------------------------------------------------</span></div><div><div><span style="font-size:12.8px">postgres@osspc18:~$ psql</span></div><div><span style="font-size:12.8px">psql: FATAL: the database system is starting up</span></div><div style="font-size:12.8px">--------------------------------------------------------------------------</div></div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">What should I do now?</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">Best regards,</div><div style="font-size:12.8px">Giles.</div><div style="font-size:12.8px"><br></div><div><span style="font-size:12.8px"> </span></div></div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">On 16 September 2015 at 04:59, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span>> Hi Tatsuo,<br>
><br>
> Thanks for your quick response. I was trying to configure replication with<br>
> pgpool II between three VM.<br>
> 1. Pgpool Server. where pgpool-II-3.4.3 is installed .I wish to install<br>
> Pgpool Admin here also.<br>
> 2. Primary Server, where PostgreSQL 9.3.9 is installed.<br>
> 3. Standby Server, where PostgreSQL 9.3.9 is installed.<br>
><br>
> The main problem is I didn't get any complete document where all the<br>
> necessary steps are described. Last time I was following the document below.<br>
><br>
> <a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/" rel="noreferrer" target="_blank">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/</a><br>
><br>
> Here they told to run a script named install-functions.sh<br>
><br>
> But following errors are showing while running it.<br>
> --------------------------------------------------------------------------------------------------------------------<br>
> postgres@osspc16:/home/vagrant$ ./install-functions.sh<br>
> Makefile:19: /usr/lib/postgresql/9.3/lib/pgxs/src/makefiles/<a href="http://pgxs.mk" rel="noreferrer" target="_blank">pgxs.mk</a>: No<br>
> such fil<br>
> e or directory<br>
> make: *** No rule to make target<br>
<br>
</span>Seems like a PostgreSQL RPM installation problem, rather than a<br>
pgpool-II installation problem. Have you installed postgresql-devel<br>
package?<br>
<div><div><br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div></div></div>-- <br><div><div dir="ltr"><div><div dir="ltr"><span class="">Best regards,<div>Giles Cornelius Gomes</div></span><div>Database Administrator</div><div>Impel IT Solutions Ltd.</div><div>Phone: +88 01 714329389 </div></div></div></div></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div class="gmail_signature"><div dir="ltr">Best regards,<div>Giles Cornelius Gomes</div><div>Database Administrator</div><div>Impel IT Solutions Ltd.</div><div>Phone: +88 01 714329389 </div></div></div></div></div>
</div></div>