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(at)sifycorp(dot)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(at)sifycorp(dot)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(at)postgresql(dot)org
instead?

:)

--
Walter
ICBM coordinates: Latitude: 35.6 Longitude: -81

On 3/20/07, Ben Trewern <ben(dot)trewern(at)mowlem(dot)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(dot)trewern(at)mowlem(dot)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/