PostgreSQL Blogs

/PostgreSQL Blogs

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

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

In the previous post, we provided a business and architectural background for the Postgres FDWs that we are developing for Spark, Hadoop and Cassandra. In particular, we highlighted the key benefits of bringing Cassandra and PostgreSQL together. With this post, we will start taking a more technical look at the Cassandra FDW. The C* FDW [...]

By | September 23rd, 2016|Affan PostgreSQL, OpenSCG, PostgreSQL Blogs|0 Comments

pgBackRest with PostgreSQL Sandbox on Debian / Ubuntu

pgBackRest is one of the most powerful backup solutions available for PostgreSQL. It has enterprise level features like compression, multiple channels (threads) of backup execution, incremental and differential backups etc. The official documentation is Debian-centric in its focus. I wanted to test it out with the PostgreSQL sandbox from the BigSQL project. Setting up PostgreSQL Sandbox and Installing pgBackRest The BigSQL [...]

By | July 26th, 2016|Jobin PostgreSQL, PostgreSQL Blogs|0 Comments