Posts on Databases


Real time replication with PostgreSQL Part 2

By Dan • In Databases

In this second part of our two part post on real time data replication in PostgreSQL we're going to look at a simple setup of ‘hot standby’ master-slave replication in PostgreSQL.

For the purpose of demonstration we've setup a test rig with two virtual servers. The master server is on IP 192.168.1.100, and the standby is on 192.168.1.101.

Continue Reading

Real time replication with PostgreSQL Part 1

By Dan • In Databases

Every important business web application needs a database backup strategy and in most cases a scheduled backup at a frequency agreed with the customer is good enough. You sleep easy at night because you know you can restore from an x hours old copy. And that’s on top of the extra resilience provided by modern RAID configured disk storage.

Continue Reading

Calculating medians in PostgreSQL with percentile_cont

By Dan • In Databases

SkillsLogic is developing a big reporting and data dashboard solution and as part of that we need to calculate a lot of medians.

Remember from school, the median of a list of numbers is found by sorting the values from lowest to highest and then picking the middle one. If there’s no middle then the median is typically defined to be the mean of the two middle values.

Continue Reading

Contact Us

SkillsLogic Ltd,
Cooper Buildings,
Sheffield Science Park,
Arundel Street,
Sheffield,
S1 2NS

0114 383 00 93
info@skillslogic.com

SkillsLogic is a software development company

Follow us on Twitter: