<div dir="ltr">Hi Sébastien,<div><br></div><div>Thanks for your response. I have already solved the permission related errors. If you see the log at following times there is no permission related errors.</div><div> <br><div>17284 2015-10-01 12:24:18 UTC</div><div>15512 2015-10-01 12:01:23 UTC</div></div><div><br></div><div>But still <span style="font-size:12.8px">Error Code: e1012, Error Message: pcp_recovery_node is showing when I press the button "Recovery" from pgpoolAdmin.</span><br></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Best regards,</span></div><div><span style="font-size:12.8px">Giles.</span></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 1 October 2015 at 21:25, Sébastien Ruiz <span dir="ltr"><<a href="mailto:sruiz@cyres.fr" target="_blank">sruiz@cyres.fr</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div style="direction:ltr;font-family:Tahoma;color:#000000;font-size:10pt">Hi,<br>
<br>
The problem looks like a problem of ssh permissions :<br>
.....<br>
Permission denied, please try again.<br>
Permission denied, please try again.<br>
Permission denied (publickey,password).<span class=""><br>
rsync: connection unexpectedly closed (0 bytes received so far) [sender]<br>
rsync error: error in rsync protocol data stream (code 12) at io.c(226) [sender=3.1.0]<br></span>
Permission denied, please try again.<br>
Permission denied, please try again.<br>
Permission denied (publickey,password).<br>
Permission denied, please try again.<br>
....<br>
when your script do :<br>
rsync -C -a -c --delete --exclude postgresql.conf --exclude postmaster.pid \<br>
--exclude postmaster.opts --exclude pg_log \<br>
--exclude recovery.conf --exclude recovery.done \<br>
--exclude pg_xlog \<br>
$master_db_cluster/ $recovery_node_host_name:$recovery_db_cluster<br>
<br>
ssh -T $recovery_node_host_name mkdir $recovery_db_cluster/pg_xlog<br>
ssh -T $recovery_node_host_name chmod 700 $recovery_db_cluster/pg_xlog<br>
ssh -T $recovery_node_host_name rm -f $recovery_db_cluster/recovery.done<br>
...<br>
<br>
<br>
<div><br>
<div style="font-family:Tahoma;font-size:13px">
<div><span style="font-size:11pt;color:black;font-family:'Calibri','sans-serif'">Sébastien RUIZ</span><font size="2" face="Tahoma">
<p class="MsoNormal" style="margin:0cm 0cm 0pt"><span style="font-size:11pt;color:black;font-family:'Calibri','sans-serif'"></span> </p>
<p class="MsoNormal" style="margin:0cm 0cm 0pt"><span style="font-size:11pt;color:rgb(31,73,125);font-family:'Calibri','sans-serif'"><a href="mailto:sruiz@cyres.fr" target="_blank">sruiz@cyres.fr</a></span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0pt"><b><span style="font-size:11pt;color:black;font-family:'Calibri','sans-serif'"></span></b> </p>
</font><span style="font-size:9pt;color:black"><font size="2"><span style="font-family:Tahoma">19-21, rue Edouard Vaillant</span></font></span>
<p class="MsoNormal" style="font-family:Tahoma"><font size="1"><span style="font-size:9pt;color:black"> 37000 TOURS</span></font></p>
<p class="MsoNormal" style="font-family:Tahoma"><font size="1"><span style="font-size:9pt;color:black"> <b>Tel. 02 47 68 48 50
</b></span></font></p>
<font style="font-family:Tahoma" size="1" face="Tahoma">
<p class="MsoNormal" style="margin:0cm 0cm 0pt"><span style="font-size:9pt;color:black"> Fax 02 47 68 48 59</span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0pt"><span style="font-size:9pt;color:black"> </span><span style="font-size:11pt;color:black"><a href="https://webmail.cyres.fr/owa/redir.aspx?C=31b27a98b7ff4ccd81730d3d796c3b01&URL=http%3a%2f%2fwww.cyres.fr%2f" target="_blank"><span style="font-size:9pt;color:black">www.cyres.fr</span></a></span></p>
</font></div>
</div>
</div>
<div style="font-family:Times New Roman;color:#000000;font-size:16px">
<hr>
<div style="direction:ltr"><font color="#000000" size="2" face="Tahoma"><b>De :</b> <a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.net</a> [<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.net</a>] de la part de Giles Gomes [<a href="mailto:giles.gomes@retailephant.com" target="_blank">giles.gomes@retailephant.com</a>]<br>
<b>Envoyé :</b> mercredi 30 septembre 2015 14:59<br>
<b>À :</b> Tatsuo Ishii<br>
<b>Cc :</b> Frank van Doorn; <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<b>Objet :</b> [pgpool-general: 4079] Re: Unable to configure replication with pgpool.<br>
</font><br>
</div><div><div class="h5">
<div></div>
<div>
<div dir="ltr"><span style="font-size:12.8px">Hi Tatsuo,</span>
<div style="font-size:12.8px"><br>
</div>
<div style="font-size:12.8px">The pgpool log, <span style="font-size:12.8px">master (primary) PostgreSQL's log and basebackup,sh have been attached with this email.</span></div>
<div style="font-size:12.8px"><span style="font-size:12.8px"><br>
</span></div>
<div style="font-size:12.8px"><span style="font-size:12.8px">Best regards,</span></div>
<div style="font-size:12.8px"><span style="font-size:12.8px">Giles.</span></div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 28 September 2015 at 16:50, 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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi Tatsuo,
<div><br>
</div>
<div>The pgpool log, <span style="font-size:12.8px">master (primary) PostgreSQL's log and basebackup,sh have been attached with this email.</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px">Best regards,</span></div>
<div><span style="font-size:12.8px">Giles.</span></div>
</div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 27 September 2015 at 11:06, 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">
pcp_recovery_node command failed for some reason. Unfortunately the<br>
error code emitted by pgpoolAdmin is not very helpful. pgpool log and<br>
master (primary) PostgreSQL's log when the command ran will be<br>
more helpful.<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>
<br>
> Hi, how are you??<br>
> A query, you could solve this problem you had ??<br>
> I have the same error connection error pgpooladmin<br>
><br>
><br>
> 2015-09-20 11:29 GMT-03:00 Giles Gomes <<a href="mailto:giles.gomes@retailephant.com" target="_blank">giles.gomes@retailephant.com</a>>:<br>
><br>
>> Hello Tatsuo Ishii,<br>
>><br>
>> After enabling health check parameters 'postgres' is showing up now. But<br>
>> when I click on Recovery an error is generating.<br>
>> Error Code: e1012, Error Message: pcp_recovery_node command error occurred and<br>
>> 'Stop', 'Restart', 'Reload' and 'Remove' buttons are still disabled.<br>
>><br>
>> I have attached the screen shots and waiting for your help.<br>
>><br>
>> Best regards,<br>
>> Giles.<br>
>><br>
>><br>
>> On 17 September 2015 at 19:52, Giles Gomes <<a href="mailto:giles.gomes@retailephant.com" target="_blank">giles.gomes@retailephant.com</a>><br>
>> wrote:<br>
>><br>
>>> Hello Tatsuo Ishii,<br>
>>><br>
>>> I was able to start the Standby Database and Successfully Installed<br>
>>> pgpoolAdmin. But 'postgres' is showing down and 'Stop', 'Restart', 'Reload'<br>
>>> and 'Remove' buttons are disabled.<br>
>>><br>
>>> pgpool.log and the screen shot is attached with this email.<br>
>>><br>
>>> --<br>
>>> Best regards,<br>
>>> Giles Cornelius Gomes<br>
>>> Database Administrator<br>
>>> Impel IT Solutions Ltd.<br>
>>> Phone: <a href="tel:%2B88%2001%20714329389" value="+8801714329389" target="_blank">
+88 01 714329389</a><br>
>>><br>
>>> On 16 September 2015 at 21:24, Giles Gomes <<a href="mailto:giles.gomes@retailephant.com" target="_blank">giles.gomes@retailephant.com</a>><br>
>>> wrote:<br>
>>><br>
>>>> Hi Tatsuo,<br>
>>>><br>
>>>> Thanks for your response. install-functions.sh has worked properly<br>
>>>> after installing postgresql-server-dev-9.3.<br>
>>>><br>
>>>> I was also able to run basebackup.sh, although "mkdir: cannot create<br>
>>>> directory ‘/var/lib/postgresql/9.3/main/pg_xlog’: File exists" is showing<br>
>>>> while running this as following:<br>
>>>><br>
>>>> -------------------------------------------------------------------------------------------<br>
>>>> postgres@osspc17:~/9.3/main$ ./basebackup.sh<br>
>>>> pg_start_backup<br>
>>>> -----------------<br>
>>>> 0/1C000028<br>
>>>> (1 row)<br>
>>>><br>
>>>> mkdir: cannot create directory ‘/var/lib/postgresql/9.3/main/pg_xlog’:<br>
>>>> File exists<br>
>>>> mytemp23915<br>
>>>> 100% 153<br>
>>>> 0.2KB/s 00:00<br>
>>>> NOTICE: pg_stop_backup complete, all required WAL segments have been<br>
>>>> archived<br>
>>>> pg_stop_backup<br>
>>>> ----------------<br>
>>>> 0/1C0000F0<br>
>>>> (1 row)<br>
>>>><br>
>>>> --------------------------------------------------------------------------------------------<br>
>>>><br>
>>>> After running this script I have restarted the standby database as<br>
>>>> following:<br>
>>>><br>
>>>> $ service postgresql restart<br>
>>>><br>
>>>> After restarting the database I am unable to login to database.<br>
>>>> following error is showing:<br>
>>>><br>
>>>> --------------------------------------------------------------------------<br>
>>>> postgres@osspc18:~$ psql<br>
>>>> psql: FATAL: the database system is starting up<br>
>>>><br>
>>>> --------------------------------------------------------------------------<br>
>>>><br>
>>>> What should I do now?<br>
>>>><br>
>>>> Best regards,<br>
>>>> Giles.<br>
>>>><br>
>>>><br>
>>>><br>
>>>> On 16 September 2015 at 04:59, Tatsuo Ishii <<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>><br>
>>>> wrote:<br>
>>>><br>
>>>>> > Hi Tatsuo,<br>
>>>>> ><br>
>>>>> > Thanks for your quick response. I was trying to configure replication<br>
>>>>> with<br>
>>>>> > pgpool II between three VM.<br>
>>>>> > 1. Pgpool Server. where pgpool-II-3.4.3 is installed .I wish to<br>
>>>>> 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<br>
>>>>> 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>
>>>>> --------------------------------------------------------------------------------------------------------------------<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>:<br>
>>>>> No<br>
>>>>> > such fil<br>
>>>>> > e or directory<br>
>>>>> > make: *** No rule to make target<br>
>>>>><br>
>>>>> Seems like a PostgreSQL RPM installation problem, rather than a<br>
>>>>> pgpool-II installation problem. Have you installed postgresql-devel<br>
>>>>> package?<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>
>>>>><br>
>>>><br>
>>>><br>
>>>><br>
>>>> --<br>
>>>> Best regards,<br>
>>>> Giles Cornelius Gomes<br>
>>>> Database Administrator<br>
>>>> Impel IT Solutions Ltd.<br>
>>>> Phone: <a href="tel:%2B88%2001%20714329389" value="+8801714329389" target="_blank">
+88 01 714329389</a><br>
>>>><br>
>>><br>
>>><br>
>>><br>
>>> --<br>
>>> Best regards,<br>
>>> Giles Cornelius Gomes<br>
>>> Database Administrator<br>
>>> Impel IT Solutions Ltd.<br>
>>> Phone: <a href="tel:%2B88%2001%20714329389" value="+8801714329389" target="_blank">
+88 01 714329389</a><br>
>>><br>
>><br>
>><br>
>><br>
>> --<br>
>> Best regards,<br>
>> Giles Cornelius Gomes<br>
>> Database Administrator<br>
>> Impel IT Solutions Ltd.<br>
>> Phone: <a href="tel:%2B88%2001%20714329389" value="+8801714329389" target="_blank">
+88 01 714329389</a><br>
>><br>
>> _______________________________________________<br>
>> pgpool-general mailing list<br>
>> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">
http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>><br>
>><br>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div>
<div dir="ltr">
<div>
<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>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div>
<div dir="ltr">
<div>
<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>
</div></div></div>
</div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><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>