Hi, I'd like to replicate my production database to 2 separate Postgres instances --- one for reporting and one for staging. The main requirement is that the data needs be current up to the state of the production db the day before.
>From what I've read it seems like using an asynchronous replication solution (i.e. slony) or just a simple pg_dump/pg_restore script would work. Ideally I'd like to have as little additional load on the production server as possible. Also, the production db is currently at 12GB (and growing steadily), so I'm a bit concerned that doing a full pg_restore every day might become infeasible at some point. Any thoughts? Thanks, Ryan
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
