[pgpool-general: 4087] Re: Unable to configure replication with pgpool.
Sébastien Ruiz
sruiz at cyres.fr
Mon Oct 5 16:37:14 JST 2015
Hi Giles,
(sorry for my poor english...)
In your postgresql.conf :
archive_command = 'cd .'
With this parameter, archiving the WAL segments is not possible.
You must have an archive_command like this (it's just an example) :
archive_command = 'test ! -f /mnt/server/archive_dest/%f && cp %p /mnt/server/archive_dest/%f'
In your recovery.conf :
parameter restore_command is missing.
best regards.
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é : dimanche 4 octobre 2015 07:36
À : Tatsuo Ishii
Cc : Frank van Doorn; pgpool-general at pgpool.net
Objet : [pgpool-general: 4086] Re: Unable to configure replication with pgpool.
Hi Tatsuo,
Thanks for your response. I have attached postgresql.conf of primary and recovery.conf of standby with this email.
Regards,
Giles.
On 3 October 2015 at 13:08, Tatsuo Ishii <ishii at postgresql.org<mailto:ishii at postgresql.org>> wrote:
Seems streaming replication is not working. Standby requests a WAL
segment but primary does not have it. Can you show me postgresql.conf
of primary and recovery.conf of standby?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Hi Tatsuo,
>
> I was able to minimize some errors at master (primary) PostgreSQL's log. I
> have attached the new log with this email.
>
> Best regards,
> Giles.
>
>
> On 30 September 2015 at 18:59, 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 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<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>
--
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/20151005/66d7e334/attachment-0001.html>
More information about the pgpool-general
mailing list