pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
how to upgrade from 8.4 to 9.2 2+ messages / 2 participants [nested] [flat]
* how to upgrade from 8.4 to 9.2 @ 2016-11-29 15:57 Marc Fromm <Marc.Fromm@wwu.edu> 0 siblings, 1 reply; 2+ messages in thread From: Marc Fromm @ 2016-11-29 15:57 UTC (permalink / raw) To: pgsql-admin To be compatible with my live server I need to upgrade postgresql v8.4 running on a CentOS6.4 server to postgresql v9.2. Is there a step by step procedure on this so that I properly remove 8.4, install 9.2 and have it work with PHP? Will CentOS6.4 support the newer version of postgreslq with yum updates or do I have to upgrade to CentOS7? I already downloaded pgdg-centos92-9.2-8.noarch.rpm for CentOS6.4 from https://yum.postgresql.org/repopackages.php#pg92. Thanks Marc ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how to upgrade from 8.4 to 9.2 @ 2016-11-30 07:32 Achilleas Mantzios <achill@matrix.gatewaynet.com> parent: Marc Fromm <Marc.Fromm@wwu.edu> 0 siblings, 0 replies; 2+ messages in thread From: Achilleas Mantzios @ 2016-11-30 07:32 UTC (permalink / raw) To: pgsql-admin On 29/11/2016 17:57, Marc Fromm wrote: > > To be compatible with my live server I need to upgrade postgresql v8.4 running on a CentOS6.4 server to postgresql v9.2. Is there a step by step procedure on this so that I properly remove 8.4, > install 9.2 and have it work with PHP? Will CentOS6.4 support the newer version of postgreslq with yum updates or do I have to upgrade to CentOS7? > I'd say look at pg_upgrade and also make a lot of tests. Plan and test your final upgrade. I have no experience with CentOS, I never use package managers for PostgreSQL, always compile from source. The idea is to have the old binaries and the new binaries and then perform pg_upgrade. Pg_upgrade will guide you through. > I already downloaded pgdg-centos92-9.2-8.noarch.rpm for CentOS6.4 from https://yum.postgresql.org/repopackages.php#pg92. > > Thanks > > Marc > -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-11-30 07:32 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-11-29 15:57 how to upgrade from 8.4 to 9.2 Marc Fromm <Marc.Fromm@wwu.edu> 2016-11-30 07:32 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
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