Re: UPGRADATION TO 8.1

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/