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

[Daniel Gallo]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150925/80699583/attachment.html>