PostgreSQL

/PostgreSQL

Integrating Cassandra, Spark, PostgreSQL and Hadoop as a Hybrid Data Platform – Part 3

In a previous blog post we talked about the technical details behind the new CassandraFDW that enables PostgreSQL to connect to a Cassandra cluster. This provides PostgreSQL users the ability to easily read and write data to a very popular open source multi-master database that can support writes in multiple data centers. This means if [...]

By | November 14th, 2016|Affan PostgreSQL, PostgreSQL, PostgreSQL Blogs|2 Comments

Which standby was that again?

In any modern PostgreSQL installation, there's usually at least one streaming replication standby server feeding off your production master. In fact, there's usually several. Being the good PostgreSQL administrator that you are, you've already enabled logging of replication commands in postgresql.conf thusly: log_replication_commands = on But what you're probably not doing is having each standby [...]

By | November 3rd, 2016|Doug PostgreSQL, PostgreSQL, PostgreSQL Blogs|1 Comment

Extending Postgres by BigSQL

Recently we had a customer request to build a custom extension against Postgres by BigSQL distribution. Even though BigSQL ships with a large set of commonly used extensions and good collection of FDWs, these kind of user build requirements always crop up, based on how powerful the Postgres extension model is. BigSQL makes it easy [...]

By | October 25th, 2016|BigSQL, Jobin PostgreSQL, PostgreSQL, Uncategorized|0 Comments

Why Open Source over Open Source Based?

The Postgres landscape has become very competitive in recent years as the database project has matured and grown exponentially in popularity. Since more and more users are deploying Postgres to support a wide variety of applications, there is a need for experts to help make sure those deployments are successful. This has led to the [...]

By | October 18th, 2016|OpenSource, PostgreSQL|1 Comment

My PL/pgSQL code is stuck, but where?

In the short time that I am enhancing the PL profiler (https://bitbucket.org/openscg/plprofiler) I have been asked multiple times if it can be abused as a debugging aid. Not directly. The conversation goes something like this:Q: When my PL code is stuc...

By | July 16th, 2016|PostgreSQL|Comments Off on My PL/pgSQL code is stuck, but where?

PostgreSQL Studio 2.0 is out

PostgreSQL Studio is a fully open source web based UI for PostgreSQL that is ideal for Postgres in the cloud. With the impending release of PostgreSQL 9.5, PostgreSQL Studio 2.0 has just been released supporting some of the new features in Postgres. The big new feature that requires UI changes is support for Row Level [...]

By | December 1st, 2015|Jim PostgreSQL, OpenSCG, PostgreSQL|1 Comment

Synchronous Commit

While I was at PGConf.EU a couple of weeks ago in Madrid, I attended a talk by Grant McAlister discussing Amazon RDS for PostgreSQL.  While it was interesting to see how Amazon had made it very simple for developers to get a production PostgreSQL instance quickly, the thing that really caught my eye was the [...]

By | November 10th, 2014|Jim PostgreSQL, OpenSCG, PostgreSQL|Comments Off on Synchronous Commit

FTP I/O from PostgreSQL

PostgreSQL applications at times need to communicate with external servers using FTP. Oracle has the UTL_TCP package that is very useful for PL/SQL applications. PostgreSQL doesn’t have an equivalent package, but it does have something really powerful … the ability to write functions in various scripting languages. PostgreSQL has four languages that are part of [...]

By | August 21st, 2014|PostgreSQL, tip|Comments Off on FTP I/O from PostgreSQL