> > If you're going to run slony, then the pg_dump|pg_restore step is > > completely wasted. Slony will restore all the data again. You do > > need to run pg_dump -s, of course. Thanks to everyone who replied. We have no experience with this "Slony". Any simple instructions on installing it and getting it working? Why is PG so complex! It's a such a lovely database. If only at least the installation and upgrade could be made more humane..