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.
> >
> >
> > does rackspace support slony? how about
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 configuring replication on
>
>
> 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
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) pg_up
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
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 old server to a new. if th
>
>
> 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, m
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 GB
>
>
> 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 loa
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.
>>>
>>
>> does rackspace support slony? how about amaz
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 replication on each table
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 ta
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, can you give some guide
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.
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
Hi guys,
I'll be migrating my Postgres 9.2 database from Rackspace to Amazon.
To do that work, I'll be using DMS at amazon... unfortunately DMS needs a
Postgres 9.4+ version at least (
http://docs.aws.amazon.com/pt_br/dms/latest/userguide/CHAP_Introduction.Sources.html)
- So that means that I'll
16 matches
Mail list logo
