pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgrade with postgis
4+ messages / 2 participants
[nested] [flat]
* pg_upgrade with postgis
@ 2012-09-11 13:15 Ronit Allen <ronit.allen@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Ronit Allen @ 2012-09-11 13:15 UTC (permalink / raw)
To: pgsql-admin
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?
Thanks for any guidance,
Ronit
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_upgrade with postgis
@ 2012-09-11 22:17 Bruce Momjian <bruce@momjian.us>
parent: Ronit Allen <ronit.allen@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2012-09-11 22:17 UTC (permalink / raw)
To: Ronit Allen <ronit.allen@gmail.com>; +Cc: pgsql-admin
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. +
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_upgrade with postgis
@ 2012-09-12 23:12 Ronit Allen <ronit.allen@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 4+ messages in thread
From: Ronit Allen @ 2012-09-12 23:12 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin
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?
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. +
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_upgrade with postgis
@ 2012-09-13 04:02 Bruce Momjian <bruce@momjian.us>
parent: Ronit Allen <ronit.allen@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2012-09-13 04:02 UTC (permalink / raw)
To: Ronit Allen <ronit.allen@gmail.com>; +Cc: pgsql-admin
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. +
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-09-13 04:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-09-11 13:15 pg_upgrade with postgis Ronit Allen <ronit.allen@gmail.com>
2012-09-11 22:17 ` Bruce Momjian <bruce@momjian.us>
2012-09-12 23:12 ` Ronit Allen <ronit.allen@gmail.com>
2012-09-13 04:02 ` Bruce Momjian <bruce@momjian.us>
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