[GENERAL] upgrade postgresql from 8.4.x to 8.4.4
Is there a procedure to upgrade from 8.4.x to 8.4.4 or am I over thinking it? I'm hoping I can just yum upgrade postgresql and have it just upgrade it without having to dump and restore the whole db. It would be nice if I had to only bounce postgresql to start using the newer version :) Thanks, Chris
Re: [GENERAL] upgrade postgresql from 8.4.x to 8.4.4
Right. A restart is enough. -- Devrim GÜNDÜZ PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Engineer devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz 09.Eyl.2010 tarihinde 22:44 saatinde, Chris Barnes compuguruchrisbar...@hotmail.com şunları yazdı: Is there a procedure to upgrade from 8.4.x to 8.4.4 or am I over thinking it? I'm hoping I can just yum upgrade postgresql and have it just upgrade it without having to dump and restore the whole db. It would be nice if I had to only bounce postgresql to start using the newer version :) Thanks, Chris -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD
Thank you all for the valuable advices. I'll try them on a test server and will come back. Thanks again! Iv ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD
[EMAIL PROTECTED] napisał(a): Could anybody point to an on-line resource about the steps involved with upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 - upgrade (ports) 4 - import 5- start db). here you are: http://www.postgresql.org/docs/8.1/static/migration.html If both PostgreSQL versions can't coexist on one host, you can use another one, with possibly identical setup (HW/OS/etc) for the migration, and transfer (use tar + netcat for minimal downtime) the cluster afterwards. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD
Hi, If the downtime is a concern, you could use Slony-1 for the migration. Philippe Ferreira. [EMAIL PROTECTED] napisał(a): Could anybody point to an on-line resource about the steps involved with upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 - upgrade (ports) 4 - import 5- start db). here you are: http://www.postgresql.org/docs/8.1/static/migration.html If both PostgreSQL versions can't coexist on one host, you can use another one, with possibly identical setup (HW/OS/etc) for the migration, and transfer (use tar + netcat for minimal downtime) the cluster afterwards. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] upgrade PostgreSQL 8.x on production FreeBSD
Could anybody point to an on-line resource about the steps involved with upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 - upgrade (ports) 4 - import 5- start db). Thanks, Iv Ray ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD
On Feb 23, 2006, at 9:21 AM, [EMAIL PROTECTED] wrote: Could anybody point to an on-line resource about the steps involved with upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 - upgrade (ports) 4 - import 5- start db). Upgrade from what to what? If you're upgrading from 8.0.x to 8.0.y then there is no dump/reload. If youre going from 8.1 to 8.1 then there is dump/reload OR you can use some sort of replication such as slony to copy the data, then have a few seconds of downtime while you turn off the older DB and put the 8.1 in its place. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD
[EMAIL PROTECTED] wrote: Could anybody point to an on-line resource about the steps involved with upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 - upgrade (ports) 4 - import 5- start db). You want to make your dump with the pg_dump of the new version. I'm not sure you can build the tools seperately (that'd be excellent, but my FreeBSD boxes are at home)... I think it should be: 1 - make postgresql, 2 - make install postgresql-tools 3 - dump 4 - stop db 5 - make install postgresql 6 - restore 7 - start db -- Alban Hertroys [EMAIL PROTECTED] magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World // ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] upgrade postgreSQL
I got the file .patch and tried to upgrade postgres sous FreeBSD with the command patch from the version 6.5.2 to the version 6.5.3 but it doesn't work. Could somebody explain to me how to upgrade postgres on my server. Thank's for your help __ Matthias Zehnder - Informatique E-mail: [EMAIL PROTECTED] __ M C net MC Management Communications SA A VIA NET.WORKS COMPANY Rue de Romont 35, CH-1700 Fribourg Tél.: ++41 (0)26 347 20 40, fax: ++41 (0)26 347 20 49 E-mail: [EMAIL PROTECTED], http://www.mcnet.ch
Re: [GENERAL] upgrade postgreSQL
Under FreeBSD, you should be using the ports. In this case, you could simply use the following commands in the postgresql port directory: make pkg_delete postgresql-6.5.2 make install Though the procedure was simple, there was a little gotcha. You need to: psql template1 select oid,* from pg_database; remove one of the two template1 tables by using the oid. Good luck, Marc On Wed, 26 Jan 2000, Matthias Zehnder wrote: I got the file .patch and tried to upgrade postgres sous FreeBSD with the command patch from the version 6.5.2 to the version 6.5.3 but it doesn't work. Could somebody explain to me how to upgrade postgres on my server. Thank's for your help __ Matthias Zehnder - Informatique E-mail: [EMAIL PROTECTED] __ M C net MC Management Communications SA A VIA NET.WORKS COMPANY Rue de Romont 35, CH-1700 Fribourg Tél.: ++41 (0)26 347 20 40, fax: ++41 (0)26 347 20 49 E-mail: [EMAIL PROTECTED], http://www.mcnet.ch