pg.ddx.io  pgsql-cygwin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Updating postgres 7.4.5 to 8 via cygwin
2+ messages / 2 participants
[nested] [flat]

* Updating postgres 7.4.5 to 8 via cygwin
@ 2008-06-29 08:13  Nick Texidor <nick@texidor.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Nick Texidor @ 2008-06-29 08:13 UTC (permalink / raw)
  To: pgsql-cygwin

Hi,

I was wondering whether someone can help me.   I already have postgres 7.4.5
running under cygwin on my web server, and I've looked into installing the
native version of 8, but it looks like there is a bit of dumping/importing
of database to be done.   I noticed that postgres 8 is available under
cygwin, and it came up as an update.  If I install it through cygwin, is
there any messing around with databases to be done?  Is that an easier
option than installing the native version and moving from a cygwin version?

Thank you

Nick

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

* Re: Updating postgres 7.4.5 to 8 via cygwin
@ 2008-06-29 09:55  Reini Urban <rurban@x-ray.at>
  parent: Nick Texidor <nick@texidor.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Reini Urban @ 2008-06-29 09:55 UTC (permalink / raw)
  To: Nick Texidor <nick@texidor.com>; +Cc: pgsql-cygwin

Nick Texidor schrieb:
> I was wondering whether someone can help me.   I already have postgres 
> 7.4.5 running under cygwin on my web server, and I've looked into 
> installing the native version of 8, but it looks like there is a bit of 
> dumping/importing of database to be done.   I noticed that postgres 8 is 
> available under cygwin, and it came up as an update.  If I install it 
> through cygwin, is there any messing around with databases to be done?  
> Is that an easier option than installing the native version and moving 
> from a cygwin version?

Installing a native version will create a new database.
Upgrading cygwin to 8 will leave you with a non-accessible database.

So if you need the data from the old database, you MUST export it.

See the cygwin announcement, which describes it in detail.
http://article.gmane.org/gmane.os.cygwin.announce/2310

Which says:
Before you upgrade a postgresql package to a new new major or
minor version (7.4 => 8.0 => 8.1 => 8.2), be sure to dump all your data
before!
With the new package you will not be able to access your old databases.
=> http://www.postgresql.org/docs/8.2/static/app-pg-dumpall.html
Minor subrelease updates (e.g. 8.2.4 to 8.2.5) can safely access the
same database.
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/



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


end of thread, other threads:[~2008-06-29 09:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-29 08:13 Updating postgres 7.4.5 to 8 via cygwin Nick Texidor <nick@texidor.com>
2008-06-29 09:55 ` Reini Urban <rurban@x-ray.at>

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