Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Wissem
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 杨晓青

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Matheus de Oliveira
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 Des

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Wissem
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 > Wissem, > > Execute the command: > > $ p

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Matheus de Oliveira
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 -

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Wissem
Hi, I already have postgresql 9.1 server installed on this server. 2012/2/27 Matheus de Oliveira > 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. > > > R

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Wissem
I installed the missing package and I have; pgpool -v pgpool-II version 3.1 (hatsuiboshi) 2012/2/27 Matheus de Oliveira > 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 r

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Wissem
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 > I installed the missing package and I have; > > pgpool -v > pgpool-II version 3.1 (hatsuiboshi) > > > > > 2012/2/27 Matheus de Oliveira > >> You have to install the p

[ADMIN] Large amount of postgres processes

2012-02-27 Thread Lukasz Brodziak
Hello, I have a question regarding the way PG runs on Windows machines. I have PG 9.0 installed on Windows 2008 Server Standard. When it runs without any traffic I have 6 postgres.exe processes running. When I run software which connects to the DB on local host I have 7 (so +1 that I can understan

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Lennin Caro
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 wrote: From: Wissem Subject: Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication To: "杨晓青" Cc: pg

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Wissem
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 autom

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

2012-02-27 Thread Lennin Caro
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 libre