Re: Postgres UPGRADE from 9.2 to 9.4 - Mailing list pgsql-general
If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on the slave.
If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on the slave.
--
On Tue, Sep 6, 2016 at 6:43 PM, John R Pierce <pierce@hogranch.com> wrote:
On 9/6/2016 3:27 PM, Rich Shepard wrote:On Wed, 7 Sep 2016, Patrick B wrote:2 - I've never done a Postgres upgrade before, can you give some guide
here? Is usually a easy thing? How long can it take? Is a downtime needed?
I suggest the place to start is 'man pg_upgrade.' It is helpful.
pg_upgrade would require both 9.2 (with your existing database directory) and 9.4 be installed on the same server.
the easiest way to do this upgrade depends heavily on how large the database is. 'pg_dumpall -h oldserver | psql -h newserver' might be simplest for modest data sizes, but way too slow for larger data sets.
-- john r pierce, recycling bits in santa cruz
If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on the slave.
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
pgsql-general by date: