Re: Upgrade Process

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