Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrade from 8.4 to 9.4.1 - Mailing list pgsql-novice

From s d
Subject Re: Upgrade from 8.4 to 9.4.1
Date
Msg-id CAKyoTgb+j8c5WGBgLnNNRt0a_7heYU883kHzAqvmk02O6pJw-g@mail.gmail.com
Whole thread Raw
In response to Upgrade from 8.4 to 9.4.1  (John Gage <jsmgage@gmail.com>)
List pgsql-novice
Tree view
Hi,

My guess you read two different sources with different aspects of the topic.
Of course you can use the new version's pg_dump only if you have both versions.
I have used the 8.4's pg_dump with the 9.3's pg_restore without any problem, though.
However, keep in mind there could be difference between major versions, which 
could affect your application.   

Regards,
Sándor Daku

On 20 February 2015 at 20:20, John Gage <jsmgage@gmail.com> wrote:
I am using a Mac with the latest operating system Yosemite.

The upgrade instructions I have found in the archive confuse me in one way:

I would like to upgrade to Postgres.App.  In their instructions they say,

"For best results, you should remove any existing installation of PostgreSQL. Here's a run-down of the most common ways you may have installed it previously:"

However, in the instructions on this list, it is recommended (strongly) to use the pg_dump contained in the version you wish to upgrade to to transfer your tables.

I do not understand how I can remove the existing installation with the mission-critical data it contains and use pg_dump from the new version to access that data.

I know I am missing something.  Please tell me what.

Thank you very much,

John Gage

pgsql-novice by date:

Previous
From: John Gage
Date:
Subject: Upgrade from 8.4 to 9.4.1
Next
From: Lacey Powers
Date:
Subject: Re: Hash function