Thread: UPGRADATION TO 8.1
Hi, In our company there are many postgres servers in 7.X version,we are in the process of upgrading to 8.1 version, can anyone tell me the method to do this upgradation. Regards J Mageshwara DBA ********** DISCLAIMER ********** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail & notify us immediately at admin@sifycorp.com Complete Coverage of the ICC World Cup '07! Log on to www.sify.com/khel for latest updates, expert columns, schedule, desktop scorecard, photo galleries and more! Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com For the Expert view of the ICC World Cup log on to www.sify.com/khel. Read exclusive interviews with Sachin, Ganguly, Yuvraj, Sreesanth, Expert Columns by Gavaskar, Web chat with Dhoni and more! .
On 3/18/07, Mageshwaran <j_mageshwaran@sifycorp.com> wrote: > Hi, > > In our company there are many postgres servers in 7.X version,we are in > the process of upgrading to 8.1 version, can anyone tell me the > method to do this upgradation. http://www.postgresql.org/docs/faqs.FAQ.html#item3.6 Btw, I personally find a payload/noise ratio of 1/6 atrocious, and not very kind regarding the mailing-list. > Regards > J Mageshwara > DBA Cheers, Andrej
So what's he meant to do? Write a longer question just so the mandatory disclamer that his company attaches to his e-mail takes up a lower percentage of his e-mail? (or should he not ask the question at all?) Regards, Ben > > Btw, I personally find a payload/noise ratio of 1/6 atrocious, > and not very kind regarding the mailing-list. > >
Ben Trewern wrote: > So what's he meant to do? Write a longer question just so the mandatory > disclamer that his company attaches to his e-mail takes up a lower > percentage of his e-mail? (or should he not ask the question at all?) Perhaps the OP's posit should have been sent to pgsql-admin@postgresql.org instead? :) -- Walter ICBM coordinates: Latitude: 35.6 Longitude: -81
On 3/20/07, Ben Trewern <ben.trewern@mowlem.com> wrote: > So what's he meant to do? Write a longer question just so the mandatory > disclamer that his company attaches to his e-mail takes up a lower > percentage of his e-mail? (or should he not ask the question at all?) Maybe use a gmail account for mailing lists like I do? Also makes mass-mailing of out-of-office messages less likely ... sounds like a bloody good idea. > Regards, > > Ben Cheers, Andrej
> So what's he meant to do? Avoiding terms like "UPGRADATION" would be an excellent start. Stuart.
Andrej Ricnik-Bay wrote: > On 3/20/07, Ben Trewern <ben.trewern@mowlem.com> wrote: >> So what's he meant to do? Write a longer question just so the mandatory >> disclamer that his company attaches to his e-mail takes up a lower >> percentage of his e-mail? (or should he not ask the question at all?) > Maybe use a gmail account for mailing lists like I do? > Also makes mass-mailing of out-of-office messages > less likely ... sounds like a bloody good idea. And if webmail is not allowed in his place of business? This whole comment thread is pointless. If you aren't going to help the guy, don't respond. Joshua D. Drake > > >> Regards, >> >> Ben > Cheers, > Andrej > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
Mageshwaran wrote: > Hi, > > In our company there are many postgres servers in 7.X version,we are in > the process of upgrading to 8.1 version, can anyone tell me the > method to do this upgradation. You will want to use the 8.1 version of pg_dump/pg_dumpall to connect to the 7.4 version of postgresql to do the restore. There is pretty good docs on it here: http://www.postgresql.org/docs/8.2/static/backup.html You will want to be careful though, some things have changed since 7.4. IIRC, timestamp/timestamptz changes, and float changes as well. Sincerely, Joshua D. Drake > > > Regards > J Mageshwara > DBA > > ********** DISCLAIMER ********** -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/