pg_upgrade with postgis

[Ronit Allen]

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

[Bruce Momjian]

Post by Ronit Allen
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 <***@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

[Ronit Allen]

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.

Post by Bruce Momjian

Post by Ronit Allen
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.
--
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +

[Bruce Momjian]

Post by Ronit Allen
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.

---------------------------------------------------------------------------

Post by Ronit Allen
Thanks again.

Post by Ronit Allen
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.
--
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +

--
Bruce Momjian <***@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +