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

[Giles Gomes]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150920/1ffce45c/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Error_01.jpg
Type: image/jpeg
Size: 154390 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150920/1ffce45c/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_01.jpg
Type: image/jpeg
Size: 241294 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150920/1ffce45c/attachment-0003.jpg>