Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-10-12 Thread Patrick B
2016-09-09 1:09 GMT+12:00 Scott Marlowe : > On Tue, Sep 6, 2016 at 5:25 PM, John R Pierce wrote: > > On 9/6/2016 4:20 PM, Melvin Davidson wrote: > >> > >> If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on > >> the slave. > > >

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-08 Thread Scott Marlowe
On Tue, Sep 6, 2016 at 5:25 PM, John R Pierce wrote: > On 9/6/2016 4:20 PM, Melvin Davidson wrote: >> >> If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on >> the slave. > > > does rackspace support slony? how about amazon dms ? > > slony requires

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-07 Thread Patrick B
> > > Or if you want, upgrade on your existing provider first, then setup > streaming replication. But no matter what, pg_upgrade will require some > form of downtime. > > You could also use either Slony or londiste to directly migrate from > Rackspace to an EC2 instance on 9.5; no need for DMS at

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-07 Thread Jim Nasby
On 9/6/16 10:53 PM, John R Pierce wrote: 1) setup new streaming slave at new provider using 9.2, wait for replication to complete and satisfy yourself that the database is complete and intact. 2) shut down master at old provider (and any other slaves), promote new provider 9.2 to master. 3)

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread John R Pierce
On 9/6/2016 8:21 PM, Venkata B Nagothi wrote: it's a full copy from the production, so it's 2.3TB Thats quite huge. pg_upgrade would be a better choice and yes, downtime is needed. You need to have the database shutdown all through the upgrade process. How long it will take depends on

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread Venkata B Nagothi
On Wed, Sep 7, 2016 at 10:43 AM, Patrick B wrote: > >> how large is the full database cluster? >> >> if its only a few GB or whatever, and not grossly complex, pg_dumpall -h >> oldhost | psql -h newhost, is the simplest way to move a complete set of >> databases from an

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread Patrick B
> > > how large is the full database cluster? > > if its only a few GB or whatever, and not grossly complex, pg_dumpall -h > oldhost | psql -h newhost, is the simplest way to move a complete set of > databases from an old server to a new. if there are large tables with > millions of rows indexed,

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread John R Pierce
On 9/6/2016 4:47 PM, Patrick B wrote: 1 - upgrade master server 2 - by performing #1 - the slaves would become unused (streaming replication wouldn't work) 3 - Setup new slave running Postgres 9.4 4 - dump the db to the new server how large is the full database cluster? if its only a few

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread Patrick B
> > > John, > Yes, Rackspace supports slony. I used to work there and they use slony on > their core system. > > Patrick, > You cannot stream directly from 9.2 to 9.4. However, you can just create a > separate 9.4 cluster (on a separate port). > Then pg_dump from 9.2 in plain format and it will

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread Melvin Davidson
On Tue, Sep 6, 2016 at 7:28 PM, Patrick B wrote: > > > 2016-09-07 11:25 GMT+12:00 John R Pierce : > >> On 9/6/2016 4:20 PM, Melvin Davidson wrote: >> >>> If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on >>> the slave. >>> >>

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread Patrick B
2016-09-07 11:25 GMT+12:00 John R Pierce : > On 9/6/2016 4:20 PM, Melvin Davidson wrote: > >> If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on >> the slave. >> > > does rackspace support slony? how about amazon dms ? > > slony requires configuring

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread John R Pierce
On 9/6/2016 4:20 PM, Melvin Davidson wrote: If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on the slave. does rackspace support slony? how about amazon dms ? slony requires configuring replication on each table. if the database has a large complex schema this could

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread Melvin Davidson
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 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,

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread John R Pierce
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.

Re: [GENERAL] Postgres UPGRADE from 9.2 to 9.4

2016-09-06 Thread Rich Shepard
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? Patrick, I suggest the place to start is 'man pg_upgrade.' It is helpful. Rich -- Sent via pgsql-general