Re: Postgres UPGRADE from 9.2 to 9.4

[John R Pierce <pierce@xxxxxxxxxxxx>]

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