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

* Upgrade
@ 2000-11-11 03:27 Gavin M. Roy <gmr@readysetnet.com>
  0 siblings, 0 replies; 18+ messages in thread

From: Gavin M. Roy @ 2000-11-11 03:27 UTC (permalink / raw)
  To: pgsql-admin

Is it generally considered safe to upgrade libs and bins without
upgrading data -> ie I am running 7.0.1 and want to go to 7.0.2 without
touching my data dir?  can I compile and install without worry of
touching my data?




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

* upgrade
@ 2002-04-12 23:29 Gianmarco Piola <gianco99@hotmail.com>
  2002-04-15 13:48 ` Re: upgrade Auri Mason <amason@syntrex.com>
  0 siblings, 1 reply; 18+ messages in thread

From: Gianmarco Piola @ 2002-04-12 23:29 UTC (permalink / raw)
  To: pgsql-admin

I want to report a problem...
... i am a newbie with Linux system and i barely know his structure.
I installed Linux Red Hat and during the installation i choose to install 
php and pgsql. After some initial problem to discover the directory where 
the pgsql was installed all worked well but then i discovered that the 
version was 7.0. I then decided to upgrade but how? I downloaded the new 
file but the documentation(also the admin guide) on how to remove the old 
version (it is splitted in MORE then one dir) and to install the new is 
poor. And also there is no mention if i must do something with php for the 
pgsql 7.2 because my version is compiled for 7.0.
If you can reply please tell me where to find this info or who can i 
contact.

P.S.:sorry for the bed english.

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx




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

* Re: upgrade
  2002-04-12 23:29 upgrade Gianmarco Piola <gianco99@hotmail.com>
@ 2002-04-15 13:48 ` Auri Mason <amason@syntrex.com>
  0 siblings, 0 replies; 18+ messages in thread

From: Auri Mason @ 2002-04-15 13:48 UTC (permalink / raw)
  To: pgsql-admin

Ciao Gianmarco;

You can upgrade your pg installation by using the rpm version.
download the rpm version, the latest at the moment could be the 7.2, and 
try to upgrade your intstallation using the RPM command.

p.s. man rpm

--
Auri 

On Fri, 12 Apr 2002, Gianmarco Piola wrote:

> I want to report a problem...
> ... i am a newbie with Linux system and i barely know his structure.
> I installed Linux Red Hat and during the installation i choose to install 
> php and pgsql. After some initial problem to discover the directory where 
> the pgsql was installed all worked well but then i discovered that the 
> version was 7.0. I then decided to upgrade but how? I downloaded the new 
> file but the documentation(also the admin guide) on how to remove the old 
> version (it is splitted in MORE then one dir) and to install the new is 
> poor. And also there is no mention if i must do something with php for the 
> pgsql 7.2 because my version is compiled for 7.0.
> If you can reply please tell me where to find this info or who can i 
> contact.




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

* upgrade?
@ 2002-05-13 14:39 Jodi Kanter <jkanter@virginia.edu>
  2002-05-13 16:20 ` Re: upgrade? Gareth Kirwan <gbjk@thermeoneurope.com>
  2002-05-13 17:15 ` Re: upgrade? Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 18+ messages in thread

From: Jodi Kanter @ 2002-05-13 14:39 UTC (permalink / raw)
  To: pgsql-admin

We are still running 7.1.3. Can anyone highlight the big differences or reasons to upgrade? Is there some documentation on this?
Thanks
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu



 

 

 

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

* Re: upgrade?
  2002-05-13 14:39 upgrade? Jodi Kanter <jkanter@virginia.edu>
