[Pgcluster-general] config rsync ?
mitani at sraw.co.jp
mitani at sraw.co.jp
Fri Jun 12 15:26:48 UTC 2009
Hi Dan,
>1) How does pgcluster knows which is the data directory on 'master' server ?
> (on which informations is the rsync command build from? I could not find any path configuration in cluster.conf
>for 'rsync paths')
The 1st cluster DB in cluster table on replication server is the first master server.
If the first master server was failed, the second cluster DB become master server.
>
>2) are tablespace directorys need to be rsynct as well? or will the recovering database only uses WAL file entries to
>recover?
Tablespace directory also need to rsync at recovery.
>
>2) if 2 = yes, does pgcluster expect that all tablespaces are placed in the postgres data directory structure?
No. But it need to placed on local disk.
>
>3) if 2 = yes, does rsync work if tablespaces are placed on moutpoints outside postgres data directory tree?
I've never tried it.
Probably, it depends on the data file structure during each servers.
>4) if 2 = yes, how to configre cluster.conf to rsync those tablespace directories outside posgres data structure if
>needet?
It can get tablespace directory path from DB it self.
Therefore there is no need to describe it in config file.
Regards,
------------------------
At.Mitani
More information about the Pgcluster-general
mailing list