<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
I checked repmgr.<br>
This product manages PostgreSQL streaming replication. Right?<br>
<br>
I think if you perform managing streaming replication
<meta charset="utf-8">
<span style="color: rgb(0, 0, 0); font-family: 'MS PGothic', 'Lucida
Grande', sans-serif; font-size: 14px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing: 1px;
line-height: 13px; orphans: 2; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; display: inline !important; float:
none; ">though pgpool manages<br>
streaming replication, pgpool does not work.<br>
so I think you should not set streaming replication function of
pgpool.<br>
or if you want to set this, you have to manage pgpool and repmgr.<br>
</span><br>
All application access to PostgreSQL Server via pgpool.<br>
in this case, you install a pgpool instance, if pgpool goes down,
your services stop.<br>
so I recommend you should install both servers.<br>
<br>
thanks<br>
<br>
(5/2/12 6:53 PM), Freddy Liaw wrote:
<blockquote
cite="mid:CAKsLaSgdkW6kSesiSpX7tER09habQweQekaMWMZvVe=w2+MQOw@mail.gmail.com"
type="cite">
<pre wrap="">I'm using repmgr
On 5/2/12, TakehiroWada <a class="moz-txt-link-rfc2396E" href="mailto:takehiro.wada@gmail.com"><takehiro.wada@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi
what's replication method?
slony or streaming replication?
or other function?
On May 2, 24 Heisei, at 18:13, Freddy Liaw <a class="moz-txt-link-rfc2396E" href="mailto:freddyliaw@softmy.net"><freddyliaw@softmy.net></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi, currently i have 2 ubuntu server (Master/Slave) and postgreSQL
installed in both server. Should i install pgpool in both server?
On 5/2/12, takehiro wada <a class="moz-txt-link-rfc2396E" href="mailto:takehiro.wada@gmail.com"><takehiro.wada@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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 <a class="moz-txt-link-freetext" 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>
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 <a class="moz-txt-link-rfc2396E" href="mailto:freddyliaw@softmy.net"><freddyliaw@softmy.net></a>
</pre>
<blockquote type="cite">
<pre wrap="">Hi, I had install PostgreSQL 9.1 via apt-get. I have not install pgpool
yet.
On 5/2/12, takehiro wada <a class="moz-txt-link-rfc2396E" href="mailto:takehiro.wada@gmail.com"><takehiro.wada@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:freddyliaw@softmy.net"><freddyliaw@softmy.net></a>
</pre>
<blockquote type="cite">
<pre wrap="">Hi, I am very new to pgpool and just started plan to use it.
_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<pre wrap="">
--
*************************
Name:Takehiro Wada
<a class="moz-txt-link-abbreviated" href="mailto:mail:takehiro.wada@gmail.com">mail:takehiro.wada@gmail.com</a>
*************************
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">
--
*************************
Name:Takehiro Wada
<a class="moz-txt-link-abbreviated" href="mailto:mail:takehiro.wada@gmail.com">mail:takehiro.wada@gmail.com</a>
*************************
</pre>
</blockquote>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
</blockquote>
<br>
</body>
</html>