Re: Postgres UPGRADE from 9.2 to 9.4

On Tue, Sep 6, 2016 at 5:25 PM, John R Pierce <pierce@hogranch.com> 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 each table.  if the database has a
> large complex schema this could take considerable setup effort.
>

Not really. As of slony 2.2 you can use a regular expression to add
tables or sequences.

i.e.:

SET ADD TABLE (
    SET ID=1,
    TABLES='public\\.*'
);

repeat for sequences.  Two commands. I don't consider that considerable effort.
--
To understand recursion, one must first understand recursion.