Re: Recommendation for upgrading from PostgreSQL 9.3

2018-11-12 Thread Adrian Klaver
On 11/12/18 6:45 AM, Karl Martin Skoldebrand wrote: Thanks, https://www.postgresql.org/docs/10/release.html That's a massive list. But going for the first major release makes it manageable. Project policy is to only make feature changes on major version releases, so hitting only these

RE: Recommendation for upgrading from PostgreSQL 9.3

2018-11-12 Thread Karl Martin Skoldebrand
Thanks, >https://www.postgresql.org/docs/10/release.html That's a massive list. But going for the first major release makes it manageable. > --- >To be more certain I would set up a dev database with the new version and test >against >that. Aye, we've got a production and a test server.

RE: Recommendation for upgrading from PostgreSQL 9.3

2018-11-12 Thread Karl Martin Skoldebrand
Thanks for your input. /M. Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy

Re: Recommendation for upgrading from PostgreSQL 9.3

2018-11-12 Thread Pavel Stehule
po 12. 11. 2018 v 11:45 odesílatel Karl Martin Skoldebrand < ks0c77...@techmahindra.com> napsal: > I found a note on logical replication in PostgreSQL 10.x with the caveat > “There are also a number of caveats regarding what objects are actually > replicated—for example, only tables are

RE: Recommendation for upgrading from PostgreSQL 9.3

2018-11-12 Thread Karl Martin Skoldebrand
I found a note on logical replication in PostgreSQL 10.x with the caveat "There are also a number of caveats regarding what objects are actually replicated-for example, only tables are replicated, such objects as views and sequences are not." Does replication in 10.x now include views etc? We

Re: Recommendation for upgrading from PostgreSQL 9.3

2018-11-12 Thread Pavel Stehule
Hi po 12. 11. 2018 v 10:18 odesílatel Karl Martin Skoldebrand < ks0c77...@techmahindra.com> napsal: > Are there any recommendations regarding upgrading from PG 9.3 to 9.6 or > 10.x? > > I found a few changes at > https://severalnines.com/blog/upgrading-your-database-to-postgresql-version-10 >