pg_terminate_backend for non-superusers

The problem

Last week I had to give the permission to one user to kill PostgreSQL connections in a development environment, but I found that pg_terminate_backend and pg_cancel_backend functions can only be executed by a superuser and I didn’t want to give such privileges so I started looking for a solution and at the end I implemented two . . .

Read More

April 19, 2016

Starting the blog!

This is the very first post of a blog where I will write the DBA stuff I have to work with every day, the DBA daily stuff!

My main background is in Microsoft SQL Server, but I’m also working with PostgreSQL and Oracle.

I’m also using Powershell for scripting.

I hope you enjoy it and find it useful!

Read More

April 19, 2016