From: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
---|---|
To: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Upgrading from 9.0.11 to 9.3.5 on CentOS 6 (64 bit) |
Date: | 2014-08-02 01:31:14 |
Message-ID: | CAFWfU=uv7t7NnXazKvTDbSHd4e_UTZb81iGDxWBqPPK0p6RToQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you John.
> you can upgrade to 9.0.18 painlessly. 9.1 or .2 or .3, not quite so
> painless.
What's the best way to get to 9.0.18, as a start? Is there a simple
single command I can use? I'm on CentOS 6, 64bit.
> have you tried a vacuum full of the whole cluster, with your applications
> shut down?
Not yet, not with the apps shut down entirely, but in read mode, yes.
No new rows being added. SELECTs have to work as it's a high traffic
website.
> you will need to either pg_dumpall your old database 'cluster' and load this
> into the new version, or use pg_upgrade, which is a fair bit trickier but
> can do an in-place upgrade. if your databases aren't much over a few
> dozen gigabytes, pg_dumpall is probably simpler than pg_upgrade. if your
> databases are large, pg_dumpall -> psql restore may take a LONG time, so the
> pg_upgrade process may be more efficient.
Dread to use pg_upgrade after that confirmation of my fears. Our DB is
around 200 GB. Even with pg_upgrade, will I have to once again tinker
with all the conf files and authentication (which is md5 right now),
change my passwords and do "template1" database stuff again? I saw the
doc page on the postgresql.org site for pg_upgrade, but it presumes a
lot of things in terms of knowledge. I just have one database
"instance" or "cluster". The 10-15 tables are not complex. But they're
large, as in over a billion rows now. All I need is for the upgrade to
happen automatically, retaining my config and paths and whatnot (or
clear instructions that work, step by step).
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2014-08-02 02:32:30 | Re: Upgrading from 9.0.11 to 9.3.5 on CentOS 6 (64 bit) |
Previous Message | Chris Travers | 2014-08-02 01:22:05 | Re: Re: Feature proposal and discussion: full-fledged column/function equivalence |