2009/8/26 Asaf <[email protected]> > 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:[email protected] http://filip.rembialkowski.net/
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
