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