pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to update from 8.1 to 8.2 ?
7+ messages / 6 participants
[nested] [flat]

* How to update from 8.1 to 8.2 ?
@ 2007-09-20 15:42 Josef Springer <Josef.Springer@joops.com>
  2007-09-20 15:58 ` Re: How to update from 8.1 to 8.2 ? Milen A. Radev <milen@radev.net>
  0 siblings, 1 reply; 7+ messages in thread

From: Josef Springer @ 2007-09-20 15:42 UTC (permalink / raw)
  To: pgsql-admin

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.

mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)

[Postal]
Address
Josef.Springer@joops.com
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
[Phone]

Office
+49 (0)89 600 6920


[Phone]

Fax
+49 (0)89 600 69220


[Web]

Web
http://www.joops.com



[JOOPS]
(HRB München 86239)

-- the software company --


 

Attachments:

Postal.jpg (image/jpeg, 770B) download view image
Phone.jpg (image/jpeg, 802B) download view image
Phone.jpg (image/jpeg, 802B) download view image
Web.jpg (image/jpeg, 807B) download view image
Image120.jpg (image/jpeg, 7.6K) download view image
^ permalink raw reply [nested|flat] 7+ messages in thread

* Re: How to update from 8.1 to 8.2 ?
  2007-09-20 15:42 How to update from 8.1 to 8.2 ? Josef Springer <Josef.Springer@joops.com>
@ 2007-09-20 15:58 ` Milen A. Radev <milen@radev.net>
  2007-09-20 16:38   ` Re: How to update from 8.1 to 8.2 ? Carol Walter <walterc@indiana.edu>
  2007-10-15 12:52   ` Re: How to update from 8.1 to 8.2 ? Alexander Kuprijanov <sanya-spb@list.ru>
  0 siblings, 2 replies; 7+ messages in thread

From: Milen A. Radev @ 2007-09-20 15:58 UTC (permalink / raw)
  To: pgsql-admin

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


-- 
Milen A. Radev




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to update from 8.1 to 8.2 ?
  2007-09-20 15:42 How to update from 8.1 to 8.2 ? Josef Springer <Josef.Springer@joops.com>
  2007-09-20 15:58 ` Re: How to update from 8.1 to 8.2 ? Milen A. Radev <milen@radev.net>
@ 2007-09-20 16:38   ` Carol Walter <walterc@indiana.edu>
  2007-09-20 18:06     ` Re: How to update from 8.1 to 8.2 ? Chris Hoover <revoohc@gmail.com>
  1 sibling, 1 reply; 7+ messages in thread

From: Carol Walter @ 2007-09-20 16:38 UTC (permalink / raw)
  To: Milen A. Radev <milen@radev.net>; +Cc: pgsql-admin

We just did this.  I did a pg_dumpall using 8.1.  Then we fired up  
8.2 while 8.1 was still running.  Uploaded the data to 8.2.  Then  
shut 8.1 down.  This allowed us to have the database unavailable for  
a very short time.

Carol

On Sep 20, 2007, at 11:58 AM, Milen A. Radev wrote:

> 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
>
>
> -- 
> Milen A. Radev
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 6: explain analyze is your friend




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to update from 8.1 to 8.2 ?
  2007-09-20 15:42 How to update from 8.1 to 8.2 ? Josef Springer <Josef.Springer@joops.com>
  2007-09-20 15:58 ` Re: How to update from 8.1 to 8.2 ? Milen A. Radev <milen@radev.net>
  2007-09-20 16:38   ` Re: How to update from 8.1 to 8.2 ? Carol Walter <walterc@indiana.edu>
@ 2007-09-20 18:06     ` Chris Hoover <revoohc@gmail.com>
  2007-09-21 15:30       ` Re: How to update from 8.1 to 8.2 ? Carol Walter <walterc@indiana.edu>
  0 siblings, 1 reply; 7+ messages in thread

From: Chris Hoover @ 2007-09-20 18:06 UTC (permalink / raw)
  To: Carol Walter <walterc@indiana.edu>; +Cc: Milen A. Radev <milen@radev.net>; pgsql-admin

On 9/20/07, Carol Walter <walterc@indiana.edu> wrote:
>
> We just did this.  I did a pg_dumpall using 8.1.  Then we fired up
> 8.2 while 8.1 was still running.  Uploaded the data to 8.2.  Then
> shut 8.1 down.  This allowed us to have the database unavailable for
> a very short time.
>
> Carol



Carol,

If this is truely what you did, you are a very lucky person.  You are always
supposed to dump the old database using the new versions
pg_dump/pg_dumpall.  That way, pg_dump/pg_dumpall can set up the data for
any changes made by the newer version.

Just an fyi for those following this thread.

HTH,

chris

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to update from 8.1 to 8.2 ?
  2007-09-20 15:42 How to update from 8.1 to 8.2 ? Josef Springer <Josef.Springer@joops.com>
  2007-09-20 15:58 ` Re: How to update from 8.1 to 8.2 ? Milen A. Radev <milen@radev.net>
  2007-09-20 16:38   ` Re: How to update from 8.1 to 8.2 ? Carol Walter <walterc@indiana.edu>
  2007-09-20 18:06     ` Re: How to update from 8.1 to 8.2 ? Chris Hoover <revoohc@gmail.com>
