RE: Upgd from 7.0 to 7.1 - Mailing list pgsql-sql

From Diehl, Jeffrey
Subject RE: Upgd from 7.0 to 7.1
Date
Msg-id B51F0C636E578A4E832D3958690CD73E0130BF1D@es04snlnt
Whole thread Raw
In response to Upgd from 7.0 to 7.1  ("Diehl, Jeffrey" <jdiehl@sandia.gov>)
List pgsql-sql
I assume, then, that if I RTFM, I'll be able to figure out how to run two
db's at the same time...  I guess I have to run them in different
directories?  Or, do I do a dumpall, start the new server and do the
restore? Which is the best method?

Thanx,
Mike Diehl,
Network Monitoring Tool Devl.
Sandia National Laboratories.
(505) 284-3137
jdiehl@sandia.gov

> -----Original Message-----
> From: webb sprague [mailto:wsprague@o1.com]
> Sent: May 29, 2001 10:52 AM
> To: Diehl, Jeffrey
> Subject: Re: [SQL] Upgd from 7.0 to 7.1
> 
> 
> Yes, you have to do a dump/restore.  However, we have million 
> row databases 
> all over the place and pg_dump takes about 20 minutes with 
> 800 MhZ machine.
> 
> You are right in that you need to dump running the old DB, 
> restore with the 
> new one.
> 
> Enjoy.
> W
> 
> On Tuesday 29 May 2001 15:22, you wrote:
> > Hi all,
> >
> > I'm in the planning to upgrade from 7.0 to 7.1 and need to ask a few
> > questions before I make my deployment plan.
> >
> > Will I have to do a dump/restore of the database?  I have a 
> large database
> > (100+ Million records) and would rather not have to do a dump.
> >
> > If I have to do a dump, do need to run the old db in order 
> to do the dump.
> > Then I guess I'd have to start the new db and do the 
> restore.  That would
> > suck with a database this large.
> >
> > Please let me know about any details in doing this upgrade.
> >
> > Thanx,
> > Mike Diehl,
> > Network Monitoring Tool Devl.
> > Sandia National Laboratories.
> > (505) 284-3137
> > jdiehl@sandia.gov
> >
> >
> > ---------------------------(end of 
> broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://www.postgresql.org/search.mpl
> 



pgsql-sql by date:

Previous
From: Vivek Khera
Date:
Subject: Re: START for SERIAL type?
Next
From: "Diehl, Jeffrey"
Date:
Subject: Slow inserts/deletes