Posts
Webinar : Ansible & PostgreSQL [Follow Up]
/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiPostgreSQL administration, configuration, and deployment can be a tough ask while working in an agile environment with strict deadlines. The key to simplify these operational tasks for PostgreSQL is Ansible – an open source IT automation tool. To explain how these technologies work together, 2ndQuadrant hosted a Webinar on PostgreSQL deployments using Ansible. The webinar […]
Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
/1 Comment/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Postgres Installer, PostgreSQL /by Liaqat AndrabiInstalling the world’s top enterprise-class open source database – PostgreSQL – is now a whole lot easier with Postgres Installer. Postgres Installer is a GUI based, user-friendly installer for PostgreSQL that is digitally signed and certified by 2ndQuadrant. The installer is currently available for PostgreSQL versions 9.5, 9.6, 10, 11 and 12(beta) and has the […]
2ndQuadrant at PostgresConf US 2018
/0 Comments/in 2ndQuadrant, PostgreSQL /by Marriya MalikThe world of PostgreSQL continues to grow stronger by the year! Last week we saw it all come together at PostgresConf US 2018 in Jersey City. The conference was held to promote awareness and usage of PostgreSQL through tutorials and case-studies, as well as providing the opportunity to listen first hand to some of the best […]
Partition Elimination in PostgreSQL 11
/16 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David RowleyThe feature freeze for the PostgreSQL 11 release is now upon us. During the last few days my colleague Álvaro Herrera pushed two changes into the development branch of PostgreSQL: 1. Faster Partition Pruning 2. Partition Pruning at Execution Time These patches aim to improve the performance and usability of the declarative table partitioning feature […]
Don’t be hard-headed… Harden your PostgreSQL database to ensure security
/0 Comments/in 2ndQuadrant, Britt's Marketing /by Britt ColeWhen it comes to database security, the risk is definitely not worth the reward. Being hard-headed about database security procedures can not only disrupt your business and cost you millions, but it can make irreparable damage to your customer relationship and public identity. How important is the security of your data to your organization Nearly […]
Prague PostgreSQL Meetup
/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, International News, PostgreSQL, User Group /by Gulcin YildirimLast month, I was at 2ndQuadrant booth at P2D2, an annual conference organized in Prague by local user group called CSPUG (Czech and Slovak PostgreSQL User Group). The conference was certainly a huge success and more than 200 people showed up! Meeting a lot of PostgreSQL enthusiasts in town, I wondered why there are no regular meetups […]
Dev Corner: error context stack corruption
/4 Comments/in Craig's PlanetPostgreSQL /by craig.ringerPostgreSQL uses error context callbacks to allow code paths to annotate errors with additional information. For example, pl/pgsql uses them to add a CONTEXT message reporting the procedure that was executing at the time of the error. But if you get it wrong when you use one in an extension or a patch to core, […]
PostgreSQL 11 – Server-side Procedures (Part 2)
/7 Comments/in 2ndQuadrant, Umair's PlanetPostgreSQL /by Umair ShahidTransaction control in PL procedures A couple of months back, I wrote about how we now have the ability to write Stored Procedures in PostgreSQL. This post follows up on that and talks about the next step that was implemented: transaction control in PL procedures. The feature was committed on 22-Jan-2018. With this addition, you […]
Webinar: Data Integration With PostgreSQL [Follow Up]
/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiHaving a unified view when combining data from different sources is essential for every business. Whether you want to connect to a cloud application, import/export data to/from a text file, or sync data between your datasource and a 3rd party platform – having a database platform that provides a seamless and effective data integration process […]