[Pgcluster-general] rsync error ?

DANIEL CRISTIAN CRUZ daniel.cruz at sc.senai.br
Fri Jun 12 16:59:16 UTC 2009


Mitani,

Could be possible to do an rsync using only 2 servers and a snapshot
filesystem (like LVM or XFS) with no locking?

Regards.

mitani at sraw.co.jp escreveu:
> Hi Dan,
> 
> During 1st rsync phase, the load?balancer do not block any session to
master
> DB.
> And during 2nd rsync phase, the load?balancer block all sessions to master
DB 
> in order to sync completely between master DB and target DB.
> 
> During 2nd rsync phase, load?balancer can receive any sessions.
> If you have more than 3 cluster DBs, the system can continue to provide
service
> even in 2nd rsync phase.
> All receiving queries are recorded in the replication server during 2nd
rsync
> phase.
> Those queries are executed to master DB and target DB after finished 2nd
> rsync.
> 
>>Start in recovery mode!
>>Please wait until a data synchronization finishes from Master DB...
>>1st recovery step of [global] directory...OK
>>1st recovery step of [base] directory...OK
>>1st recovery step of [pg_clog] directory...OK
>>1st recovery step of [pg_xlog] directory...NG
> 
> Please check permission and owner of pg_xlog directory.
> 
> Regards,
> ------------------------
> At.Mitani
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
> 

--
<span style="color: #000080">Daniel Cristian Cruz
</span>Administrador de Banco de Dados
Direção Regional - Núcleo de Tecnologia da Informação
SENAI - SC
Telefone: 48-3239-1422 (ramal 1422)





More information about the Pgcluster-general mailing list