Use Slony to replicate to the new version from the old version. Once they are sync-ed up, you switch the new version to be the master and re-point your apps to the new DB. Ken On Mon, Oct 15, 2007 at 04:52:43PM +0400, Alexander Kuprijanov wrote: > Hello > > Does exist another way to make upgrade (without dump-restore)? > > I have this question, because I have very big DB (or very poor server): dump > ~40min, restore >2h > > I can't stop my DB so long... > > > > Thanks > > > ?? ?????????????????? ???? Thursday 20 September 2007 19:58:24 Milen A. Radev ??????????????(??): > > Josef Springer ????????????: > > > Where is the documentation of the steps dto do for updating e.g. from 8.1 > > > to 8.2 ? I have never done this and could not find any docs for. > > > > [...] > > > > http://www.postgresql.org/docs/8.2/static/install-upgrading.html > > > > -- > Se okulo ne atentas, dorso eksentas > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
