Securing your PostgreSQL database
Malcolm is a PostgreSQL DBA, Linux admin, Java/PHP developer, tinkerer and a bit of a pedantic perfectionist, having over 13 years of experience with PostgreSQL and somewhat more than that with Linux and development.
He is also an organiser of PostgresConf South Africa.
No video of the event yet, sorry!
Securing access to your database and data seems obvious, but are you doing enough? The default settings within PostgreSQL and even the default firewall configuration on stock Linux installs are a far cry from being secure.
Even if you're not handling or storing credit card information, PCI-DSS defines many things to do in order to secure access to a database and operating system, which can be applied by just about everyone to varying levels of paranoia.
We will cover the various ways to secure your database and operating system, how to restrict access at a data level and how PostgreSQL handles users, rights and permissions. We will also look at one of the biggest differences in the way PostgreSQL and MySQL handle users.
- 30 min
- South Africa 2017