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

[Giles Gomes]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150917/a4b11212/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.log
Type: application/octet-stream
Size: 7201 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150917/a4b11212/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpoolAdmin.jpg
Type: image/jpeg
Size: 239622 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150917/a4b11212/attachment-0001.jpg>