Re: Upgrade from 8.4 to 9.4.1

From: s d <daku(dot)sandor(at)gmail(dot)com>
To: John Gage <jsmgage(at)gmail(dot)com>
Cc: PGSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Upgrade from 8.4 to 9.4.1
Date: 2015-02-20 20:08:45
Message-ID: CAKyoTgb+j8c5WGBgLnNNRt0a_7heYU883kHzAqvmk02O6pJw-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)gmail(dot)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
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lacey Powers 2015-02-21 18:02:37 Re: Hash function
Previous Message John Gage 2015-02-20 19:20:39 Upgrade from 8.4 to 9.4.1