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/
