Filip Rembiałkowski wrote:
2009/8/26 Asaf <[email protected] <mailto:[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
I did that, replication didn't work, so I thought the pg_dumpall is not
good enough for this,
when something don't work, how can I get more details from pgpool (i
didn't see errors, and it said he had 2 backends)
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.
I've tried slony, but it requires alot of maintainece,
I'm looking for something completely transparent to users,
such as mysql replication, pgpool seemed to do the job
--
Filip Rembiałkowski
JID,mailto:[email protected]
<mailto:[email protected]>
http://filip.rembialkowski.net/
--
Asaf Ohaion
Lingnu Open Source Consulting Ltd
09-7655871 (204), 0502-565023
http://www.lingnu.com
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
