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

[Takehiro Wada]

Hi,

I checked repmgr.
This product manages PostgreSQL streaming replication. Right?

I think if you perform managing streaming replication though pgpool manages
streaming replication, pgpool does not work.
so I think you should not set streaming replication function of pgpool.
or if you want to set this, you have to manage pgpool and repmgr.

All application access to PostgreSQL Server via pgpool.
in this case, you install a pgpool instance, if pgpool goes down, your 
services stop.
so I recommend you should install both servers.

thanks

(5/2/12 6:53 PM), Freddy Liaw wrote:
> I'm using repmgr
>
> On 5/2/12, TakehiroWada<takehiro.wada at gmail.com>  wrote:
>> Hi
>> what's replication method?
>> slony or streaming replication?
>> or other function?
>>
>> On May 2, 24 Heisei, at 18:13, Freddy Liaw<freddyliaw at softmy.net>  wrote:
>>
>>> 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<takehiro.wada at gmail.com>  wrote:
>>>> 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/9a14513d/attachment.html>