[pgpool-general: 4090] Re: Unable to configure replication with pgpool.
Giles Gomes
giles.gomes at retailephant.com
Mon Sep 28 19:50:51 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 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150928/f622006a/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/20150928/f622006a/attachment-0001.sh>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Monday.log
Type: application/octet-stream
Size: 1204028 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150928/f622006a/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/20150928/f622006a/attachment-0003.obj>
More information about the pgpool-general
mailing list