Обсуждение: HOW TO UPGRADE POSTGRES 7.2 TO 7.3 IN RPM FORMAT
Hi. i need upgrade postgres 7.2.4 to 7.3.2 ... i have a bineries rpm of two version and i have installed in my server 7.2.3... how to migrate this ???? thank you mario
You should backup your database first with pg_dump, then try upgrading with rpm -Fvh <PostgreSQL RPM package>. As for the column types and other things that may have changed you will probably have to perform your own validation that things still work as expected. Thanks. --- Mario Alberto Soto Cordones <mario_soto@compuall.cl> wrote: > Hi. > > i need upgrade postgres 7.2.4 to 7.3.2 ... > > i have a bineries rpm of two version and i have > installed in my server > 7.2.3... how to migrate this ???? > > > thank you > > mario > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com
Is it necessary to uninstall previous version of Postgres on my system to upgrade with Postgres 7.2.3 Can any body give URL where Postgres 7.2.3 RPMs available. Regards, Sreedhar ----- Original Message ----- From: "P G" <pg_dba@yahoo.com> To: "Mario Alberto Soto Cordones" <mario_soto@compuall.cl>; <pgsql-admin@postgresql.org> Sent: Saturday, March 22, 2003 7:56 AM Subject: Re: [ADMIN] HOW TO UPGRADE POSTGRES 7.2 TO 7.3 IN RPM FORMAT > You should backup your database first with pg_dump, > then try upgrading with rpm -Fvh <PostgreSQL RPM > package>. As for the column types and other things > that may have changed you will probably have to > perform your own validation that things still work as > expected. > > Thanks. > > --- Mario Alberto Soto Cordones > <mario_soto@compuall.cl> wrote: > > Hi. > > > > i need upgrade postgres 7.2.4 to 7.3.2 ... > > > > i have a bineries rpm of two version and i have > > installed in my server > > 7.2.3... how to migrate this ???? > > > > > > thank you > > > > mario > > > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! > http://platinum.yahoo.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
Just go to the download area at www.postgresql.org Thanks. --- shreedhar <shreedhar@lucidindia.net> wrote: > Is it necessary to uninstall previous version of > Postgres on my system to > upgrade with Postgres 7.2.3 > Can any body give URL where Postgres 7.2.3 RPMs > available. > > Regards, > Sreedhar > > ----- Original Message ----- > From: "P G" <pg_dba@yahoo.com> > To: "Mario Alberto Soto Cordones" > <mario_soto@compuall.cl>; > <pgsql-admin@postgresql.org> > Sent: Saturday, March 22, 2003 7:56 AM > Subject: Re: [ADMIN] HOW TO UPGRADE POSTGRES 7.2 TO > 7.3 IN RPM FORMAT > > > > You should backup your database first with > pg_dump, > > then try upgrading with rpm -Fvh <PostgreSQL RPM > > package>. As for the column types and other > things > > that may have changed you will probably have to > > perform your own validation that things still work > as > > expected. > > > > Thanks. > > > > --- Mario Alberto Soto Cordones > > <mario_soto@compuall.cl> wrote: > > > Hi. > > > > > > i need upgrade postgres 7.2.4 to 7.3.2 ... > > > > > > i have a bineries rpm of two version and i have > > > installed in my server > > > 7.2.3... how to migrate this ???? > > > > > > > > > thank you > > > > > > mario > > > > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > TIP 4: Don't 'kill -9' the postmaster > > > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! Platinum - Watch CBS' NCAA March Madness, > live on your desktop! > > http://platinum.yahoo.com > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html __________________________________________________ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo http://search.yahoo.com