[Pgpool-general] replicating from a 64 bit server to a 32 bit server.

[Gerd König]

Hi Tim,

Tim Uckun schrieb:
> 
> 
>     As far as I know, you can't copy/rsync the base directory and the
>     logs, use PITR and expect them to work, as they are
>     architecture-dependant. I am not 100% sure, though. So my answer would
>     be that you will be able to replicate data through pgpool-II but not
>     do online recovery.
> 
> 
> So pgpool copies the files over directly?
To set up pgpool, yes.
At this step you have to rsync/pack_and_copy/.. the db files from node1 to
node2. This is only one step included in "online recovery".
Please check the doc at the project homepage
(http://pgpool.projects.postgresql.org/) to get all the details about online
recovery.

Afterwards pgpool connects to each db backend and executes the sql statements
there, thereby no further file copy is needed.

regards....GERD....