[Pgpool-general] problem with replication

[Cristina Bulfon]

Ciao,

it solved, using the command

pcp_attach_node

in this way I've attached backend1 in the pool and everything works.

Thanks

cristina




On Sep 26, 2011, at 11:01 AM, Cristina Bulfon wrote:

> Hello,
>
> thanks for the answer.
> I don't have the file pgpool_status and yes, backend1 can receive  
> connection from pgpool node, just for testing the authentication  
> method (at the moment) is "trust"
>
> ciao
>
> cristina
>
> On Sep 23, 2011, at 4:10 PM, Lazaro Rubén García Martinez wrote:
>
>> Pgpool, saves the status node in pgpool_status file, for example if  
>> you stop one  PostgreSQL node manually and pgpool performs a health  
>> check and detects that this node is down, the result is saved in  
>> pgpool_status for preventing future replication problems, but if  
>> you start the backend manually, this continues down for pgpool, if  
>> you are sure that the two servers are sync, you can stop pgpool,  
>> delete pgpool_status and start up pgpool again, in other way you  
>> can stop backend1 and perform and online recovery with pgpool.
>>
>> Other options, can backend1 receive connections from pgpool?? Is  
>> there any rule in pg_hba.conf of backend1 for allows pgpool connect  
>> to it? What is the authentication method used??
>>
>>
>> Regards.
>>
>> -----Mensaje original-----
>> De: pgpool-general-bounces at pgfoundry.org [mailto:pgpool-general-bounces at pgfoundry.org 
>> ] En nombre de Cristina Bulfon
>> Enviado el: viernes, 23 de septiembre de 2011 08:58
>> Para: pgpool-general at pgfoundry.org
>> Asunto: [Pgpool-general] problem with replication
>>
>> Hello,
>>
>> I have the following layout,
>>
>> - one computer is running pgpool-II-3.10 and postgresql 8.4.7-1
>> (backend 0)
>> - one computer running postgresql 8.4.7-1 (backend 1)
>>
>> I have used the pgpool.conf.sample.replication for my set up and if I
>> try to create both the DB's user  and the database (using port  
>> 9999) I
>> don't see the replication on both backends.
>> I also try to see the pcp comunication and the backend1 seems to be
>> down even if postgres is running on this node.
>>
>> Any help is appreciate.
>>
>> Thanks
>>
>> cristina
>>
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>