I have been posting on my blog about getting LibreOffice Base and PostgreSQL working together. My latest actually focuses on getting multiple users connecting to a single, remote, stand-alone PostgreSQL server. You can set this up fairly quickly and - in my case, anyway - with no programming involved.
Of course, if you want to enforce business rules and security, you'll need to employ server-side tools and programming, as well as possibly using Base macros or Python on the client side. I am not yet certain about how to implement transactions, so that (following the project below), one can complete a form and press a "Submit" button to make the whole transaction fire at once.
My previous post is not so much of a tutorial, but more of an opportunity to showcase a small project using LibreOffice Base as a front-end to PostgreSQL.