pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Upgrade in Place
2+ messages / 2 participants
[nested] [flat]

* Upgrade in Place
@ 2008-11-12 17:06  Naomi Walker <nwalke@eldocomp.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Naomi Walker @ 2008-11-12 17:06 UTC (permalink / raw)
  To: ; +Cc: GENERAL <pgsql-general@postgresql.org>

We have a very large new customer that is considering using Postgres for 
their RDBMS.  The size
of the database will be in the several terrabytes range, making 
unloading/reloading a time consuming
and disk-eating process.  This customer will be running on a Windows 
platform. 

I've been looking at the upgrade_in_place docs in pgfoundry, but it 
seems it is in the "trying to be
revived" stage.

Does anyone have newer information about the move towards upgrades-in-place?

Thanks,
Naomi

-- 
------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Eldorado Computing, Inc               nwalker@eldocomp.com
  ---An EDS Company                   602-604-3100
------------------------------------------------------------------------
Hard things are put in our way, not to stop us, but to call out our
courage and strength. -- Anonymous
------------------------------------------------------------------------

-- CONFIDENTIALITY NOTICE --

Information transmitted by this e-mail is proprietary to MphasiS and/or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this e-mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailmaster@mphasis.com and delete this mail from your records.



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

* Re: Upgrade in Place
@ 2008-11-12 17:36  Richard Huxton <dev@archonet.com>
  parent: Naomi Walker <nwalke@eldocomp.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2008-11-12 17:36 UTC (permalink / raw)
  To: Naomi Walker <nwalke@eldocomp.com>; +Cc: GENERAL <pgsql-general@postgresql.org>

Quick tip: don't start a new thread by replying to a previous message,
it can mean your message gets missed.

Naomi Walker wrote:
> We have a very large new customer that is considering using Postgres for 
> their RDBMS.  The size
> of the database will be in the several terrabytes range, making 
> unloading/reloading a time consuming
> and disk-eating process.  This customer will be running on a Windows 
> platform. 

For such a large database, I would give serious thought to not running
on Windows. PostgreSQL has a much longer history on the unix side of the
fence, and a larger *nix community of users and developers. If you're
worried about support, I'm sure Red Hat, Novell or Sun would be more
than happy with the money you'd have spent on Windows licencing. There
are also several well established PostgreSQL consulting companies who
can support both the database and operating-system.

> I've been looking at the upgrade_in_place docs in pgfoundry, but it 
> seems it is in the "trying to be
> revived" stage.
> 
> Does anyone have newer information about the move towards upgrades-in-place?

Work is ongoing for 8.4 (to allow you to upgrade in-place to 8.5). You
have pretty much full access to all development discussions by checking
the pgsql-hackers mailing list (there's also a developers side to the
website). Search for "WIP" on the hackers list. Bear in mind that
there's no guarantee that *any* feature not yet complete will make it
into 8.4 (although there are a lot of big users who really want this
feature, so it's a strong candidate).

HTH

-- 
  Richard Huxton
  Archonet Ltd



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


end of thread, other threads:[~2008-11-12 17:36 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-11-12 17:06 Upgrade in Place Naomi Walker <nwalke@eldocomp.com>
2008-11-12 17:36 ` Richard Huxton <dev@archonet.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