I have a dedicated database server running PostgreSQL 9.3 on CentOS 6.4 Linux. The database server is fairly vanilla. Nothing crazy but a standard installation of the software on Linux with a few roles I've created.

I'm trying to have my LibreOffice Base application connect to PostgreSQL and I'm not sure what driver I need / must use. There SDBC / JDBC / ODBC drivers...all of them being unique and on top of that, I'm not sure where I need to install the drivers. Would I need to install them on my PostgreSQL server or on my local MacBook Pro running LibreOffice:Base 4.1.x?

Can anyone please help me sort this out?

A quick search turned up this: https://wiki.documentfoundation.org/PostgreSQL-SDBC

You'll have to confirm that it's supported on LO for Mac though

So my MacBook Pro needs to have the SDBC driver installed/ enabled to connect to the dedicated PostgreSQL server, correct?

I believe so.