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.
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.
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 Crawford||Date: 2007-04-26 22:36:35|
|Subject: Processing a work queue|
|Previous:||From: Thomas F. O'Connell||Date: 2007-04-26 21:21:30|
|Subject: NFS vs. PostgreSQL on Solaris|