@ 2002-05-13 16:20 ` Gareth Kirwan <gbjk@thermeoneurope.com>
  1 sibling, 0 replies; 18+ messages in thread

From: Gareth Kirwan @ 2002-05-13 16:20 UTC (permalink / raw)
  To: 'Jodi Kanter' <jkanter@virginia.edu>; pgsql-admin

Yes there is documentation, yes there are changes.
if you're happy with what you're on, don't bother.
The main change I noticed was that it no longer allows the illegal syntax of
= NULL
( I KNOW I KNOW, but I liked using it! :p)

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

* Re: upgrade?
  2002-05-13 14:39 upgrade? Jodi Kanter <jkanter@virginia.edu>
@ 2002-05-13 17:15 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 18+ messages in thread

From: Tom Lane @ 2002-05-13 17:15 UTC (permalink / raw)
  To: Jodi Kanter <jkanter@virginia.edu>; +Cc: pgsql-admin

Jodi Kanter <jkanter@virginia.edu> writes:
> We are still running 7.1.3. Can anyone highlight the big differences or rea=
> sons to upgrade? Is there some documentation on this?

The release notes always mention the main improvements.  Quoting from
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/release.html:


Major changes in this release: 

VACUUM

     Vacuuming no longer locks tables, thus allowing normal user access during the vacuum. A new VACUUM FULL
     command does old-style vacuum by locking the table and shrinking the on-disk copy of the table. 

Transactions

     There is no longer a problem with installations that exceed four billion transactions. 

OID's

     OID's are now optional. Users can now create tables without OID's for cases where OID usage is excessive. 

Optimizer

     The system now computes histogram column statistics during ANALYZE, allowing much better optimizer choices. 

Security

     A new MD5 encryption option allows more secure storage and transfer of passwords. A new Unix-domain socket
     authentication option is available on Linux and BSD systems. 

Statistics

     Administrators can use the new table access statistics module to get fine-grained information about table and
     index usage. 

Internationalization

     Program and library messages can now be displayed in several languages. 


			regards, tom lane



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

* upgrade
@ 2003-04-08 14:20 Jodi Kanter <jkanter@virginia.edu>
  2003-04-08 14:47 ` Re: upgrade Victor Yegorov <viy@pirmabanka.lv>
  2003-04-08 14:50 ` Re: upgrade Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 2 replies; 18+ messages in thread

From: Jodi Kanter @ 2003-04-08 14:20 UTC (permalink / raw)
  To: pgsql-admin

Are there any issues that I should be aware of in upgrading from 7.2.3 
to 7.3.2? Will it require a dump and restore of the database?
Any links to documentation on the upgrade would be appreciated.
Thanks
Jodi
-- 

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu <mailto:jkanter@virginia.edu>

 

 

 

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

* Re: upgrade
  2003-04-08 14:20 upgrade Jodi Kanter <jkanter@virginia.edu>
@ 2003-04-08 14:47 ` Victor Yegorov <viy@pirmabanka.lv>
  1 sibling, 0 replies; 18+ messages in thread

From: Victor Yegorov @ 2003-04-08 14:47 UTC (permalink / raw)
  To: Jodi Kanter <jkanter@virginia.edu>; +Cc: pgsql-admin

* Jodi Kanter <jkanter@virginia.edu> [08.04.2003 17:41]:
> Are there any issues that I should be aware of in upgrading from 7.2.3 
> to 7.3.2? Will it require a dump and restore of the database?
> Any links to documentation on the upgrade would be appreciated.

Yes, you'll need to dump and restore your db.

Look here: http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=installation.html

-- 

Victor Yegorov

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

* Re: upgrade
  2003-04-08 14:20 upgrade Jodi Kanter <jkanter@virginia.edu>
@ 2003-04-08 14:50 ` Robert Treat <xzilla@users.sourceforge.net>
  1 sibling, 0 replies; 18+ messages in thread

From: Robert Treat @ 2003-04-08 14:50 UTC (permalink / raw)
  To: Jodi Kanter <jkanter@virginia.edu>; +Cc: pgsql-admin

It will require a dump/restore. I'd suggest reading the Changelog for
7.3 over carefully, and do any initial dump/restore on a separate
machine to check for any possible problems.

Robert Treat

On Tue, 2003-04-08 at 10:20, Jodi Kanter wrote:
> Are there any issues that I should be aware of in upgrading from 7.2.3
> to 7.3.2? Will it require a dump and restore of the database?
> Any links to documentation on the upgrade would be appreciated.
> Thanks
> Jodi
> 




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

* upgrade
@ 2003-09-04 12:06 Martins Zarins <Martins.Zarins@vestnesis.lv>
  2003-09-09 20:51 ` Re: upgrade Robert Treat <xzilla@users.sourceforge.net>
  2003-09-09 23:20 ` Re: upgrade Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 2 replies; 18+ messages in thread

From: Martins Zarins @ 2003-09-04 12:06 UTC (permalink / raw)
  To: pgsql-admin

Hekko, All!

I'm planing to upgrade from 7.2.1 to 7.3.4.
Will pg_dumpall and pg_restore be sufficient for propper data migration?

Mark



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

* Re: upgrade
  2003-09-04 12:06 upgrade Martins Zarins <Martins.Zarins@vestnesis.lv>
@ 2003-09-09 20:51 ` Robert Treat <xzilla@users.sourceforge.net>
  1 sibling, 0 replies; 18+ messages in thread

