Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46082=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cCp2A-0005Cf-4s
	for pgsql-admin@arkaria.postgresql.org; Fri, 02 Dec 2016 14:41:54 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46082=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cCp29-0001cu-J7
	for pgsql-admin@arkaria.postgresql.org; Fri, 02 Dec 2016 14:41:53 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <peter.eisentraut@2ndquadrant.com>)
	id 1cCp29-0001cn-4P
	for pgsql-admin@postgresql.org; Fri, 02 Dec 2016 14:41:53 +0000
Received: from out5-smtp.messagingengine.com ([66.111.4.29])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <peter.eisentraut@2ndquadrant.com>)
	id 1cCp21-00025V-T3
	for pgsql-admin@postgresql.org; Fri, 02 Dec 2016 14:41:52 +0000
Received: from compute7.internal (compute7.nyi.internal [10.202.2.47])
	by mailout.nyi.internal (Postfix) with ESMTP id 9C48F20911;
	Fri,  2 Dec 2016 09:41:43 -0500 (EST)
Received: from frontend2 ([10.202.2.161])
  by compute7.internal (MEProxy); Fri, 02 Dec 2016 09:41:43 -0500
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=
	messagingengine.com; h=content-transfer-encoding:content-type
	:date:from:in-reply-to:message-id:mime-version:references
	:subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s=
	smtpout; bh=EeSZ8mSoGq8x+p6KJEcH3RWnYgQ=; b=bKmmmVw5aQ1mWs374VPt
	3zUQPdxnm6nvGuqvhZlmU42yhxvpD5EC6QGIFWaBXtxRVXsbDyuVKglhnVDjJm2d
	srJQL3GWFQH41cs7o0lzNylesBpxOVaQD1isIH9ZWyTE2R3nYZEE1vRDvR5Yd0of
	J3EJHFNnKQ+y7HGt5KS41+o=
X-ME-Sender: <xms:J4hBWN0XwP4m59OmHagRPq094G-XqoZtC_fq3owhUGthrS6aREB7QQ>
X-Sasl-enc: sI5g5s4NFloY1NgWlEb2pUHfyDWNtzfFThRXZVe6+nfl 1480689703
Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39])
	by mail.messagingengine.com (Postfix) with ESMTPA id 41C2E24752;
	Fri,  2 Dec 2016 09:41:43 -0500 (EST)
Subject: Re: restoring 9.3 dump file to 9.6
To: rajan <vgmonnet@gmail.com>, pgsql-admin@postgresql.org
References: <1480663651108-5932944.post@n3.nabble.com>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <e371d05a-c4c2-9095-f392-e20994e1e0f2@2ndquadrant.com>
Date: Fri, 2 Dec 2016 09:41:47 -0500
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:45.0)
 Gecko/20100101 Thunderbird/45.5.0
MIME-Version: 1.0
In-Reply-To: <1480663651108-5932944.post@n3.nabble.com>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 12/2/16 2:27 AM, rajan wrote:
> I have a dump created from pg 9.3. Will there be any difficulties in
> restoring that dump file to 9.6?

The recommended way is to use the pg_dump from 9.6 to dump from the 9.3
server.  Then it should work.

If you use the pg_dump from 9.3, there might be minor problems.  It's
best to try it out first.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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