Re: Upgrading Database: need to dump and restore?

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: "Carlos Oliva" <carlos(at)pbsinet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading Database: need to dump and restore?
Date: 2009-06-03 20:18:17
Message-ID: 20090603161817.131e706e.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to "Carlos Oliva" <carlos(at)pbsinet(dot)com>:

> Can the synchronization with Slony run while the old database is still being
> updated daily? I am wondering if we can just let Slony run until the
> databases are fully synchronized and then switch databases.

Yes, and yes. That's exactly what Slony is for.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Bruce - Postgres 2009-06-03 20:20:01 Re: High I/O writes activity on disks causing images on browser to lag and not load
Previous Message Joshua D. Drake 2009-06-03 20:14:13 Re: warm standby with WAL shipping