From: Bruce Momjian <bruce@momjian.us>
To: Ronit Allen <ronit.allen@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_upgrade with postgis
Date: Thu, 13 Sep 2012 00:02:44 -0400
Message-ID: <20120913040244.GA18423@momjian.us> (raw)
In-Reply-To: <CABP1cDNFgk9bHpq9GFaWx_KShZTSKQrodamjhTvWBwCpazHFnA@mail.gmail.com>
References: <CABP1cDM0Jqi80yKPK4h1dvHRrYt2vckgeMpjvBw+-o7eCNKqSg@mail.gmail.com>
<20120911221719.GA7039@momjian.us>
<CABP1cDNFgk9bHpq9GFaWx_KShZTSKQrodamjhTvWBwCpazHFnA@mail.gmail.com>
On Thu, Sep 13, 2012 at 02:12:40AM +0300, Ronit Allen wrote:
> Hi -
>
> Thanks.
> As we installed using pg repos (yum) I don't think it will allow me to
> re-install postgis.
> Is it possible to specify a target cluster for a postgis install from repo or
> will it need to be installed from source?
You just need to have a valid data directory and binaries --- you don't
need source.
---------------------------------------------------------------------------
> Thanks again.
> On Wed, Sep 12, 2012 at 1:17 AM, Bruce Momjian <bruce@momjian.us> wrote:
>
> 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 <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
>
>
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
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-admin@postgresql.org
Cc: bruce@momjian.us, ronit.allen@gmail.com
Subject: Re: pg_upgrade with postgis
In-Reply-To: <20120913040244.GA18423@momjian.us>
* 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