Re: Dynamic procedure execution

2020-12-28 Thread Muthukumar.GK
Hi Adrian Klaver, Sorry for typo mistake. Instead of writing lengthy query, I had written it simple. Actually my main concept is to bring result set with multiple rows (using select query) with help of dynamic query. When calling that procedure in Pgadmin4 window, simply getting the message as

Re: Partitioned Table conversion to Non-Partition table in postgresql open source

2020-12-28 Thread Hellmuth Vargas
Hi I had already read about some procedures to do that https://www.enterprisedb.com/blog/postgres-partition-upgrade-your-partitioning-inheritance-declarative https://www.2ndquadrant.com/en/blog/how-to-migrate-from-inheritance-based-partitioning-to-declarative-partitioning-in-postgresql/ El lun

Re: Is there a good discussion of optimizations?

2020-12-28 Thread Michael Lewis
On Wed, Dec 23, 2020 at 6:56 PM Guyren Howe wrote: > I’d like to put together a good video and writeup about what the… > philosophy behind relational databases is. > > Most folks, in my experience, who use relational databases don’t really > understand the basic theory or even more important the

Re: PostgreSQL HA

2020-12-28 Thread Andreas Kretschmer
Am 26.12.20 um 17:20 schrieb venkata786 k: Hi Ganesh, BDR supports postgres 12 & 13 versions ?? I think we have BDR compatible for 9.4 postgres. Could you plz confirm. That's true. PG 9.4 is out of support. Regards, Andreas -- 2ndQuadrant, an EDB company www.2ndQuadrant.com / www.enterp

Re: PostgreSQL HA

2020-12-28 Thread Jehan-Guillaume de Rorthais
On Sat, 26 Dec 2020 05:51:22 +0530 venkata786 k wrote: > Hi Team, > > Could you please share postgresql's best active(R/W)-active(R/W) (multi > master replication) solutions. > My Team is thinking about implementing active-active replacing master-slave. Symmetric replication bring a lot of comp

Partitioned Table conversion to Non-Partition table in postgresql open source

2020-12-28 Thread Brajendra Pratap Singh
Hi, Currently we are running on open-postgresql 9.6 version with some partitioned Table which we need to convert from Inheritance partitioning to declarative partitioning during migration to 12.3 open-postgresql version. Is there any safest and faster way to fulfill this requirement, Please sugge