Re: converting older databases

hai

Recently we migrated our database from 8.2.4 to 8.2.12 , went through
manuals and followed the below steps

1.pg_dumpall to take data dump of current database
2.stopped database
3.moved the pgsql to backup folder
4.downloaded 8.2.12 , configured - gmake - gmake install
5.recreated cluster directory
6.restored the database with datadump

It was like complete re-installation process.

Can anyone explain a alternative method to upgrade a existing database

thanks in advance

regards
sathish

On Fri, Mar 6, 2009 at 12:28 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> Heine Ferreira wrote:
>
>> Hi
>>
>> When you install a newer version of Postgres how do you upgrade your
>> database to the new format?
>> Apparantly you can't just backup the old database and restore it on the
>> new software.
>> How do you do this on Windows?
>>
>
> you pg_dump >dumpfile.sql the old one, psql -f dumpfile.sql to the new.
>
> Typically, you only need to do this between major upgrades, like 8.2.x to
> 8.3.y ... 8.3.x to 8.3.y doesn't require a dump/restore unless the
> release notes state otherwise (this has only happened a few times, I think
> there was a 8.0.1->8.0.N that required it due to a minor change required by
> a bugfix)
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
BSG LeatherLink Pvt Limited,
Mail To : sathish(at)leatherlink(dot)net
Website : http://www.leatherlink.net
Contact : +91 44 65191757