pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Upgrading from from 7.4.2 to 8.0
4+ messages / 4 participants
[nested] [flat]

* Upgrading from from 7.4.2 to 8.0
@ 2005-01-26 18:51  James Gunzelman <JamesGunzelman@solutionary.com>
  0 siblings, 2 replies; 4+ messages in thread

From: James Gunzelman @ 2005-01-26 18:51 UTC (permalink / raw)
  To: pgsql-performance

Will I have to dump and reload all my databases when migrating from
7.4.2 to 8.0?
 

____________________________________

 

Jim Gunzelman

Senior Software Engineer

 

phone: 402.361.3078   fax: 402.361.3178

e-mail:  JamesGunzelmane@Solutionary.com

 

Solutionary, Inc.

www.Solutionary.com <http://www.solutionary.com/;        

 

Making Security Manageable 24x7

_____________________________________

 

Confidentiality Notice

The content of this communication, along with any attachments, is
covered by federal and state law governing electronic communications and
may contain confidential and legally privileged information.  If the
reader of this message is not the intended recipient, you are hereby
notified that any dissemination, distribution, use or copying of the
information contained herein is strictly prohibited.  If you have
received this communication in error, please immediately contact us by
telephone at (402) 361-3000 or e-mail security@solutionary.com.  Thank
you.

 

Copyright 2000-2005, Solutionary, Inc. All rights reserved.
ActiveGuard, eV3, Solutionary and the Solutionary logo are registered
trademarks of Solutionary, Inc.

 

 

 

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

* Re: Upgrading from from 7.4.2 to 8.0
@ 2005-01-26 19:42  Doug McNaught <doug@mcnaught.org>
  parent: James Gunzelman <JamesGunzelman@solutionary.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Doug McNaught @ 2005-01-26 19:42 UTC (permalink / raw)
  To: pgsql-performance

"James Gunzelman" <JamesGunzelman@solutionary.com> writes:

>    Will I have to dump and reload all my databases when migrating from
>    7.4.2 to 8.0?

Yes.

-Doug




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

* Re: Upgrading from from 7.4.2 to 8.0
@ 2005-01-26 19:51  Michael Fuhr <mike@fuhr.org>
  parent: James Gunzelman <JamesGunzelman@solutionary.com>
  1 sibling, 1 reply; 4+ messages in thread

From: Michael Fuhr @ 2005-01-26 19:51 UTC (permalink / raw)
  To: James Gunzelman <JamesGunzelman@solutionary.com>; +Cc: pgsql-performance

On Wed, Jan 26, 2005 at 12:51:14PM -0600, James Gunzelman wrote:

> Will I have to dump and reload all my databases when migrating from
> 7.4.2 to 8.0?

Yes -- the Release Notes mention it under "Migration to version 8.0":

http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0

Those unfamiliar with doing an upgrade might want to read "If You
Are Upgrading" in the "Installation Instructions" chapter of the
documenation, and "Migration Between Releases" in the "Backup and
Restore" chapter:

http://www.postgresql.org/docs/8.0/static/install-upgrading.html
http://www.postgresql.org/docs/8.0/static/migration.html

(Install or upgrade questions should probably go to pgsql-admin or
pgsql-general instead of pgsql-performance.)

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



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

* Re: Upgrading from from 7.4.2 to 8.0
@ 2005-01-26 20:14  Thomas F.O'Connell <tfo@sitening.com>
  parent: Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Thomas F.O'Connell @ 2005-01-26 20:14 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-performance@postgresql.org, James Gunzelman <JamesGunzelman@solutionary.com>

It should be noted that users who use Slony can create a subscriber 
node running 8.0 that subscribes to a node running 7.4.x and can 
transition with only the downtime required for failover.

This obviates the need for a dump/restore.

See <http://slony.info/;.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Jan 26, 2005, at 1:51 PM, Michael Fuhr wrote:

> On Wed, Jan 26, 2005 at 12:51:14PM -0600, James Gunzelman wrote:
>
>> Will I have to dump and reload all my databases when migrating from
>> 7.4.2 to 8.0?
>
> Yes -- the Release Notes mention it under "Migration to version 8.0":
>
> http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0
>
> Those unfamiliar with doing an upgrade might want to read "If You
> Are Upgrading" in the "Installation Instructions" chapter of the
> documenation, and "Migration Between Releases" in the "Backup and
> Restore" chapter:
>
> http://www.postgresql.org/docs/8.0/static/install-upgrading.html
> http://www.postgresql.org/docs/8.0/static/migration.html
>
> (Install or upgrade questions should probably go to pgsql-admin or
> pgsql-general instead of pgsql-performance.)
>
> -- 
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/




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


end of thread, other threads:[~2005-01-26 20:14 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-26 18:51 Upgrading from from 7.4.2 to 8.0 James Gunzelman <JamesGunzelman@solutionary.com>
2005-01-26 19:42 ` Doug McNaught <doug@mcnaught.org>
2005-01-26 19:51 ` Michael Fuhr <mike@fuhr.org>
2005-01-26 20:14   ` Thomas F.O'Connell <tfo@sitening.com>

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