[Pgpool-general] replication between 32 bit and 64 bit server

[Filip Rembiałkowski]

2009/8/26 Asaf <asaf at lingnu.com>

> is it possible to establish replication between 32 bit and 64 bit server
>
> yes, sure.


(say pgpool-II on 32 bit node along with 1 postgresql, replicating to 64 bit
> secondary server)
>
>
> if this is possible, how can I initialize the replication for existing data
> ?




> (how to make the initial synchronization?)
>

with dump and restore.

instead of using rsync or tar,
use pg_dumpall (for all databases) or pg_dump (for one database) and restore
the dump on second machine with psql and/or pg_restore.

pg_dumpall  | psql -h othermachine postgres

see Backup section in the docs:
http://www.postgresql.org/docs/current/static/backup.html


PS. I would rather not use pgpool for replication - it adds some
limitations/gotchas (think of volatile functions like random or
current_timestamp).
I'd use pgpool only for LB and pooling - and leave replication to slony or
skytools.


-- 
Filip Rembiałkowski
JID,mailto:filip.rembialkowski at gmail.com
http://filip.rembialkowski.net/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090826/f78b00d8/attachment.html>