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
>