[pgpool-general: 4078] Re: Unable to configure replication with pgpool.

[Tatsuo Ishii]

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>:
> 
>> 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>
>> 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
>>>
>>> On 16 September 2015 at 21:24, Giles Gomes <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>
>>>> 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:
>>>>> 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
>>>>
>>>
>>>
>>>
>>> --
>>> 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
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>