@ 2007-09-21 15:30       ` Carol Walter <walterc@indiana.edu>
  0 siblings, 0 replies; 7+ messages in thread

From: Carol Walter @ 2007-09-21 15:30 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: Milen A. Radev <milen@radev.net>; pgsql-admin

Chris,

Perhaps I wasn't clear on what we did.  We loaded the 8.2 and got it  
running on a different zone on the same machine running Solaris.  I  
should have said we did a pg_dumpall using the 8.1 data.  ( I know  
there is a big difference.)  Anyway, I did the pg_dumpall (using the  
correct version, the new version.) of the live data and uploaded it  
to the 8.2 instance.  The 8.1 instance was still running.  Both  
systems automount the same dirs.  We were able to put the data from  
the 8.1 instance onto a directory that the 8.2 instance could see,  
which made the cut over very quick and the production system just had  
to be down long enough to stop and restart.  I had already modified  
the conf files and we didn't blow them away so we were good to go.  I  
just froze data entry from when I started the dump until the new  
instance was available.  That meant people could still select data  
from the website.  After the 8.2 instance was up and running and  
everything looked like in came over correctly, we shut down the 8.1  
instance.

Sorry about the confusion.

Carol

On Sep 20, 2007, at 2:06 PM, Chris Hoover wrote:

>
>
> On 9/20/07, Carol Walter <walterc@indiana.edu> wrote:
> We just did this.  I did a pg_dumpall using 8.1.  Then we fired up
> 8.2 while 8.1 was still running.  Uploaded the data to 8.2.  Then
> shut 8.1 down.  This allowed us to have the database unavailable for
> a very short time.
>
> Carol
>
>
> Carol,
>
> If this is truely what you did, you are a very lucky person.  You  
> are always supposed to dump the old database using the new versions  
> pg_dump/pg_dumpall.  That way, pg_dump/pg_dumpall can set up the  
> data for any changes made by the newer version.
>
> Just an fyi for those following this thread.
>
> HTH,
>
> chris
>
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to update from 8.1 to 8.2 ?
  2007-09-20 15:42 How to update from 8.1 to 8.2 ? Josef Springer <Josef.Springer@joops.com>
  2007-09-20 15:58 ` Re: How to update from 8.1 to 8.2 ? Milen A. Radev <milen@radev.net>
@ 2007-10-15 12:52   ` Alexander Kuprijanov <sanya-spb@list.ru>
  2007-10-15 13:04     ` Re: How to update from 8.1 to 8.2 ? Kenneth Marshall <ktm@rice.edu>
  1 sibling, 1 reply; 7+ messages in thread

From: Alexander Kuprijanov @ 2007-10-15 12:52 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Milen A. Radev <milen@radev.net>

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to update from 8.1 to 8.2 ?
  2007-09-20 15:42 How to update from 8.1 to 8.2 ? Josef Springer <Josef.Springer@joops.com>
  2007-09-20 15:58 ` Re: How to update from 8.1 to 8.2 ? Milen A. Radev <milen@radev.net>
  2007-10-15 12:52   ` Re: How to update from 8.1 to 8.2 ? Alexander Kuprijanov <sanya-spb@list.ru>
@ 2007-10-15 13:04     ` Kenneth Marshall <ktm@rice.edu>
  0 siblings, 0 replies; 7+ messages in thread

From: Kenneth Marshall @ 2007-10-15 13:04 UTC (permalink / raw)
  To: Alexander Kuprijanov <sanya-spb@list.ru>; +Cc: pgsql-admin@postgresql.org, "Milen A. Radev" <milen@radev.net>

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
> 



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2007-10-15 13:04 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-20 15:42 How to update from 8.1 to 8.2 ? Josef Springer <Josef.Springer@joops.com>
2007-09-20 15:58 ` Milen A. Radev <milen@radev.net>
2007-09-20 16:38   ` Carol Walter <walterc@indiana.edu>
2007-09-20 18:06     ` Chris Hoover <revoohc@gmail.com>
2007-09-21 15:30       ` Carol Walter <walterc@indiana.edu>
2007-10-15 12:52   ` Alexander Kuprijanov <sanya-spb@list.ru>
2007-10-15 13:04     ` Kenneth Marshall <ktm@rice.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox