Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TBYlo-0000Da-7g for pgsql-admin@postgresql.org; Tue, 11 Sep 2012 22:17:24 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TBYll-0007QZ-K5 for pgsql-admin@postgresql.org; Tue, 11 Sep 2012 22:17:23 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1TBYlj-0007XH-7Y; Tue, 11 Sep 2012 18:17:19 -0400 Date: Tue, 11 Sep 2012 18:17:19 -0400 From: Bruce Momjian To: Ronit Allen Cc: pgsql-admin@postgresql.org Subject: Re: pg_upgrade with postgis Message-ID: <20120911221719.GA7039@momjian.us> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201209/46 X-Sequence-Number: 39987 On Tue, Sep 11, 2012 at 04:15:31PM +0300, Ronit Allen wrote: > HI - > > I am looking to upgrade our postgresql 9 to 9,2 using pg_upgrade. > > We have postgis installed on the current cluster (9). > > Both postgresql and postgis was installed using the pg repos. > > Will I need to re-install postgis after running pg_upgrade? You will need to have all plug-in stuff installed in the new cluster before running pg_upgrade. You should then be able to run pg_upgrade and all your postgis data will be migrated. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +