Subject: Re: [SQL] PostgreSQL 9.3 DB initialization issue
To: Steve Midgley <science@misuse.org>
Cc: Ashish Tiwari <tashish786@gmail.com>, pgsql-admin@postgresql.org,
 postgres list <pgsql-sql@postgresql.org>
References: 
 <CAH8UkmHAE=EKjjok+GeNq_zei=kne+i=kHAS9nUyO6YZcamfXg@mail.gmail.com>
 <a903b9af-4942-26d8-af15-1e4b7e754848@aklaver.com>
 <CAH8UkmHUiAzdrOaWfe4XHAMcCVkCVgB0kL=XBriJwePYu2R4=g@mail.gmail.com>
 <CAH8UkmGgQcqAkQFF83gsL1fADVVM+1k4vn6nBfYAMsH27x9+aw@mail.gmail.com>
 <CAH8UkmGNKv3-2e8e6D7y3FME5MdhV1fKO0RrU6q3w3MpazzTgA@mail.gmail.com>
 <CAH8UkmFrihRfL4AyrgSpJ-uAdRFz_Jcoe2RiL_x+wr3yJMabyA@mail.gmail.com>
 <CAH8UkmGMZzEB_AL8uTovaRb0DDOD+G5zDcF26JFpXP2bf3CNng@mail.gmail.com>
 <CAH8UkmF8ECHn1D2Jf-1S8PXZF1Ba8ih1dqhZJjU8-z4+KB2vdg@mail.gmail.com>
 <9e6bc162-5082-fd56-fab0-152989e4c002@aklaver.com>
 <CAH8UkmFPO6SEDdNyextO79_S2um5SCVD5gchYx=vhKY8zhjbnQ@mail.gmail.com>
 <CAH8UkmHUnDHMAdBZLOo1zuKQMbpwxp+7MOWfZFio6VDO9zkmbw@mail.gmail.com>
 <727a25d0-00ab-15c3-9eff-1ec7b8e3588f@aklaver.com>
 <CAJexoSJKoN9vQyFSKqOgR+3_xv86tWVa91ZEcmK831B2ZmYtAg@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <79f8f2b6-f78c-f5a9-1a90-e757d1311dcd@aklaver.com>
Date: Sat, 13 May 2017 15:26:56 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.1.0
MIME-Version: 1.0
In-Reply-To: 
 <CAJexoSJKoN9vQyFSKqOgR+3_xv86tWVa91ZEcmK831B2ZmYtAg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 05/13/2017 02:50 PM, Steve Midgley wrote:
> 
> 

> 
> I am by no means an expert on any of this, but Adrian, I think you have 
> a typo in your instructions? Should it read:
> 
>   "use the *[9.2]* pg_dumpall to dump the 9.2 data and then the 9.3 
> pg_restore to restore it into the 9.3 instance." (in the original it 
> said [9.3] where my brackets are).
> 
> I think you meant to say that v 9.2 server binary should be used to call 
> pg_dumpall (and run against the v9.2 running server instance), and then 
> the resulting dump file can be read into the 9.3 server by using the 
> v9.3 binary for pg_restore. The pg_restore (v9.3) command will operate 
> using source files created by pg_dumpall, and load that into 9.3 running 
> server instance.

Well pg_dump(all) is backwards compatible, so the 9.3 version can dump 
Postgres versions going back to 7.0. I have always been told that using 
the newer binary against an older server is better as it will 'know' 
about changes in the newer version:

https://www.postgresql.org/docs/9.3/static/upgrading.html

17.6.1. Upgrading Data via pg_dump

"It is recommended that you use the pg_dump and pg_dumpall programs from 
the newer version of PostgreSQL, to take advantage of enhancements that 
might have been made in these programs. Current releases of the dump 
programs can read data from any server version back to 7.0."

That being said, given that it is only a single version jump using the 
9.2 version of pg_dump(all) will most likely work without a hitch.

> 
> If I'm wrong about this, please correct me. But given the context of 
> debugging on this email thread, it seemed like I should point this 
> (possible) typo out, so there was no ambiguity for Ashish and his team.
> 
> Steve


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin