Jim Nasby <jim@xxxxxxxxx> wrote: > If you setup some form of replication it's very easy to move to > larger servers as you grow. I'm sure that when Kevin moved their > database it was a complete non-event. Yeah, replication was turned on for the new server in addition to the old one. When everything was ready the web application configuration was updates so that it started using the new server for new requests and disconnected from the old server as requests completed. Zero down time. No user-visible impact, other than things ran a little faster because of the better hardware. One generation of old hardware is kept in replication for running ad hoc queries and to provide availability in case the new one crashes. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
