pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade
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>
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-15 13:48 Auri Mason <amason@syntrex.com>
parent: Gianmarco Piola <gianco99@hotmail.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>
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 16:20 Gareth Kirwan <gbjk@thermeoneurope.com>
parent: Jodi Kanter <jkanter@virginia.edu>
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 17:15 Tom Lane <tgl@sss.pgh.pa.us>
parent: Jodi Kanter <jkanter@virginia.edu>
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>
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:47 Victor Yegorov <viy@pirmabanka.lv>
parent: Jodi Kanter <jkanter@virginia.edu>
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:50 Robert Treat <xzilla@users.sourceforge.net>
parent: Jodi Kanter <jkanter@virginia.edu>
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>
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
* 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
* Re: upgrade
@ 2003-09-09 20:51 Robert Treat <xzilla@users.sourceforge.net>
parent: Martins Zarins <Martins.Zarins@vestnesis.lv>
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-09 23:20 Peter Eisentraut <peter_e@gmx.net>
parent: Martins Zarins <Martins.Zarins@vestnesis.lv>
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
@ 2004-05-13 13:36 Jodi Kanter <jkanter@virginia.edu>
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:51 Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
parent: Jodi Kanter <jkanter@virginia.edu>
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>
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:29 Bruno Wolff III <bruno@wolff.to>
parent: Josh O'Brien <obrien@zedxinc.com>
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 17:17 Joshua D. Drake <jd@commandprompt.com>
parent: Josh O'Brien <obrien@zedxinc.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