Friday, December 14

Author: Liaqat Andrabi

Webinar : Introduction to OmniDB [Follow Up]

2ndQuadrant, Liaqat's PlanetPostgreSQL, OmniDB
A database management tool that simplifies what is complex and drives performance. OmniDB is one such tool with which you can connect to several different databases - including PostgreSQL, Oracle, MySQL and others. 2ndQuadrant recently hosted a webinar on this very topic: Introduction to OmniDB. The webinar was presented by OmniDB co-founders and PostgreSQL consultants at 2ndQuadrant, Rafael Castro & William Ivanski. The recording of the webinar is now available here. Questions that Rafael and William couldn’t respond to during the live webinar have been answered below. Q1: There are other open source GUI tools around to manage PostgreSQL. Why are you investing efforts on a new tool? A1: When OmniDB was created we wanted a web tool, and not all available tools (more…)

Webinar: PostgreSQL is NOT your traditional SQL database [Follow Up]

2ndQuadrant, Liaqat's PlanetPostgreSQL
PostgreSQL is referred to as "The world’s most advanced open source database" - but what does PostgreSQL have that other open source relational databases don't?   2ndQuadrant recently hosted a webinar on this very topic: PostgreSQL is NOT your traditional SQL database, presented by Gülçin Yıldırım Jelínek, Cloud Services Manager at 2ndQuadrant. The recording of the webinar is now available here. Questions that Gülçin couldn’t respond to during the live webinar have been answered below. Q1: What exactly is the role of postgresql for a marketplace like ebay or rakuten? A1: This question is not very clear. If the question is about whether Postgres can be used in an e-commerce website, the answer is yes.   Q2: I'm in process of switching from MS SQL (more…)

Webinar : New Features in PostgreSQL 11 [Follow Up]

Liaqat's PlanetPostgreSQL, PostgreSQL
PostgreSQL 11, the next major release of the world’s most advanced open source database, is just around the corner. The new release of PostgreSQL will include enhancements in partitioning, parallelism, SQL stored procedures and much more. To give PostgreSQL enthusiasts a deeper look into the upcoming release, 2ndQuadrant hosted a Webinar discussing the new features in PostgreSQL 11. The webinar was presented by Peter Eisentraut, Core Team Member and Major PostgreSQL Contributor. If you weren’t able to make it to the live session, you can now view the recording here. Questions that Peter couldn’t respond to during the live webinar have been answered below. Q: Could you use a custom hash function for partitioning? (or is this in future plans) A: This is currently not (more…)

Webinar : Database Security in PostgreSQL [Follow Up]

Liaqat's PlanetPostgreSQL, Webinars
Database security is an increasingly critical topic for any business handling personal data. Data breach can have serious ramifications for an organization, especially if the proper security protocols are not in place. There are many ways to harden your database. As an example PostgreSQL addresses security using firewalls, encryption and authentication levels among other ways. 2ndQuadrant hosted a webinar on Database Security in PostgreSQL to highlight security concepts, features and architecture. The webinar was presented by Kirk Roybal, Principal Consultant at 2ndQuadrant - the recording is now available here. Some of the questions that Kirk responded to are listed below: Q1: What are your thoughts on performance of row-level security vs. doing that filtering via WHERE at (more…)

PGInstaller – A Step by Step Guide to install PostgreSQL

2ndQuadrant, Liaqat's PlanetPostgreSQL, PGInstaller, PostgreSQL
Here’s a step by step guide to install PostgreSQL on your machine using PGInstaller. PGInstaller supports three modes of installation; Graphical, Unattended and Text. We’re going to cover all three of them in this guide. To Install PostgreSQL via Graphical Mode Step 1: Download PGInstaller here. PGInstaller is available for PostgreSQL 9.5, 9.6, 10, and 11(beta). Step 2: Click on the executable file to run the installer. Step 3: Select your preferred language. Step 4: Specify directory where you want to install PostgreSQL. Step 5: Specify PostgreSQL server port. You can leave this as default if you’re unsure what to enter. Step 6: Specify data directory to initialize PostgreSQL database. Step 7: Create a PostgreSQL user (more…)

Webinar : Ansible & PostgreSQL [Follow Up]

2ndQuadrant, Liaqat's PlanetPostgreSQL, Webinars
PostgreSQL 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 was presented by Tom Kincaid, GM North America at 2ndQuadrant, who gave an overview of Ansible and PostgreSQL, covered best strategies for deployments, and a variety of other topics. If you weren’t able to make it to the live session, you can now view the recording here. For any questions, comments, or feedback, please visit our website or send an email to [email protected] (more…)

PGInstaller – A GUI based, user-friendly installer for PostgreSQL

2ndQuadrant, Liaqat's PlanetPostgreSQL, PGInstaller, PostgreSQL
Installing the world’s top enterprise-class open source database - PostgreSQL - is now a whole lot easier with PGInstaller. PGInstaller 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 and 11(beta) and has the ability to run in graphical, command line, or quiet installation modes. In addition, PGInstaller provides the following features: Built-in support for Python 3 Compression support using zlib Integration with native service control managers such as systemd for Linux, Service Control Manager for Windows, and LaunchControl for OSX Consistent interface across all supported platforms How to get started with PGInstaller: (more…)

Introduction to Postgres-BDR [Webinar Follow-up]

2ndQuadrant, Liaqat's PlanetPostgreSQL, Webinars
The announcement of Postgres-BDR 3.0 last month at PostgresConf US had been long-awaited in the PostgreSQL community. Complex use cases from customers have driven the development of BDR far beyond the original feature set, resulting in a more robust technology than ever imagined - so we're happy to say that it was worth the wait. Postgres-BDR (Bi-Directional Replication) enhances PostgreSQL with advanced multi-master replication technology that can be used to implement very high availability applications. For an introduction to Postgres-BDR covering an overview of its complex architecture and its common use cases - 2ndQuadrant held the "Introduction to Postgres-BDR" webinar as part of its PostgreSQL webinar series. The webinar was presented by Simon Riggs, Founder and CEO of (more…)

Power of Indexing in PostgreSQL [Webinar Follow-up]

Liaqat's PlanetPostgreSQL, Webinars
Given the massive size, complexity, and performance requirements of most databases, having an optimized database is critical for many organizations. A variety of different strategies are used for database performance enhancement - indexing being one of them. Since indexing is such a key component to database performance, 2ndQuadrant chose to highlight the power of indexing in the third instalment of their PostgreSQL webinar series. Power of Indexing in PostgreSQL was conducted by Pavan Deolasee, PostgreSQL contributor and developer at 2ndQuadrant. He covered various topics such as accessing data in PostgreSQL and types of indexes supported as well as their internals. If you weren’t able to make it to the live session, you can now view the recording here. Questions that (more…)

Webinar: Data Integration With PostgreSQL [Follow Up]

Liaqat's PlanetPostgreSQL, Webinars
Having 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 is critical. This week on Tuesday, 13 February, 2ndQuadrant hosted the second webinar in their PostgreSQL webinar series. Principal Consultant, Shaun Thomas, conducted the webinar, covering various topics around integration of PostgreSQL with other data sources and database technologies. The recording of the Webinar is now available. Those who couldn’t make it to the live session can now view Data Integration with PostgreSQL here. Below, (more…)