[pgpool-general: 4079] Re: Unable to configure replication with pgpool.
Giles Gomes
giles.gomes at retailephant.com
Wed Sep 30 21:59:59 JST 2015
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>
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> 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>:
>> >
>> >> 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
>> >>
>> >>
>>
>
>
>
> --
> 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/20150930/019b872b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: basebackup.sh
Type: application/x-sh
Size: 1173 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150930/019b872b/attachment-0001.sh>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Monday.log
Type: application/octet-stream
Size: 2700 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150930/019b872b/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.log
Type: application/octet-stream
Size: 35265 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150930/019b872b/attachment-0003.obj>
More information about the pgpool-general
mailing list