From: Robert Treat @ 2003-09-09 20:51 UTC (permalink / raw)
  To: Martins Zarins <Martins.Zarins@vestnesis.lv>; +Cc: pgsql-admin

probably, though do it on a test machine first as sometimes little
issues can crop up.

Robert Treat

On Thu, 2003-09-04 at 08:06, Martins Zarins wrote:
> Hekko, All!
> 
> I'm planing to upgrade from 7.2.1 to 7.3.4.
> Will pg_dumpall and pg_restore be sufficient for propper data migration?
> 
> Mark
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL




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

* Re: upgrade
  2003-09-04 12:06 upgrade Martins Zarins <Martins.Zarins@vestnesis.lv>
@ 2003-09-09 23:20 ` Peter Eisentraut <peter_e@gmx.net>
  1 sibling, 0 replies; 18+ messages in thread

From: Peter Eisentraut @ 2003-09-09 23:20 UTC (permalink / raw)
  To: Martins Zarins <Martins.Zarins@vestnesis.lv>; +Cc: pgsql-admin

Martins Zarins writes:

> I'm planing to upgrade from 7.2.1 to 7.3.4.
> Will pg_dumpall and pg_restore be sufficient for propper data migration?

If you use pg_dumpall, then you need to restore using psql; pg_restore
won't do you any good.

Also: save your configuration files, read the release notes, test your
applications.

-- 
Peter Eisentraut   peter_e@gmx.net




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

* Upgrade
@ 2003-09-04 12:09 Mark <mark@vestnesis.lv>
  0 siblings, 0 replies; 18+ messages in thread

From: Mark @ 2003-09-04 12:09 UTC (permalink / raw)
  To: pgsql-admin

Hello, All!

I'm planing to upgrade from 7.2.1 to 7.3.4.
Will pg_dumpall and pg_restore be sufficient for propper data migration?

Mark




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

* upgrade
@ 2004-05-13 13:36 Jodi Kanter <jkanter@virginia.edu>
  2004-05-13 13:51 ` Re: upgrade Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
  0 siblings, 1 reply; 18+ messages in thread

From: Jodi Kanter @ 2004-05-13 13:36 UTC (permalink / raw)
  To: pgsql-admin

We are currently on version 7.3.3 and I was thinking of upgrading. Is 
the 7.4.2 version considered a stable version?
I read some info regarding changes to the system tables. Can someone 
touch on how this might affect us?
Do I need to restore my database with this upgrade?
Thanks so much,
Jodi Kanter
-- 

/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu <mailto:jkanter@virginia.edu>/

 

/ /

/ /

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

* Re: upgrade
  2004-05-13 13:36 upgrade Jodi Kanter <jkanter@virginia.edu>
@ 2004-05-13 13:51 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
  0 siblings, 0 replies; 18+ messages in thread

From: Sam Barnett-Cormack @ 2004-05-13 13:51 UTC (permalink / raw)
  To: Jodi Kanter <jkanter@virginia.edu>; +Cc: pgsql-admin

On Thu, 13 May 2004, Jodi Kanter wrote:

> We are currently on version 7.3.3 and I was thinking of upgrading. Is
> the 7.4.2 version considered a stable version?
> I read some info regarding changes to the system tables. Can someone
> touch on how this might affect us?
> Do I need to restore my database with this upgrade?

You will need to do a dump/restore, yes - you always do when the second
part of the version number changes.

-- 

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University



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

