Search Postgresql Archives

Re: Upgrading Database: need to dump and restore?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 2009-06-03, Carlos Oliva <carlos@xxxxxxxxxxx> wrote:
> Woudl it be possible to keep the current postgresql version running in a 
> different port, install a new version of postgresql, and copy the data from 
> one version to the other while both versions are running?  This might give 
> us time to copy the tables and databases one at a time and reconfigure the 
> database access for parts of the application until we complete the migration 
> to the new version.

Yes that's possible. The debian packaged versions since 8.0 are
designed to facilitate multiple clusters on a single host, and if you
install two major versions of postgres it'll automatically set them up
for you using port 5433 for the new version.

On redhat it may not be so easy.



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux