Skip site navigation (1) Skip section navigation (2)

Re: Upgrade Process

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrade Process
Date: 2007-04-26 21:47:29
Message-ID: Pine.LNX.4.64.0704261446070.22303@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, 26 Apr 2007, Adrian Klaver wrote:

> Generally it is a better idea to dump the old version with the new
> versions pg_dump,pg_dumpall commands. The new versions know more about the
> old versions of the database than the other way around.

Hi, Adrian!

   I wondered about this.

> I generally copy the old version (while it is shutdown) to another
> directory and then install the new version. I modify the postgresql.conf
> in the directory containing the old version so that Postgres listens on a
> different port and start it up. I can then use the pg_dump(all) commands
> from the new version to pull from the old version. The catch is that you
> need enough room for both copies of the database.

   OK. I'll do this.

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

In response to

pgsql-general by date

Next:From: Steve CrawfordDate: 2007-04-26 22:36:35
Subject: Processing a work queue
Previous:From: Thomas F. O'ConnellDate: 2007-04-26 21:21:30
Subject: NFS vs. PostgreSQL on Solaris

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group