best practice in upgrading db structure - Mailing list pgsql-general

From SunWuKung
Subject best practice in upgrading db structure
Date
Msg-id MPG.1e93aca5f563c5f5989694@news.postgresql.org
Whole thread Raw
Responses Re: best practice in upgrading db structure  (brew@theMode.com)
Re: best practice in upgrading db structure  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: best practice in upgrading db structure  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
Re: best practice in upgrading db structure  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
This is going to be an amateur question...

Could somebody explain me, or point me to a resource where I can find
out what is the recommended practice when a live db needs to be replaced
with a new version of it that has a slightly different structure?

My first guess would be to create the empty new version of the db and
insert the data of the old one into it - adding and modifying it when
necessary, but I am not sure.

What do you usually do in a situation like this?

Thanks for the help.
Balázs

pgsql-general by date:

Previous
From: Ron Mayer
Date:
Subject: Re: FAQ 1.1
Next
From: Tom Lane
Date:
Subject: Re: Auto convert for type?