Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YB3Ua-0007gR-M4 for pgsql-admin@arkaria.postgresql.org; Tue, 13 Jan 2015 15:34:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YB3UZ-00071z-Mb for pgsql-admin@arkaria.postgresql.org; Tue, 13 Jan 2015 15:34:51 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YB3UY-00071s-8a for pgsql-admin@postgresql.org; Tue, 13 Jan 2015 15:34:50 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YB3UU-00021c-Ry for pgsql-admin@postgresql.org; Tue, 13 Jan 2015 15:34:48 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 884DD5F795; Tue, 13 Jan 2015 10:34:45 -0500 (EST) Date: Tue, 13 Jan 2015 10:34:45 -0500 From: Stephen Frost To: Tom Lane Cc: Ray Stell , "pgsql-admin@postgresql.org" Subject: Re: 9.4 pg_dump use on 9.0 db Message-ID: <20150113153445.GQ3062@tamriel.snowman.net> References: <54B52E9B.8020208@vt.edu> <11235.1421162639@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="QH34jsn7N6yilgV0" Content-Disposition: inline In-Reply-To: <11235.1421162639@sss.pgh.pa.us> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-40-generic (x86_64) X-Uptime: 10:31:28 up 24 days, 19:11, 11 users, load average: 0.05, 0.07, 0.05 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --QH34jsn7N6yilgV0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Tom Lane (tgl@sss.pgh.pa.us) wrote: > Ray Stell writes: > > Is it valid to dump a 9.0 db with a 9.4 pg_dump and make use of the=20 > > parallel feature? TIA. >=20 > Yes, but be aware that 9.4 pg_dump will be generating output meant to > be loaded into a 9.4 server. You might have to make some adjustments > if you mean to reload it into 9.0. Also be aware that you won't get a synchronized snapshot and therefore the resulting dump might not be valid.. Looking at pg_dump, for my 2c anyway, it'd be nicer if we threw an error on parallel dump request when the major version doesn't support synchronized snapshots, unless the user explicitly passed --no-synchronized-snapshots, indicating that they don't care. Thanks, Stephen --QH34jsn7N6yilgV0 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJUtTsVAAoJEO1sijiDR2RV7WAQAKDTcX0+n2DCryllbsswdt2E 6IrAiLonyJwvdyVmkyC7ycc9VMa3R972u4gpkY/x3eyPU2lsFFpLUbH9H5WGnkUt IPsJiK2j7+EUcRh/1+WvJ/AhFUhRdX7AM1i88VsPkuw63vUrQn0SVPt2bdFkjKhs wYbaSdvul+snPd0JgCyYyjFnGZXC+myR13t8IhRkUTfDOVLHZ+xUyDkiWCKpy9Gl 3xcRMQtZ2gLDSs4GgCFGaJBTXUY9RdZeDBZtai3o+YPuZQADF3nbZs/hye5cU15h 0ICC5KCZAsCtjdaUNRJhlvvizTWhrOJVFq/TS7o0m8ZBPacG8fSZ1hOE7iFgDFqX IgFPsEkOgNSALjtq+CPYF9eTOPlCuCYF+O3TZHFS4cC0mVUkkH8vSGSwGuNm7cD2 hxlvJri6HZd7o9IWHnT1DnJm37i+P2DqK09HviAO39ESxp13XjHHtnKfJwqBTH9Y YIBm2Ymi7xx0dKKOGtvzkeIjj+GubTFiwBPBz+69Q4q9ittDxPnzrul5EgpgEIm6 ENCQh4S4suYWL4qmCv5PKPnLV67A4vp4Cek6M4vcXzTgE+0PxcT1pA6pFwvIiCOp bp2Anr/8K2uE+k4G44VqL7hLz9qjid/w3xcxImB3zXrf0IV6C99YMPe7ux8YJVrX SN2r4MS/Gq731YAxmN6V =d0rG -----END PGP SIGNATURE----- --QH34jsn7N6yilgV0--