Posts

[Video] Data Integration with PostgreSQL

Just in case you missed the live broadcast, the video of my presentation below covers various topics around integration of PostgreSQL with other data sources and database technologies. This presentation covers the following topics: What is a Foreign Data Wrapper? How to query MySQL, a Flat file, a Python script, a REST interface and a […]

Webinar: Data Integration With PostgreSQL [Follow Up]

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 […]

Untangling the PostgreSQL upgrade

PostgreSQL 9.6 has just been released and most of the postgres users will start asking themselves how to upgrade to the new major version. This post has the intention of showing different procedures for upgrading your PostgreSQL server. Upgrading to a new major version is a task which has a high ratio of preparation over […]

Conference isn’t enough?! Join us for post-conference training!

Did you know – 2ndQuadrant has the largest single, collection of PostgreSQL experts of any company globally?! With a team of some of the best known developers, they all still actively contribute to the progressive development of PostgreSQL. Would you like to have access to some of the most knowledgeable and experienced people available? The […]

Keen on Kanban? The 5432…MeetUs! Conference can teach you everything you need to know!

Keynote speakers are always something everyone looks forward to at conferences.  We’re particularly looking forward to seeing Dragos Dumitriu team up with our very own Gabriele Bartolini at the 5432…MeetUs! conference in Milan, Italy June 28 and 29. Dragos Dumitriu is an industry leader in the Agile community and renowned Kanban expert – helping to improve […]

PGLogical 1.1 released with sequence support and more

The new feature version of pglogical is now available. The new release brings support for sequence replication, manually configured parallel subscriptions, replica triggers, numerous usability improvements and bug fixes. Let’s look into the changes in more detail.

PostgreSQL 9.5: IMPORT FOREIGN SCHEMA

The release of PostgreSQL 9.5 is imminent so the time has come to analyse what’s new in this latest version. A very interesting feature of version 9.5 is the ability to import a schema from a remote database, using Foreign Data Wrapper and the IMPORT FOREIGN SCHEMA command.