Gnanakumar" <gnanam@xxxxxxxxxx> wrote: > what is the correct method of upgrading/installing to 8.2.17? > > Let me make the question/idea, which I'm thinking in my minding of > upgrading, clear here: > > 1. Rename '/usr/local/pgsql/data' to '/usr/local/pgsql/data.old' > 2. Install v8.2.17 to its default from the source (Because > installing from source is comfortable for me) > 3. After installation, just remove '/usr/local/pgsql/data' and > rename '/usr/local/pgsql/data.old' to '/usr/local/pgsql/data' > 4. Start server. It should have become v8.2.17 There are so many ways to do this, particularly since you are comfortable installing from source, that I'll just tell you how we do it and let you adjust as needed for your shop. 1. We build from source with a version-specific prefix (for example: /usr/local/pgsql-8.4.4). We always point to a particular executable in our service scripts, but create a symbolic link to the one we want as the default client; the bin directory of that symlink is put onto our path. We do like to initdb a test cluster and confirm that our custom functions all got created properly and seem to be working before moving on. 2. Once the new minor version is installed, we point the service script to it for the database we're about to upgrade. 3. We always make sure we're backed up, but since we use PITR techniques with archiving always active, that's no big deal. 4. We do a service stop followed by a service start (*not* a restart!) to start using the new version. 5. We do any post-upgrade steps, like any needed REINDEX. I'm not sure why you needed that rename dodge that you mentioned, but you know your environment better than I do. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
