pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Steve Midgley <science@misuse.org>
Cc: Ashish Tiwari <tashish786@gmail.com>
Cc: pgsql-admin@postgresql.org, postgres list <pgsql-sql@postgresql.org>
Subject: Re: [SQL] PostgreSQL 9.3 DB initialization issue
Date: Sat, 13 May 2017 15:26:56 -0700
Message-ID: <79f8f2b6-f78c-f5a9-1a90-e757d1311dcd@aklaver.com> (raw)
In-Reply-To: <CAJexoSJKoN9vQyFSKqOgR+3_xv86tWVa91ZEcmK831B2ZmYtAg@mail.gmail.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

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



view thread (10+ messages)

Message-ID: <79f8f2b6-f78c-f5a9-1a90-e757d1311dcd@aklaver.com>
Permalink:  ../79f8f2b6-f78c-f5a9-1a90-e757d1311dcd@aklaver.com/
Also on:    postgresql.org/message-id/79f8f2b6-f78c-f5a9-1a90-e757d1311dcd@aklaver.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: adrian.klaver@aklaver.com, science@misuse.org, tashish786@gmail.com
  Subject: Re: [SQL] PostgreSQL 9.3 DB initialization issue
  In-Reply-To: <79f8f2b6-f78c-f5a9-1a90-e757d1311dcd@aklaver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox