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

[Giles Gomes]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150916/8f4e9b77/attachment.html>