[pgpool-general: 401] Re: Step-by-Step Configure pgpool on ubuntu server

[takehiro wada]

Hi,

The step by step installation of pgpool.

 Step1)
   - you get pgpool source via pgpool wiki
     I recommend you download the latest pgpool version.

     e.g.)
     $ wget http://www.pgpool.net/download.php?f=pgpool-II-3.1.3.tar.gz

 Step2)
   - you uncompress pgpool source.

     e.g.)
     $ tar xzvf pgpool-II.3.1.3.tar.gz

 Step3)
   - installing pgpool.
     $ cd pgpool-II-3.1.3
     $ ./configure [ --prefix=<pgpool_binary_location> ]

 Step4)
   - creating pgpool configuration file.

     e.g.)
      minimum setting
      -----------
      listen_addresses = 'localhost'
      pid_file_name = '/var/run/pgpool.pid'
      port          = 9999
      pcp_port      = 9989
      backend_hostname0 = '<Hostname of PostgreSQL Server>'
      backend_port0     = <Port# of PostgreSQL Server>
      -----------

 Step5)
   - checking whether you can access to PostgreSQL via pgpool

     e.g.)
     psql -h localhost -p 9999 -U <PostgreSQL User> <dbaname>


2012/5/2 Freddy Liaw <freddyliaw at softmy.net>

> Hi, I had install PostgreSQL 9.1 via apt-get. I have not install pgpool
> yet.
>
>
>
> On 5/2/12, takehiro wada <takehiro.wada at gmail.com> wrote:
> > Hi
> >
> >  - Did you already install PostgreSQL?
> >      if you said yes, PostgreSQL is installed via apt-get or source?
> >  - Which pgpool and PostgreSQL version?
> >
> > 2012/5/2 Freddy Liaw <freddyliaw at softmy.net>
> >
> >> Hi, I am very new to pgpool and just started plan to use it.
> >> _______________________________________________
> >> pgpool-general mailing list
> >> pgpool-general at pgpool.net
> >> http://www.pgpool.net/mailman/listinfo/pgpool-general
> >>
> >
> >
> >
> > --
> > *************************
> > Name:Takehiro Wada
> > mail:takehiro.wada at gmail.com
> > *************************
> >
>



-- 
*************************
Name:Takehiro Wada
mail:takehiro.wada at gmail.com
*************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120502/60ca50a0/attachment.html>