Phil Hankison

Senior Consultant, Professional Services, EDB

Phil has 25 years experience working with relational database systems and is a Senior Consultant in the Professional Services Division of EnterpriseDB. Located in Sweden, Phil works mainly in EMEA (specifically the Nordics) but often spends time on client sites around the world, delivering training, as well as specialised knowledge transfer and professional services on topics including configuration, testing and coding of database systems. Phil is a regular public speaker and trainer who has developed expertise in explaining complex technology to audiences. Previously, he has worked as a freelance consultant around the world supporting well-known companies in diverse sectors, including banking, telecommunications, utilities and the legal sector.

Read Blogs

Postgres Tutorials

How to Connect PostgreSQL using SQL Developer, Visual Studio and DBeaver

So, you’ve installed your Postgres database, whether Community Edition, EDB Postgres Advanced Server or one of many other cloud, container, or Database as a Service offerings out there. Now what next? Well, the first thing you are going to do (once you have secured your new database) is access it, and use it to store and distribute your data. Which means you are going to need a design and...

Can PgBouncer survive transient network events?

This is the final part of my technical responses to a series of questions about the use of PgBouncer. To read the other posts in the series, use the links below.
EDB Labs

Can PgBouncer session survive everything we throw at it?

This is part four of my technical response to a series of questions about the use of PgBouncer and what you need to look out for. To read the other posts in the series, use the links below.
EDB Labs

Can PgBouncer handle failover to a new machine?

Part Three: PgBouncer and persistent connections during downtime (This is part three of my technical response to a series of questions about the use of PgBouncer and what you need to look out for. Part two can be found here ) So, now we have successfully renegotiated a one-minute network timeout, and a server restart, all within a single PgBouncer session, and have done so silently. To a user in...
EDB Labs

PgBouncer Connection Pooling: What to do when persistent connectivity is lost

So, in Part One of this blog we completed the installation of PgBouncer, configuration and a brief network timeout using PgBouncer with no problem at all. But what happens with a minute’s downtime, and what if we’re in the middle of a transaction while it happens? Does PgBouncer maintain connectivity, without error, even when the connection to the database is catastrophically lost?
EDB Labs

PgBouncer Tutorial: Installing, configuring and testing persistent PostgreSQL connection pooling

Connection pooling is a big deal in Postgres. Connections to the database can take a relatively large amount of overhead, especially if there are a lot of them, and here at EDB Professional Services we often recommend an open-source tool called PgBouncer to reuse and buffer connections between the database and application. Assuming you are using a flavor of *NIX, it may be worth noting that each...
Product Updates

Build the Essential Skills to Be a Successful PostgreSQL DBA

Open source databases are becoming an increasingly preferred option for organizations seeking high performance, lower cost alternatives to legacy databases. If you’d like to increase your Postgres skills, EnterpriseDB just announced that it will be offering two training courses this coming fall titled “Comprehensive PostgreSQL Administration”, hosted in London and Amsterdam.