* upgrade
@ 2005-11-11 16:08 Josh O'Brien <obrien@zedxinc.com>
  2005-11-11 16:29 ` Re: upgrade Bruno Wolff III <bruno@wolff.to>
  2005-11-11 17:17 ` Re: upgrade Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 2 replies; 18+ messages in thread

From: Josh O'Brien @ 2005-11-11 16:08 UTC (permalink / raw)
  To: pgsql-admin

Hello all

I was just wondering if anyone could tell me if there is any seamless 
way to upgrade from 7.4 to 8.1 without performing a full dump/restore.

Thanks
Joshua O'Brien
DBA
Zedx Inc.

Attachments:

obrien.vcf (text/x-vcard, 111B) download begin:vcard fn:Joshua O'Brien n:O'Brien;Joshua org:Zedx Inc. title:Database Administrator version:2.1 end:vcard
^ permalink raw reply [nested|flat] 18+ messages in thread

* Re: upgrade
  2005-11-11 16:08 upgrade Josh O'Brien <obrien@zedxinc.com>
@ 2005-11-11 16:29 ` Bruno Wolff III <bruno@wolff.to>
  1 sibling, 0 replies; 18+ messages in thread

From: Bruno Wolff III @ 2005-11-11 16:29 UTC (permalink / raw)
  To: Josh O'Brien <obrien@zedxinc.com>; +Cc: pgsql-admin

On Fri, Nov 11, 2005 at 11:08:58 -0500,
  Josh O'Brien <obrien@zedxinc.com> wrote:
> Hello all
> 
> I was just wondering if anyone could tell me if there is any seamless 
> way to upgrade from 7.4 to 8.1 without performing a full dump/restore.

If you need to minimize down time, there are ways to use Slony to do that.
There is not a way to just update the data files directly.



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

* Re: upgrade
  2005-11-11 16:08 upgrade Josh O'Brien <obrien@zedxinc.com>
@ 2005-11-11 17:17 ` Joshua D. Drake <jd@commandprompt.com>
  1 sibling, 0 replies; 18+ messages in thread

From: Joshua D. Drake @ 2005-11-11 17:17 UTC (permalink / raw)
  To: Josh O'Brien <obrien@zedxinc.com>; +Cc: pgsql-admin

Josh O'Brien wrote:
> Hello all
>
> I was just wondering if anyone could tell me if there is any seamless 
> way to upgrade from 7.4 to 8.1 without performing a full dump/restore.
Slony-I or Mammoth Replicator

>
> Thanks
> Joshua O'Brien
> DBA
> Zedx Inc.
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>   




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


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

Thread overview: 18+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-11 03:27 Upgrade Gavin M. Roy <gmr@readysetnet.com>
2002-04-12 23:29 upgrade Gianmarco Piola <gianco99@hotmail.com>
2002-04-15 13:48 ` Re: upgrade Auri Mason <amason@syntrex.com>
2002-05-13 14:39 upgrade? Jodi Kanter <jkanter@virginia.edu>
2002-05-13 16:20 ` Re: upgrade? Gareth Kirwan <gbjk@thermeoneurope.com>
2002-05-13 17:15 ` Re: upgrade? Tom Lane <tgl@sss.pgh.pa.us>
2003-04-08 14:20 upgrade Jodi Kanter <jkanter@virginia.edu>
2003-04-08 14:47 ` Re: upgrade Victor Yegorov <viy@pirmabanka.lv>
2003-04-08 14:50 ` Re: upgrade Robert Treat <xzilla@users.sourceforge.net>
2003-09-04 12:06 upgrade Martins Zarins <Martins.Zarins@vestnesis.lv>
2003-09-09 20:51 ` Re: upgrade Robert Treat <xzilla@users.sourceforge.net>
2003-09-09 23:20 ` Re: upgrade Peter Eisentraut <peter_e@gmx.net>
2003-09-04 12:09 Upgrade Mark <mark@vestnesis.lv>
2004-05-13 13:36 upgrade Jodi Kanter <jkanter@virginia.edu>
2004-05-13 13:51 ` Re: upgrade Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2005-11-11 16:08 upgrade Josh O'Brien <obrien@zedxinc.com>
2005-11-11 16:29 ` Re: upgrade Bruno Wolff III <bruno@wolff.to>
2005-11-11 17:17 ` Re: upgrade 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