[pgpool-general: 4080] Re: Unable to configure replication with pgpool.
Sébastien Ruiz
sruiz at cyres.fr
Fri Oct 2 00:25:39 JST 2015
Hi,
The problem looks like a problem of ssh permissions :
.....
Permission denied, please try again.
Permission denied, please try again.
Permission denied (publickey,password).
rsync: connection unexpectedly closed (0 bytes received so far) [sender]
rsync error: error in rsync protocol data stream (code 12) at io.c(226) [sender=3.1.0]
Permission denied, please try again.
Permission denied, please try again.
Permission denied (publickey,password).
Permission denied, please try again.
....
when your script do :
rsync -C -a -c --delete --exclude postgresql.conf --exclude postmaster.pid \
--exclude postmaster.opts --exclude pg_log \
--exclude recovery.conf --exclude recovery.done \
--exclude pg_xlog \
$master_db_cluster/ $recovery_node_host_name:$recovery_db_cluster
ssh -T $recovery_node_host_name mkdir $recovery_db_cluster/pg_xlog
ssh -T $recovery_node_host_name chmod 700 $recovery_db_cluster/pg_xlog
ssh -T $recovery_node_host_name rm -f $recovery_db_cluster/recovery.done
...
Sébastien RUIZ
sruiz at cyres.fr<mailto:sruiz at cyres.fr>
19-21, rue Edouard Vaillant
37000 TOURS
Tel. 02 47 68 48 50
Fax 02 47 68 48 59
www.cyres.fr<https://webmail.cyres.fr/owa/redir.aspx?C=31b27a98b7ff4ccd81730d3d796c3b01&URL=http%3a%2f%2fwww.cyres.fr%2f>
________________________________
De : pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] de la part de Giles Gomes [giles.gomes at retailephant.com]
Envoyé : mercredi 30 septembre 2015 14:59
À : Tatsuo Ishii
Cc : Frank van Doorn; pgpool-general at pgpool.net
Objet : [pgpool-general: 4079] Re: Unable to configure replication with pgpool.
Hi Tatsuo,
The pgpool log, master (primary) PostgreSQL's log and basebackup,sh have been attached with this email.
Best regards,
Giles.
On 28 September 2015 at 16:50, Giles Gomes <giles.gomes at retailephant.com<mailto:giles.gomes at retailephant.com>> wrote:
Hi Tatsuo,
The pgpool log, master (primary) PostgreSQL's log and basebackup,sh have been attached with this email.
Best regards,
Giles.
On 27 September 2015 at 11:06, Tatsuo Ishii <ishii at postgresql.org<mailto:ishii at postgresql.org>> wrote:
pcp_recovery_node command failed for some reason. Unfortunately the
error code emitted by pgpoolAdmin is not very helpful. pgpool log and
master (primary) PostgreSQL's log when the command ran will be
more helpful.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Hi, how are you??
> A query, you could solve this problem you had ??
> I have the same error connection error pgpooladmin
>
>
> 2015-09-20 11:29 GMT-03:00 Giles Gomes <giles.gomes at retailephant.com<mailto:giles.gomes at retailephant.com>>:
>
>> Hello Tatsuo Ishii,
>>
>> After enabling health check parameters 'postgres' is showing up now. But
>> when I click on Recovery an error is generating.
>> Error Code: e1012, Error Message: pcp_recovery_node command error occurred and
>> 'Stop', 'Restart', 'Reload' and 'Remove' buttons are still disabled.
>>
>> I have attached the screen shots and waiting for your help.
>>
>> Best regards,
>> Giles.
>>
>>
>> On 17 September 2015 at 19:52, Giles Gomes <giles.gomes at retailephant.com<mailto:giles.gomes at retailephant.com>>
>> wrote:
>>
>>> Hello Tatsuo Ishii,
>>>
>>> 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.
>>>
>>> pgpool.log and the screen shot is attached with this email.
>>>
>>> --
>>> Best regards,
>>> Giles Cornelius Gomes
>>> Database Administrator
>>> Impel IT Solutions Ltd.
>>> Phone: +88 01 714329389<tel:%2B88%2001%20714329389>
>>>
>>> On 16 September 2015 at 21:24, Giles Gomes <giles.gomes at retailephant.com<mailto:giles.gomes at retailephant.com>>
>>> wrote:
>>>
>>>> Hi Tatsuo,
>>>>
>>>> Thanks for your response. install-functions.sh has worked properly
>>>> after installing postgresql-server-dev-9.3.
>>>>
>>>> I was also able to run basebackup.sh, although "mkdir: cannot create
>>>> directory ‘/var/lib/postgresql/9.3/main/pg_xlog’: File exists" is showing
>>>> while running this as following:
>>>>
>>>> -------------------------------------------------------------------------------------------
>>>> postgres at osspc17:~/9.3/main$ ./basebackup.sh
>>>> pg_start_backup
>>>> -----------------
>>>> 0/1C000028
>>>> (1 row)
>>>>
>>>> mkdir: cannot create directory ‘/var/lib/postgresql/9.3/main/pg_xlog’:
>>>> File exists
>>>> mytemp23915
>>>> 100% 153
>>>> 0.2KB/s 00:00
>>>> NOTICE: pg_stop_backup complete, all required WAL segments have been
>>>> archived
>>>> pg_stop_backup
>>>> ----------------
>>>> 0/1C0000F0
>>>> (1 row)
>>>>
>>>> --------------------------------------------------------------------------------------------
>>>>
>>>> After running this script I have restarted the standby database as
>>>> following:
>>>>
>>>> $ service postgresql restart
>>>>
>>>> After restarting the database I am unable to login to database.
>>>> following error is showing:
>>>>
>>>> --------------------------------------------------------------------------
>>>> postgres at osspc18:~$ psql
>>>> psql: FATAL: the database system is starting up
>>>>
>>>> --------------------------------------------------------------------------
>>>>
>>>> What should I do now?
>>>>
>>>> Best regards,
>>>> Giles.
>>>>
>>>>
>>>>
>>>> On 16 September 2015 at 04:59, Tatsuo Ishii <ishii at postgresql.org<mailto:ishii at postgresql.org>>
>>>> wrote:
>>>>
>>>>> > Hi Tatsuo,
>>>>> >
>>>>> > Thanks for your quick response. I was trying to configure replication
>>>>> with
>>>>> > pgpool II between three VM.
>>>>> > 1. Pgpool Server. where pgpool-II-3.4.3 is installed .I wish to
>>>>> install
>>>>> > Pgpool Admin here also.
>>>>> > 2. Primary Server, where PostgreSQL 9.3.9 is installed.
>>>>> > 3. Standby Server, where PostgreSQL 9.3.9 is installed.
>>>>> >
>>>>> > 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.
>>>>> >
>>>>> > http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/
>>>>> >
>>>>> > Here they told to run a script named install-functions.sh
>>>>> >
>>>>> > But following errors are showing while running it.
>>>>> >
>>>>> --------------------------------------------------------------------------------------------------------------------
>>>>> > postgres at osspc16:/home/vagrant$ ./install-functions.sh
>>>>> > Makefile:19: /usr/lib/postgresql/9.3/lib/pgxs/src/makefiles/pgxs.mk<http://pgxs.mk>:
>>>>> No
>>>>> > such fil
>>>>> > e or directory
>>>>> > make: *** No rule to make target
>>>>>
>>>>> Seems like a PostgreSQL RPM installation problem, rather than a
>>>>> pgpool-II installation problem. Have you installed postgresql-devel
>>>>> package?
>>>>>
>>>>> Best regards,
>>>>> --
>>>>> Tatsuo Ishii
>>>>> SRA OSS, Inc. Japan
>>>>> English: http://www.sraoss.co.jp/index_en.php
>>>>> Japanese:http://www.sraoss.co.jp
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Best regards,
>>>> Giles Cornelius Gomes
>>>> Database Administrator
>>>> Impel IT Solutions Ltd.
>>>> Phone: +88 01 714329389<tel:%2B88%2001%20714329389>
>>>>
>>>
>>>
>>>
>>> --
>>> Best regards,
>>> Giles Cornelius Gomes
>>> Database Administrator
>>> Impel IT Solutions Ltd.
>>> Phone: +88 01 714329389<tel:%2B88%2001%20714329389>
>>>
>>
>>
>>
>> --
>> Best regards,
>> Giles Cornelius Gomes
>> Database Administrator
>> Impel IT Solutions Ltd.
>> Phone: +88 01 714329389<tel:%2B88%2001%20714329389>
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
--
Best regards,
Giles Cornelius Gomes
Database Administrator
Impel IT Solutions Ltd.
Phone: +88 01 714329389
--
Best regards,
Giles Cornelius Gomes
Database Administrator
Impel IT Solutions Ltd.
Phone: +88 01 714329389
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20151001/9a033cbd/attachment.html>
More information about the pgpool-general
mailing list