Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fo4ZD-0004li-Pv for pgsql-admin@arkaria.postgresql.org; Fri, 10 Aug 2018 10:22:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fo4Z9-0004Bq-Tu for pgsql-admin@arkaria.postgresql.org; Fri, 10 Aug 2018 10:22:43 +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.89) (envelope-from ) id 1fo4Z9-0004Bj-Mn for pgsql-admin@lists.postgresql.org; Fri, 10 Aug 2018 10:22:43 +0000 Received: from tamriel.snowman.net ([96.255.250.162]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fo4Z6-0002sL-Cw for pgsql-admin@postgresql.org; Fri, 10 Aug 2018 10:22:42 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 81B995F79C; Fri, 10 Aug 2018 06:22:38 -0400 (EDT) Date: Fri, 10 Aug 2018 06:22:38 -0400 From: Stephen Frost To: "Cogan, Mark Contractor, NRL Code 3030" Cc: "pgsql-admin@postgresql.org" Subject: Re: pg_upgrade doesn't work? Message-ID: <20180810102238.GG3326@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="IbVRjBtIbJdbeK1C" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --IbVRjBtIbJdbeK1C Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Cogan, Mark Contractor, NRL Code 3030 (mark.cogan.ctr@nrl.navy.mil) wrot= e: > So why does the documentation tell me that I should use the pg_upgrade > command to migrate my 8.4.20 db to 9.6, but when I run the command it tel= ls > me that the major version is different so it won't run? Is there some ki= nd > of issue with the location of the execution binary? =20 Having the exact error messgaes would be really helpful. You're sure that you are using the pg_upgrade from 9.6? Note that to perform a pg_upgrade you have to have the binaries for *both* versions installed on to the system and then pg_upgrade will perform a copy of the data files or will create hard-links between the old and new data directories. Thanks! Stephen --IbVRjBtIbJdbeK1C Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJbbWduAAoJEO1sijiDR2RVvp0P/j6CiZ9w7DjGWaJpEWaRzmAo P3/1p+Si7JoGidDv2QSsusKqGvTykh71pZv8uqhQh7vL9eQ74ssmElOPJ6OEtzhI NnVHkuUSm1Fdkk0CejWGZ6r9KxPse8FIZacEeDd2ugxjMC5x7Qc+KILjqpiOjIrS 7qjlB4naRSUThLeb6p063gIOGjO22BvYZJUkDW0azyHWlecdFhTkd7PgBHJ6mMe6 xDM7goU14y8qTh9Tvp/cKZC0Gps78PGWGjwfEYweQ76ARupIW9VWFmQeGa81OAkV B1nuHNU3e+c7xnTKcXGF3H8yGupt6s8/qimzrwXxzycwAlDEmU83jH8lb0OM9Fg6 f+Ca9K0hZ9Cd20h3/BmFoa9+Y+ctEFr3lCrDoi5DalwLkvFVPOnpmDqEcxlnltP/ xS1YscQDIppNXY0d0NVAJKv/R/iy7fB4ihQeJrwq0rU3WWf4Ocn50c328cnZdddK unUnyYYIYUpkWDYWHKs81irRrPRZEpFEJDzkITvKxREb6e+UvshhEtsqxaXXEff5 6SkfWaRI0GrLLhtWRX8xdTJt6s/jfHooto7Buq3jBbYaZhV4dUb3R49qdpFbXV1a mIsTxfCNan2LRU9GD9R7fpEgl8Or7kEKijpd8GlKiA+4GeG1CFXOYVpE3Y43dDpz zhcR0HNL+wfdCYKArKOG =d4Jt -----END PGP SIGNATURE----- --IbVRjBtIbJdbeK1C--