<div dir="ltr">Hi Tatsuo,<div><br></div><div>Thanks for your quick response. I was trying to configure replication with pgpool II between three VM. </div><div>1. Pgpool Server. where pgpool-II-3.4.3 is installed .I wish to install Pgpool Admin here also. </div><div>2. Primary Server, where PostgreSQL 9.3.9 is installed.</div><div>3. Standby Server, where PostgreSQL 9.3.9 is installed.</div><div><br></div><div>The main problem is I didn't get any complete document where all the necessary steps are described. Last time I was following the document below.</div><div><br></div><div><a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/</a><br></div><div><br></div><div>Here they told to run a script named install-functions.sh<br></div><div><br></div><div>But following errors are showing while running it.</div><div>--------------------------------------------------------------------------------------------------------------------</div><div><div>postgres@osspc16:/home/vagrant$ ./install-functions.sh</div><div>Makefile:19: /usr/lib/postgresql/9.3/lib/pgxs/src/makefiles/<a href="http://pgxs.mk">pgxs.mk</a>: No such fil e or directory</div><div>make: *** No rule to make target `/usr/lib/postgresql/9.3/lib/pgxs/src/makefiles /<a href="http://pgxs.mk">pgxs.mk</a>'. Stop.</div><div>Makefile:19: /usr/lib/postgresql/9.3/lib/pgxs/src/makefiles/<a href="http://pgxs.mk">pgxs.mk</a>: No such fil e or directory</div><div>make: *** No rule to make target `/usr/lib/postgresql/9.3/lib/pgxs/src/makefiles /<a href="http://pgxs.mk">pgxs.mk</a>'. Stop.</div><div>Password:</div><div>pgpool-recovery.sql: No such file or directory</div><div>Password:</div><div>pgpool-recovery.sql: No such file or directory</div><div>Makefile:19: /usr/lib/postgresql/9.3/lib/pgxs/src/makefiles/<a href="http://pgxs.mk">pgxs.mk</a>: No such fil e or directory</div><div>make: *** No rule to make target `/usr/lib/postgresql/9.3/lib/pgxs/src/makefiles /<a href="http://pgxs.mk">pgxs.mk</a>'. Stop.</div><div>Makefile:19: /usr/lib/postgresql/9.3/lib/pgxs/src/makefiles/<a href="http://pgxs.mk">pgxs.mk</a>: No such fil e or directory</div><div>make: *** No rule to make target `/usr/lib/postgresql/9.3/lib/pgxs/src/makefiles /<a href="http://pgxs.mk">pgxs.mk</a>'. Stop.</div><div>Password:</div><div>pgpool-regclass.sql: No such file or directory</div><div>Password:</div><div>pgpool-regclass.sql: No such file or directory</div></div><div><br></div><div>----------------------------------------------------------------------------------------</div><div><br></div><div>They have told to run a script named <a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/basebackup.sh" style="font-family:'Times New Roman';font-size:medium">basebackup.sh</a><span style="color:rgb(0,0,0);font-family:'Times New Roman';font-size:medium"> </span></div><div><span style="color:rgb(0,0,0);font-family:'Times New Roman';font-size:medium"><br></span></div>But following errors are showing.<div>---------------------------------------------------------------------------------------------------------------------------------------</div><div><div>postgres@osspc17:/home/vagrant$ ./basebackup.sh</div><div> pg_start_backup</div><div>-----------------</div><div> 0/A000028</div><div>(1 row)</div><div><br></div><div>ssh: Could not resolve hostname : No address associated with hostname</div><div>rsync: connection unexpectedly closed (0 bytes received so far) [sender]</div><div>rsync error: error in rsync protocol data stream (code 12) at io.c(226) [sender=3.1.0]</div><div>ssh: Could not resolve hostname mkdir: Name or service not known</div><div>ssh: Could not resolve hostname chmod: Name or service not known</div><div>ssh: Could not resolve hostname rm: Name or service not known</div><div>cp: cannot create regular file ‘:/recovery.conf’: No such file or directory</div><div>NOTICE: WAL archiving is not enabled; you must ensure that all required WAL segments are copied through other means to complete the backup</div><div> pg_stop_backup</div><div>----------------</div><div> 0/A0000F0</div><div>(1 row)</div><div>---------------------------------------------------------------------------------------------------------------------------------------</div><div><br></div><div>I have tried both host name and IP address at "master_node_host_name" parameter but it is not working.</div><div><br></div><div><br></div><div>So, Information you wanted:</div><div><br></div><div><span style="font-size:12.8px">- pgpool-II log</span></div><div>Has been attached with this email.<br style="font-size:12.8px"><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">- pgpool-II version</span></div><div>pgpool-II-3.4.3 </div><div><br><span style="font-size:12.8px">- pgpool.conf</span></div><div>Has been attached with this email.<br style="font-size:12.8px"><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">- PostgreSQL version</span></div><div> PostgreSQL 9.3.9</div><div><br><span style="font-size:12.8px">- PostgreSQL log</span></div><div>Has been attached with this email from both primary and standby server. <br></div><div><br></div><div>I am trying to configure this on Ubuntu 14.04.2 LTS.</div><div><br></div><div>Best regards,</div><div>Giles Cornelius Gomes</div><div>DBA</div><div>Impel IT Solutions Ltd.</div><div><span style="color:rgb(0,0,0);font-family:'Times New Roman';font-size:medium"><br></span></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 11 September 2015 at 06:16, 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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">> I have been trying to configure replication with pgpool since last few<br>
> days. But, it is not working. Please help me.<br>
<br>
</span>Please provide details:<br>
<br>
- define precisely "not working"<br>
- pgpool-II log<br>
- pgpool-II version<br>
- pgpool.conf<br>
- PostgreSQL version<br>
- PostgreSQL log<br>
<br>
Without those, it's very hard to solve your problem.<br>
<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>
</blockquote></div><br></div>