pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Best way to upgrade Postgresql 7.4.x to 8.1.x?
2+ messages / 2 participants
[nested] [flat]

* Best way to upgrade Postgresql 7.4.x to 8.1.x?
@ 2006-05-05 10:05  Arnau <arnaulist@andromeiberica.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Arnau @ 2006-05-05 10:05 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

   I have several servers running with Postgresql 7.4.x on Debian, 
everybody says that those servers should be migrated to version 8.0 or 
8.1. Finally I'm decided to migrate those servers but I'm worried about 
how to do that. Those servers are in production and the downtime should 
be the minimum. Any advise about what's the way or the best way to do it?

Thank you very much
-- 
Arnau



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

* Re: Best way to upgrade Postgresql 7.4.x to 8.1.x?
@ 2006-05-05 16:48  Joshua D. Drake <jd@commandprompt.com>
  parent: Arnau <arnaulist@andromeiberica.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Joshua D. Drake @ 2006-05-05 16:48 UTC (permalink / raw)
  To: arnaulist@andromeiberica.com; +Cc: pgsql-admin

Arnau wrote:
> Hi all,
> 
>   I have several servers running with Postgresql 7.4.x on Debian, 
> everybody says that those servers should be migrated to version 8.0 or 
> 8.1. Finally I'm decided to migrate those servers but I'm worried about 
> how to do that. Those servers are in production and the downtime should 
> be the minimum. Any advise about what's the way or the best way to do it?
> 
> Thank you very much


I think Slony is going to be the best bet for minimal downtime.


-- 

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/





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


end of thread, other threads:[~2006-05-05 16:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-05 10:05 Best way to upgrade Postgresql 7.4.x to 8.1.x? Arnau <arnaulist@andromeiberica.com>
2006-05-05 16:48 ` Joshua D. Drake <jd@commandprompt.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