<div><div>Hi,</div><div><br></div><div>The step by step installation of pgpool.</div><div><br></div><div> Step1)</div><div> - you get pgpool source via pgpool wiki</div><div> I recommend you download the latest pgpool version.</div>
<div> </div><div> e.g.)</div><div> $ wget <a href="http://www.pgpool.net/download.php?f=pgpool-II-3.1.3.tar.gz">http://www.pgpool.net/download.php?f=pgpool-II-3.1.3.tar.gz</a></div><div><br></div><div> Step2)</div>
<div> - you uncompress pgpool source.</div><div><br></div><div> e.g.)</div><div> $ tar xzvf pgpool-II.3.1.3.tar.gz</div><div><br></div><div> Step3)</div><div> - installing pgpool.</div><div> $ cd pgpool-II-3.1.3</div>
<div> $ ./configure [ --prefix=<pgpool_binary_location> ]</div><div><br></div><div> Step4)</div><div> - creating pgpool configuration file.</div><div><br></div><div> e.g.)</div><div> minimum setting</div>
<div> -----------</div><div> listen_addresses = 'localhost'</div><div> pid_file_name = '/var/run/pgpool.pid'</div><div> port = 9999</div><div> pcp_port = 9989</div><div>
backend_hostname0 = '<Hostname of PostgreSQL Server>'</div><div> backend_port0 = <Port# of PostgreSQL Server></div><div> -----------</div><div><br></div><div> Step5)</div><div> - checking whether you can access to PostgreSQL via pgpool</div>
<div><br></div><div> e.g.)</div><div> psql -h localhost -p 9999 -U <PostgreSQL User> <dbaname></div></div><div><br></div><div><br></div><div class="gmail_quote">2012/5/2 Freddy Liaw <span dir="ltr"><<a href="mailto:freddyliaw@softmy.net" target="_blank">freddyliaw@softmy.net</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi, I had install PostgreSQL 9.1 via apt-get. I have not install pgpool yet.<br>
<div><div><br>
<br>
<br>
On 5/2/12, takehiro wada <<a href="mailto:takehiro.wada@gmail.com" target="_blank">takehiro.wada@gmail.com</a>> wrote:<br>
> Hi<br>
><br>
> - Did you already install PostgreSQL?<br>
> if you said yes, PostgreSQL is installed via apt-get or source?<br>
> - Which pgpool and PostgreSQL version?<br>
><br>
> 2012/5/2 Freddy Liaw <<a href="mailto:freddyliaw@softmy.net" target="_blank">freddyliaw@softmy.net</a>><br>
><br>
>> Hi, I am very new to pgpool and just started plan to use it.<br>
>> _______________________________________________<br>
>> pgpool-general mailing list<br>
>> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>><br>
><br>
><br>
><br>
> --<br>
> *************************<br>
> Name:Takehiro Wada<br>
> <a href="mailto:mail%3Atakehiro.wada@gmail.com" target="_blank">mail:takehiro.wada@gmail.com</a><br>
> *************************<br>
><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>*************************<br>Name:Takehiro Wada<br><a href="mailto:mail%3Atakehiro.wada@gmail.com" target="_blank">mail:takehiro.wada@gmail.com</a><br>
*************************<br>