pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAutomatic Failover Hot Standby / Streaming replication
14+ messages / 5 participants
[nested] [flat]
* Automatic Failover Hot Standby / Streaming replication
@ 2012-02-12 17:01 Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-13 12:06 ` Re: Automatic Failover Hot Standby / Streaming replication Devrim GÜNDÜZ <devrim@gunduz.org>
0 siblings, 2 replies; 14+ messages in thread
From: Wissem @ 2012-02-12 17:01 UTC (permalink / raw)
To: pgsql-admin
Hello,
I am new user of Postgresql, I have successfully set up a Hot Standby /
Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql
version 9.1).
I need to set up an automatic failover and discovered that there is a tool
named; pgpool. I have searched a lot on the net and didn't found a useful
article (step by step) to setup it.
Could you please help me and share any useful document with me?
thanks,
W
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
@ 2012-02-13 07:37 ` 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
1 sibling, 1 reply; 14+ messages in thread
From: 杨晓青 @ 2012-02-13 07:37 UTC (permalink / raw)
To: Wissem <kiwan2005@gmail.com>; +Cc: pgsql-admin
This document may help you.
http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
see "Failover with Streaming Replication" section.
2012/2/13 Wissem <kiwan2005@gmail.com>
>
> Hello,
>
> I am new user of Postgresql, I have successfully set up a Hot Standby /
> Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql
> version 9.1).
>
> I need to set up an automatic failover and discovered that there is a tool
> named; pgpool. I have searched a lot on the net and didn't found a useful
> article (step by step) to setup it.
>
> Could you please help me and share any useful document with me?
>
> thanks,
>
> W
>
>
>
--
-------------------------------------------
best regards
杨晓青
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
@ 2012-02-27 10:17 ` Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 14:30 ` Re: Automatic Failover Hot Standby / Streaming replication Lennin Caro <lennin.caro@yahoo.com>
0 siblings, 2 replies; 14+ messages in thread
From: Wissem @ 2012-02-27 10:17 UTC (permalink / raw)
To: 杨晓青 <xqy1522@gmail.com>; +Cc: pgsql-admin
Hello,
To install pgpool, I run this command in my virtual machine (OS: Redhat
linux 5);
*yum install pgpool-II-91.i386*
Is it correct? this will install full and complete pgpool librairies
necessary for the Hot Standby / Streaming replication on 2 servers on my
machine?
Thanks
2012/2/13 杨晓青 <xqy1522@gmail.com>
> This document may help you.
> http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
>
> see "Failover with Streaming Replication" section.
>
> 2012/2/13 Wissem <kiwan2005@gmail.com>
>
>>
>> Hello,
>>
>> I am new user of Postgresql, I have successfully set up a Hot Standby /
>> Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql
>> version 9.1).
>>
>> I need to set up an automatic failover and discovered that there is a
>> tool named; pgpool. I have searched a lot on the net and didn't found a
>> useful article (step by step) to setup it.
>>
>> Could you please help me and share any useful document with me?
>>
>> thanks,
>>
>> W
>>
>>
>>
>
>
> --
> -------------------------------------------
> best regards
>
> 杨晓青
>
--
WIssem EL KHLIFI,
Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
@ 2012-02-27 11:39 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:07 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
1 sibling, 1 reply; 14+ messages in thread
From: Matheus de Oliveira @ 2012-02-27 11:39 UTC (permalink / raw)
To: Wissem <kiwan2005@gmail.com>; +Cc: 杨晓青 <xqy1522@gmail.com>; pgsql-admin
Wissem,
Execute the command:
$ pgpool -v
And check if you are using the newst version, 3.1.2.
If not, I recommend you to download and compile the pgpool source code by
hand (it's easy).
Regards,
--
Matheus de Oliveira
Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho -
LCAD<http://www.lcad.icmc.usp.br/;
Instituto de Ciências Matemáticas e de Computação -
ICMC<http://www.icmc.usp.br/;
Universidade de São Paulo - USP <http://www.sc.usp.br/;
On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.com> wrote:
> Hello,
>
> To install pgpool, I run this command in my virtual machine (OS: Redhat
> linux 5);
>
> *yum install pgpool-II-91.i386*
>
> Is it correct? this will install full and complete pgpool librairies
> necessary for the Hot Standby / Streaming replication on 2 servers on my
> machine?
>
> Thanks
>
>
> 2012/2/13 杨晓青 <xqy1522@gmail.com>
>
>> This document may help you.
>> http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
>>
>> see "Failover with Streaming Replication" section.
>>
>> 2012/2/13 Wissem <kiwan2005@gmail.com>
>>
>>>
>>> Hello,
>>>
>>> I am new user of Postgresql, I have successfully set up a Hot Standby /
>>> Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql
>>> version 9.1).
>>>
>>> I need to set up an automatic failover and discovered that there is a
>>> tool named; pgpool. I have searched a lot on the net and didn't found a
>>> useful article (step by step) to setup it.
>>>
>>> Could you please help me and share any useful document with me?
>>>
>>> thanks,
>>>
>>> W
>>>
>>>
>>>
>>
>>
>> --
>> -------------------------------------------
>> best regards
>>
>> 杨晓青
>>
>
>
>
> --
> WIssem EL KHLIFI,
>
> Oracle ACE
> Senior Oracle DBA
> Database Team Leader
> Computer Science Engineer
>
>
>
>
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
@ 2012-02-27 12:07 ` Wissem <kiwan2005@gmail.com>
2012-02-27 12:24 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
0 siblings, 1 reply; 14+ messages in thread
From: Wissem @ 2012-02-27 12:07 UTC (permalink / raw)
To: Matheus de Oliveira <matioli.matheus@gmail.com>; +Cc: 杨晓青 <xqy1522@gmail.com>; pgsql-admin
Hi Matheus,
When I run ;
$ pgpool -v
I have:
pgpool: error while loading shared libraries: libpq.so.5: cannot open
shared object file: No such file or directory
Could you please help installing pgpool ?
Thanks,
Wissem
2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
> Wissem,
>
> Execute the command:
>
> $ pgpool -v
>
> And check if you are using the newst version, 3.1.2.
>
> If not, I recommend you to download and compile the pgpool source code by
> hand (it's easy).
>
> Regards,
> --
> Matheus de Oliveira
>
> Bacharelado em Ciências de Computação
> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>
>
>
>
>
> On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.com> wrote:
>
>> Hello,
>>
>> To install pgpool, I run this command in my virtual machine (OS: Redhat
>> linux 5);
>>
>> *yum install pgpool-II-91.i386*
>>
>> Is it correct? this will install full and complete pgpool librairies
>> necessary for the Hot Standby / Streaming replication on 2 servers on my
>> machine?
>>
>> Thanks
>>
>>
>> 2012/2/13 杨晓青 <xqy1522@gmail.com>
>>
>>> This document may help you.
>>> http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
>>>
>>> see "Failover with Streaming Replication" section.
>>>
>>> 2012/2/13 Wissem <kiwan2005@gmail.com>
>>>
>>>>
>>>> Hello,
>>>>
>>>> I am new user of Postgresql, I have successfully set up a Hot Standby /
>>>> Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql
>>>> version 9.1).
>>>>
>>>> I need to set up an automatic failover and discovered that there is a
>>>> tool named; pgpool. I have searched a lot on the net and didn't found a
>>>> useful article (step by step) to setup it.
>>>>
>>>> Could you please help me and share any useful document with me?
>>>>
>>>> thanks,
>>>>
>>>> W
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> -------------------------------------------
>>> best regards
>>>
>>> 杨晓青
>>>
>>
>>
>>
>> --
>> WIssem EL KHLIFI,
>>
>> Oracle ACE
>> Senior Oracle DBA
>> Database Team Leader
>> Computer Science Engineer
>>
>>
>>
>>
>>
>
--
WIssem EL KHLIFI,
Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:07 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
@ 2012-02-27 12:24 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:39 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:42 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
0 siblings, 2 replies; 14+ messages in thread
From: Matheus de Oliveira @ 2012-02-27 12:24 UTC (permalink / raw)
To: Wissem <kiwan2005@gmail.com>; +Cc: 杨晓青 <xqy1522@gmail.com>; pgsql-admin
You have to install the postgresql client libraries first, it's missing.
Must be something like:
yum install postgresql9.1-client
But I'm not sure about the right package name.
Regards,
--
Matheus de Oliveira
Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho -
LCAD<http://www.lcad.icmc.usp.br/;
Instituto de Ciências Matemáticas e de Computação -
ICMC<http://www.icmc.usp.br/;
Universidade de São Paulo - USP <http://www.sc.usp.br/;
On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
> Hi Matheus,
>
> When I run ;
>
> $ pgpool -v
>
> I have:
>
> pgpool: error while loading shared libraries: libpq.so.5: cannot open
> shared object file: No such file or directory
>
> Could you please help installing pgpool ?
>
> Thanks,
> Wissem
>
> 2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
>
>> Wissem,
>>
>> Execute the command:
>>
>> $ pgpool -v
>>
>> And check if you are using the newst version, 3.1.2.
>>
>> If not, I recommend you to download and compile the pgpool source code by
>> hand (it's easy).
>>
>> Regards,
>> --
>> Matheus de Oliveira
>>
>> Bacharelado em Ciências de Computação
>> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
>> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
>> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>>
>>
>>
>>
>>
>> On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.com> wrote:
>>
>>> Hello,
>>>
>>> To install pgpool, I run this command in my virtual machine (OS: Redhat
>>> linux 5);
>>>
>>> *yum install pgpool-II-91.i386*
>>>
>>> Is it correct? this will install full and complete pgpool librairies
>>> necessary for the Hot Standby / Streaming replication on 2 servers on my
>>> machine?
>>>
>>> Thanks
>>>
>>>
>>> 2012/2/13 杨晓青 <xqy1522@gmail.com>
>>>
>>>> This document may help you.
>>>> http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
>>>>
>>>> see "Failover with Streaming Replication" section.
>>>>
>>>> 2012/2/13 Wissem <kiwan2005@gmail.com>
>>>>
>>>>>
>>>>> Hello,
>>>>>
>>>>> I am new user of Postgresql, I have successfully set up a Hot Standby
>>>>> / Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql
>>>>> version 9.1).
>>>>>
>>>>> I need to set up an automatic failover and discovered that there is a
>>>>> tool named; pgpool. I have searched a lot on the net and didn't found a
>>>>> useful article (step by step) to setup it.
>>>>>
>>>>> Could you please help me and share any useful document with me?
>>>>>
>>>>> thanks,
>>>>>
>>>>> W
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> -------------------------------------------
>>>> best regards
>>>>
>>>> 杨晓青
>>>>
>>>
>>>
>>>
>>> --
>>> WIssem EL KHLIFI,
>>>
>>> Oracle ACE
>>> Senior Oracle DBA
>>> Database Team Leader
>>> Computer Science Engineer
>>>
>>>
>>>
>>>
>>>
>>
>
>
> --
> WIssem EL KHLIFI,
>
> Oracle ACE
> Senior Oracle DBA
> Database Team Leader
> Computer Science Engineer
>
>
>
>
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:07 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:24 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
@ 2012-02-27 12:39 ` Wissem <kiwan2005@gmail.com>
1 sibling, 0 replies; 14+ messages in thread
From: Wissem @ 2012-02-27 12:39 UTC (permalink / raw)
To: Matheus de Oliveira <matioli.matheus@gmail.com>; +Cc: 杨晓青 <xqy1522@gmail.com>; pgsql-admin
Hi,
I already have postgresql 9.1 server installed on this server.
2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
> You have to install the postgresql client libraries first, it's missing.
>
> Must be something like:
>
> yum install postgresql9.1-client
>
> But I'm not sure about the right package name.
>
>
> Regards,
> --
> Matheus de Oliveira
>
> Bacharelado em Ciências de Computação
> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>
>
>
>
> On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
>
>> Hi Matheus,
>>
>> When I run ;
>>
>> $ pgpool -v
>>
>> I have:
>>
>> pgpool: error while loading shared libraries: libpq.so.5: cannot open
>> shared object file: No such file or directory
>>
>> Could you please help installing pgpool ?
>>
>> Thanks,
>> Wissem
>>
>> 2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
>>
>>> Wissem,
>>>
>>> Execute the command:
>>>
>>> $ pgpool -v
>>>
>>> And check if you are using the newst version, 3.1.2.
>>>
>>> If not, I recommend you to download and compile the pgpool source code
>>> by hand (it's easy).
>>>
>>> Regards,
>>> --
>>> Matheus de Oliveira
>>>
>>> Bacharelado em Ciências de Computação
>>> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
>>> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
>>> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>>>
>>>
>>>
>>>
>>>
>>> On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.com> wrote:
>>>
>>>> Hello,
>>>>
>>>> To install pgpool, I run this command in my virtual machine (OS: Redhat
>>>> linux 5);
>>>>
>>>> *yum install pgpool-II-91.i386*
>>>>
>>>> Is it correct? this will install full and complete pgpool librairies
>>>> necessary for the Hot Standby / Streaming replication on 2 servers on my
>>>> machine?
>>>>
>>>> Thanks
>>>>
>>>>
>>>> 2012/2/13 杨晓青 <xqy1522@gmail.com>
>>>>
>>>>> This document may help you.
>>>>> http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
>>>>>
>>>>> see "Failover with Streaming Replication" section.
>>>>>
>>>>> 2012/2/13 Wissem <kiwan2005@gmail.com>
>>>>>
>>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> I am new user of Postgresql, I have successfully set up a Hot Standby
>>>>>> / Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql
>>>>>> version 9.1).
>>>>>>
>>>>>> I need to set up an automatic failover and discovered that there is a
>>>>>> tool named; pgpool. I have searched a lot on the net and didn't found a
>>>>>> useful article (step by step) to setup it.
>>>>>>
>>>>>> Could you please help me and share any useful document with me?
>>>>>>
>>>>>> thanks,
>>>>>>
>>>>>> W
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> -------------------------------------------
>>>>> best regards
>>>>>
>>>>> 杨晓青
>>>>>
>>>>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:07 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:24 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
@ 2012-02-27 12:42 ` Wissem <kiwan2005@gmail.com>
2012-02-27 12:53 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
1 sibling, 1 reply; 14+ messages in thread
From: Wissem @ 2012-02-27 12:42 UTC (permalink / raw)
To: Matheus de Oliveira <matioli.matheus@gmail.com>; +Cc: 杨晓青 <xqy1522@gmail.com>; pgsql-admin
I installed the missing package and I have;
pgpool -v
pgpool-II version 3.1 (hatsuiboshi)
2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
> You have to install the postgresql client libraries first, it's missing.
>
> Must be something like:
>
> yum install postgresql9.1-client
>
> But I'm not sure about the right package name.
>
>
> Regards,
> --
> Matheus de Oliveira
>
> Bacharelado em Ciências de Computação
> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>
>
>
>
> On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
>
>> Hi Matheus,
>>
>> When I run ;
>>
>> $ pgpool -v
>>
>> I have:
>>
>> pgpool: error while loading shared libraries: libpq.so.5: cannot open
>> shared object file: No such file or directory
>>
>> Could you please help installing pgpool ?
>>
>> Thanks,
>> Wissem
>>
>> 2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
>>
>>> Wissem,
>>>
>>> Execute the command:
>>>
>>> $ pgpool -v
>>>
>>> And check if you are using the newst version, 3.1.2.
>>>
>>> If not, I recommend you to download and compile the pgpool source code
>>> by hand (it's easy).
>>>
>>> Regards,
>>> --
>>> Matheus de Oliveira
>>>
>>> Bacharelado em Ciências de Computação
>>> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
>>> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
>>> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>>>
>>>
>>>
>>>
>>>
>>> On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.com> wrote:
>>>
>>>> Hello,
>>>>
>>>> To install pgpool, I run this command in my virtual machine (OS: Redhat
>>>> linux 5);
>>>>
>>>> *yum install pgpool-II-91.i386*
>>>>
>>>> Is it correct? this will install full and complete pgpool librairies
>>>> necessary for the Hot Standby / Streaming replication on 2 servers on my
>>>> machine?
>>>>
>>>> Thanks
>>>>
>>>>
>>>> 2012/2/13 杨晓青 <xqy1522@gmail.com>
>>>>
>>>>> This document may help you.
>>>>> http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
>>>>>
>>>>> see "Failover with Streaming Replication" section.
>>>>>
>>>>> 2012/2/13 Wissem <kiwan2005@gmail.com>
>>>>>
>>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> I am new user of Postgresql, I have successfully set up a Hot Standby
>>>>>> / Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql
>>>>>> version 9.1).
>>>>>>
>>>>>> I need to set up an automatic failover and discovered that there is a
>>>>>> tool named; pgpool. I have searched a lot on the net and didn't found a
>>>>>> useful article (step by step) to setup it.
>>>>>>
>>>>>> Could you please help me and share any useful document with me?
>>>>>>
>>>>>> thanks,
>>>>>>
>>>>>> W
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> -------------------------------------------
>>>>> best regards
>>>>>
>>>>> 杨晓青
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> WIssem EL KHLIFI,
>>>>
>>>> Oracle ACE
>>>> Senior Oracle DBA
>>>> Database Team Leader
>>>> Computer Science Engineer
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>> --
>> WIssem EL KHLIFI,
>>
>> Oracle ACE
>> Senior Oracle DBA
>> Database Team Leader
>> Computer Science Engineer
>>
>>
>>
>>
>>
>
--
WIssem EL KHLIFI,
Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:07 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:24 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:42 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
@ 2012-02-27 12:53 ` Wissem <kiwan2005@gmail.com>
2012-02-27 13:06 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 14:33 ` Re: Automatic Failover Hot Standby / Streaming replication Lennin Caro <lennin.caro@yahoo.com>
0 siblings, 2 replies; 14+ messages in thread
From: Wissem @ 2012-02-27 12:53 UTC (permalink / raw)
To: Matheus de Oliveira <matioli.matheus@gmail.com>; +Cc: 杨晓青 <xqy1522@gmail.com>; pgsql-admin
Hello,
I can't find pgpool.conf file anywhere on the server. Shoud I create it by
hand and where?
Thank you
2012/2/27 Wissem <kiwan2005@gmail.com>
> I installed the missing package and I have;
>
> pgpool -v
> pgpool-II version 3.1 (hatsuiboshi)
>
>
>
>
> 2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
>
>> You have to install the postgresql client libraries first, it's missing.
>>
>> Must be something like:
>>
>> yum install postgresql9.1-client
>>
>> But I'm not sure about the right package name.
>>
>>
>> Regards,
>> --
>> Matheus de Oliveira
>>
>> Bacharelado em Ciências de Computação
>> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
>> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
>> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>>
>>
>>
>>
>> On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
>>
>>> Hi Matheus,
>>>
>>> When I run ;
>>>
>>> $ pgpool -v
>>>
>>> I have:
>>>
>>> pgpool: error while loading shared libraries: libpq.so.5: cannot open
>>> shared object file: No such file or directory
>>>
>>> Could you please help installing pgpool ?
>>>
>>> Thanks,
>>> Wissem
>>>
>>> 2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
>>>
>>>> Wissem,
>>>>
>>>> Execute the command:
>>>>
>>>> $ pgpool -v
>>>>
>>>> And check if you are using the newst version, 3.1.2.
>>>>
>>>> If not, I recommend you to download and compile the pgpool source code
>>>> by hand (it's easy).
>>>>
>>>> Regards,
>>>> --
>>>> Matheus de Oliveira
>>>>
>>>> Bacharelado em Ciências de Computação
>>>> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
>>>> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
>>>> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.com> wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>> To install pgpool, I run this command in my virtual machine (OS:
>>>>> Redhat linux 5);
>>>>>
>>>>> *yum install pgpool-II-91.i386*
>>>>>
>>>>> Is it correct? this will install full and complete pgpool librairies
>>>>> necessary for the Hot Standby / Streaming replication on 2 servers on my
>>>>> machine?
>>>>>
>>>>> Thanks
>>>>>
>>>>>
>>>>> 2012/2/13 杨晓青 <xqy1522@gmail.com>
>>>>>
>>>>>> This document may help you.
>>>>>> http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
>>>>>>
>>>>>> see "Failover with Streaming Replication" section.
>>>>>>
>>>>>> 2012/2/13 Wissem <kiwan2005@gmail.com>
>>>>>>
>>>>>>>
>>>>>>> Hello,
>>>>>>>
>>>>>>> I am new user of Postgresql, I have successfully set up a Hot
>>>>>>> Standby / Streaming replication on 2 servers running on Redhat Linux 5
>>>>>>> (Postgresql version 9.1).
>>>>>>>
>>>>>>> I need to set up an automatic failover and discovered that there is
>>>>>>> a tool named; pgpool. I have searched a lot on the net and didn't found a
>>>>>>> useful article (step by step) to setup it.
>>>>>>>
>>>>>>> Could you please help me and share any useful document with me?
>>>>>>>
>>>>>>> thanks,
>>>>>>>
>>>>>>> W
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> -------------------------------------------
>>>>>> best regards
>>>>>>
>>>>>> 杨晓青
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:07 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:24 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:42 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:53 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
@ 2012-02-27 13:06 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 14:33 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
1 sibling, 1 reply; 14+ messages in thread
From: Matheus de Oliveira @ 2012-02-27 13:06 UTC (permalink / raw)
To: Wissem <kiwan2005@gmail.com>; +Cc: 杨晓青 <xqy1522@gmail.com>; pgsql-admin
The default location is /usr/local/etc, but you can change it when you call
the pgpool.
I'm attaching the samples that come with pgpool 3.1.2.
Regards,
--
Matheus de Oliveira
Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho -
LCAD<http://www.lcad.icmc.usp.br/;
Instituto de Ciências Matemáticas e de Computação -
ICMC<http://www.icmc.usp.br/;
Universidade de São Paulo - USP <http://www.sc.usp.br/;
On Mon, Feb 27, 2012 at 9:53 AM, Wissem <kiwan2005@gmail.com> wrote:
> Hello,
>
> I can't find pgpool.conf file anywhere on the server. Shoud I create it by
> hand and where?
>
> Thank you
>
>
> 2012/2/27 Wissem <kiwan2005@gmail.com>
>
>> I installed the missing package and I have;
>>
>> pgpool -v
>> pgpool-II version 3.1 (hatsuiboshi)
>>
>>
>>
>>
>> 2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
>>
>>> You have to install the postgresql client libraries first, it's missing.
>>>
>>> Must be something like:
>>>
>>> yum install postgresql9.1-client
>>>
>>> But I'm not sure about the right package name.
>>>
>>>
>>> Regards,
>>> --
>>> Matheus de Oliveira
>>>
>>> Bacharelado em Ciências de Computação
>>> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
>>> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
>>> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>>>
>>>
>>>
>>>
>>> On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
>>>
>>>> Hi Matheus,
>>>>
>>>> When I run ;
>>>>
>>>> $ pgpool -v
>>>>
>>>> I have:
>>>>
>>>> pgpool: error while loading shared libraries: libpq.so.5: cannot open
>>>> shared object file: No such file or directory
>>>>
>>>> Could you please help installing pgpool ?
>>>>
>>>> Thanks,
>>>> Wissem
>>>>
>>>> 2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
>>>>
>>>>> Wissem,
>>>>>
>>>>> Execute the command:
>>>>>
>>>>> $ pgpool -v
>>>>>
>>>>> And check if you are using the newst version, 3.1.2.
>>>>>
>>>>> If not, I recommend you to download and compile the pgpool source code
>>>>> by hand (it's easy).
>>>>>
>>>>> Regards,
>>>>> --
>>>>> Matheus de Oliveira
>>>>>
>>>>> Bacharelado em Ciências de Computação
>>>>> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
>>>>> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
>>>>> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.com> wrote:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> To install pgpool, I run this command in my virtual machine (OS:
>>>>>> Redhat linux 5);
>>>>>>
>>>>>> *yum install pgpool-II-91.i386*
>>>>>>
>>>>>> Is it correct? this will install full and complete pgpool librairies
>>>>>> necessary for the Hot Standby / Streaming replication on 2 servers on my
>>>>>> machine?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>>
>>>>>> 2012/2/13 杨晓青 <xqy1522@gmail.com>
>>>>>>
>>>>>>> This document may help you.
>>>>>>> http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
>>>>>>>
>>>>>>> see "Failover with Streaming Replication" section.
>>>>>>>
>>>>>>> 2012/2/13 Wissem <kiwan2005@gmail.com>
>>>>>>>
>>>>>>>>
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> I am new user of Postgresql, I have successfully set up a Hot
>>>>>>>> Standby / Streaming replication on 2 servers running on Redhat Linux 5
>>>>>>>> (Postgresql version 9.1).
>>>>>>>>
>>>>>>>> I need to set up an automatic failover and discovered that there is
>>>>>>>> a tool named; pgpool. I have searched a lot on the net and didn't found a
>>>>>>>> useful article (step by step) to setup it.
>>>>>>>>
>>>>>>>> Could you please help me and share any useful document with me?
>>>>>>>>
>>>>>>>> thanks,
>>>>>>>>
>>>>>>>> W
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> -------------------------------------------
>>>>>>> best regards
>>>>>>>
>>>>>>> 杨晓青
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>
Attachments:
pgpool_conf_samples.zip (application/zip, 17.5K) download
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:07 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:24 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:42 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:53 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 13:06 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
@ 2012-02-27 14:33 ` Wissem <kiwan2005@gmail.com>
0 siblings, 0 replies; 14+ messages in thread
From: Wissem @ 2012-02-27 14:33 UTC (permalink / raw)
To: Matheus de Oliveira <matioli.matheus@gmail.com>; +Cc: 杨晓青 <xqy1522@gmail.com>; pgsql-admin
Thank you.
Now, I have the Master / Slave setup.
Virtual machine: Postgresql Master installed + pgpool installed
Virtual machine: Postgresql Slave installed,
The Hot Standby / Streaming replication on 2 servers works perfecly with
manual failover.
Now, I want to configure pgpool to do the automatic failover, my questions
are:
1- How to configure pgpool so it knows the HS/SR configuration I already
setup?
2- How pgpool will know about my HS/SR setup?
3- How to setup the automnatic failover with pgpool?
Thank you
2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
> The default location is /usr/local/etc, but you can change it when you
> call the pgpool.
>
> I'm attaching the samples that come with pgpool 3.1.2.
>
>
> Regards,
> --
> Matheus de Oliveira
>
> Bacharelado em Ciências de Computação
> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>
>
>
>
> On Mon, Feb 27, 2012 at 9:53 AM, Wissem <kiwan2005@gmail.com> wrote:
>
>> Hello,
>>
>> I can't find pgpool.conf file anywhere on the server. Shoud I create it
>> by hand and where?
>>
>> Thank you
>>
>>
>> 2012/2/27 Wissem <kiwan2005@gmail.com>
>>
>>> I installed the missing package and I have;
>>>
>>> pgpool -v
>>> pgpool-II version 3.1 (hatsuiboshi)
>>>
>>>
>>>
>>>
>>> 2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
>>>
>>>> You have to install the postgresql client libraries first, it's missing.
>>>>
>>>> Must be something like:
>>>>
>>>> yum install postgresql9.1-client
>>>>
>>>> But I'm not sure about the right package name.
>>>>
>>>>
>>>> Regards,
>>>> --
>>>> Matheus de Oliveira
>>>>
>>>> Bacharelado em Ciências de Computação
>>>> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
>>>> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
>>>> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
>>>>
>>>>> Hi Matheus,
>>>>>
>>>>> When I run ;
>>>>>
>>>>> $ pgpool -v
>>>>>
>>>>> I have:
>>>>>
>>>>> pgpool: error while loading shared libraries: libpq.so.5: cannot open
>>>>> shared object file: No such file or directory
>>>>>
>>>>> Could you please help installing pgpool ?
>>>>>
>>>>> Thanks,
>>>>> Wissem
>>>>>
>>>>> 2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
>>>>>
>>>>>> Wissem,
>>>>>>
>>>>>> Execute the command:
>>>>>>
>>>>>> $ pgpool -v
>>>>>>
>>>>>> And check if you are using the newst version, 3.1.2.
>>>>>>
>>>>>> If not, I recommend you to download and compile the pgpool source
>>>>>> code by hand (it's easy).
>>>>>>
>>>>>> Regards,
>>>>>> --
>>>>>> Matheus de Oliveira
>>>>>>
>>>>>> Bacharelado em Ciências de Computação
>>>>>> Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/;
>>>>>> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/;
>>>>>> Universidade de São Paulo - USP <http://www.sc.usp.br/;
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.com> wrote:
>>>>>>
>>>>>>> Hello,
>>>>>>>
>>>>>>> To install pgpool, I run this command in my virtual machine (OS:
>>>>>>> Redhat linux 5);
>>>>>>>
>>>>>>> *yum install pgpool-II-91.i386*
>>>>>>>
>>>>>>> Is it correct? this will install full and complete pgpool librairies
>>>>>>> necessary for the Hot Standby / Streaming replication on 2 servers on my
>>>>>>> machine?
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>>
>>>>>>> 2012/2/13 杨晓青 <xqy1522@gmail.com>
>>>>>>>
>>>>>>>> This document may help you.
>>>>>>>> http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
>>>>>>>>
>>>>>>>> see "Failover with Streaming Replication" section.
>>>>>>>>
>>>>>>>> 2012/2/13 Wissem <kiwan2005@gmail.com>
>>>>>>>>
>>>>>>>>>
>>>>>>>>> Hello,
>>>>>>>>>
>>>>>>>>> I am new user of Postgresql, I have successfully set up a Hot
>>>>>>>>> Standby / Streaming replication on 2 servers running on Redhat Linux 5
>>>>>>>>> (Postgresql version 9.1).
>>>>>>>>>
>>>>>>>>> I need to set up an automatic failover and discovered that there
>>>>>>>>> is a tool named; pgpool. I have searched a lot on the net and didn't found
>>>>>>>>> a useful article (step by step) to setup it.
>>>>>>>>>
>>>>>>>>> Could you please help me and share any useful document with me?
>>>>>>>>>
>>>>>>>>> thanks,
>>>>>>>>>
>>>>>>>>> W
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> -------------------------------------------
>>>>>>>> best regards
>>>>>>>>
>>>>>>>> 杨晓青
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:07 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:24 ` Re: Automatic Failover Hot Standby / Streaming replication Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:42 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-27 12:53 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
@ 2012-02-27 14:33 ` Lennin Caro <lennin.caro@yahoo.com>
1 sibling, 0 replies; 14+ messages in thread
From: Lennin Caro @ 2012-02-27 14:33 UTC (permalink / raw)
To: Matheus de Oliveira <matioli.matheus@gmail.com>; Wissem <kiwan2005@gmail.com>; +Cc: 杨晓青 <xqy1522@gmail.com>; pgsql-admin
try to use the sources and compile, I send a little help
--package install--------------------------------------------------------------
aptitude install postgresql-9.0
aptitude install postgresql-server-dev-9.0
aptitude install build-essential
aptitude install libssl-dev
aptitude install libreadline5-dev
aptitude install zlib-bin
aptitude install zlib1g-dev
aptitude install libpq-dev
aptitude install krb5-multidev comerr-dev libssl-dev
aptitude install libkrb5-dev
--compile source--------------------------------------------------------------
tar -xzf pgpool-II-3.1.tar.gz
cd pgpool-II-3.1
./configure --prefix=/opt/pgpool3
cd pgpool-II-3.1/sql/pgpool-regclass
make
make install
psql -f pgpool-regclass.sql template1
cd pgpool-II-3.1/sql
psql -f insert_lock.sql template1
cd pgpool-II-3.1/sql/pgpool-recovery
make
make install
psql -f pgpool-recovery.sql template1
--execute--------------------------------------------------------------
/opt/pgpool3/bin/pgpool -n&
Ing. Lennin Caro Pérez
Usuario:GNU/LINUX
PHP Developer
PostgreSQL DBA
Oracle DBA
Linux counter id 474393
--- On Mon, 2/27/12, Wissem <kiwan2005@gmail.com> wrote:
From: Wissem <kiwan2005@gmail.com>
Subject: Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication
To: "Matheus de Oliveira" <matioli.matheus@gmail.com>
Cc: "杨晓青" <xqy1522@gmail.com>, pgsql-admin@postgresql.org
Date: Monday, February 27, 2012, 12:53 PM
Hello,
I can't find pgpool.conf file anywhere on the server. Shoud I create it by hand and where?
Thank you
2012/2/27 Wissem <kiwan2005@gmail.com>
I installed the missing package and I have;
pgpool -vpgpool-II version 3.1 (hatsuiboshi)
2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
You have to install the postgresql client libraries first, it's missing.
Must be something like:
yum install postgresql9.1-client
But I'm not sure about the right package name.
Regards,
--
Matheus de Oliveira
Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho - LCAD
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP
On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
Hi Matheus,
When I run ;
$ pgpool -v
I have:
pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory
Could you please help installing pgpool ?
Thanks,Wissem
2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
Wissem,
Execute the command:
$ pgpool -v
And check if you are using the newst version, 3.1.2.
If not, I recommend you to download and compile the pgpool source code by hand (it's easy).
Regards,
--
Matheus de Oliveira
Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho - LCAD
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP
On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.com> wrote:
Hello,
To install pgpool, I run this command in my virtual machine (OS: Redhat linux 5);
yum install pgpool-II-91.i386
Is it correct? this will install full and complete pgpool librairies necessary for the Hot Standby / Streaming replication on 2 servers on my machine?
Thanks
2012/2/13 杨晓青 <xqy1522@gmail.com>
This document may help you. http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
see "Failover with Streaming Replication" section.
2012/2/13 Wissem <kiwan2005@gmail.com>
Hello,
I am new user of Postgresql, I have successfully set up a Hot Standby / Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql version 9.1).
I need to set up an automatic failover and discovered that there is a tool named; pgpool. I have searched a lot on the net and didn't found a useful article (step by step) to setup it.
Could you please help me and share any useful document with me?
thanks,
W
--
-------------------------------------------
best regards
杨晓青
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` Re: Automatic Failover Hot Standby / Streaming replication 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Re: Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
@ 2012-02-27 14:30 ` Lennin Caro <lennin.caro@yahoo.com>
1 sibling, 0 replies; 14+ messages in thread
From: Lennin Caro @ 2012-02-27 14:30 UTC (permalink / raw)
To: 杨晓青 <xqy1522@gmail.com>; Wissem <kiwan2005@gmail.com>; +Cc: pgsql-admin
Are you running the pgpool start as root?
Ing. Lennin Caro Pérez
Usuario:GNU/LINUX
PHP Developer
PostgreSQL DBA
Oracle DBA
Linux counter id 474393
--- On Mon, 2/27/12, Wissem <kiwan2005@gmail.com> wrote:
From: Wissem <kiwan2005@gmail.com>
Subject: Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication
To: "杨晓青" <xqy1522@gmail.com>
Cc: pgsql-admin@postgresql.org
Date: Monday, February 27, 2012, 10:17 AM
Hello,
To install pgpool, I run this command in my virtual machine (OS: Redhat linux 5);
yum install pgpool-II-91.i386
Is it correct? this will install full and complete pgpool librairies necessary for the Hot Standby / Streaming replication on 2 servers on my machine?
Thanks
2012/2/13 杨晓青 <xqy1522@gmail.com>
This document may help you. http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
see "Failover with Streaming Replication" section.
2012/2/13 Wissem <kiwan2005@gmail.com>
Hello,
I am new user of Postgresql, I have successfully set up a Hot Standby / Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql version 9.1).
I need to set up an automatic failover and discovered that there is a tool named; pgpool. I have searched a lot on the net and didn't found a useful article (step by step) to setup it.
Could you please help me and share any useful document with me?
thanks,
W
--
-------------------------------------------
best regards
杨晓青
--
WIssem EL KHLIFI,
Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Automatic Failover Hot Standby / Streaming replication
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
@ 2012-02-13 12:06 ` Devrim GÜNDÜZ <devrim@gunduz.org>
1 sibling, 0 replies; 14+ messages in thread
From: Devrim GÜNDÜZ @ 2012-02-13 12:06 UTC (permalink / raw)
To: Wissem <kiwan2005@gmail.com>; +Cc: pgsql-admin
On Sun, 2012-02-12 at 18:01 +0100, Wissem wrote:
>
> I am new user of Postgresql, I have successfully set up a Hot
> Standby / Streaming replication on 2 servers running on Redhat Linux 5
> (Postgresql version 9.1).
>
> I need to set up an automatic failover and discovered that there is a
> tool named; pgpool. I have searched a lot on the net and didn't found
> a useful article (step by step) to setup it.
Alternatively, you can use Red Hat Cluster Suite, and create the
trigger_file upon failover, with some minor customization in the cluster
files.
http://www.gunduz.org/download.php?dlid=190
will give you ideas about setting up RHCS with PostgreSQL. I don't have
any doc for triggering failover with RHCS, though. Should be very
simple.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 14+ messages in thread
end of thread, other threads:[~2012-02-27 14:33 UTC | newest]
Thread overview: 14+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-02-12 17:01 Automatic Failover Hot Standby / Streaming replication Wissem <kiwan2005@gmail.com>
2012-02-13 07:37 ` 杨晓青 <xqy1522@gmail.com>
2012-02-27 10:17 ` Wissem <kiwan2005@gmail.com>
2012-02-27 11:39 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:07 ` Wissem <kiwan2005@gmail.com>
2012-02-27 12:24 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 12:39 ` Wissem <kiwan2005@gmail.com>
2012-02-27 12:42 ` Wissem <kiwan2005@gmail.com>
2012-02-27 12:53 ` Wissem <kiwan2005@gmail.com>
2012-02-27 13:06 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2012-02-27 14:33 ` Wissem <kiwan2005@gmail.com>
2012-02-27 14:33 ` Lennin Caro <lennin.caro@yahoo.com>
2012-02-27 14:30 ` Lennin Caro <lennin.caro@yahoo.com>
2012-02-13 12:06 ` Devrim GÜNDÜZ <devrim@gunduz.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox