Are you a software developer? Do you need to setup a local PostgreSQL server for development on your machine and you’ve struggled with it in the past? Then don’t waste your time. If you follow the directions laid out in the post then you should be up and running quickly.

Debian GNU/Linux

If you work with Debian GNU/Linux, the best way to install the latest version of PostgreSQL is to use the packages provided by the PostgreSQL project. The latest packages may be found here. Once on the page, you’ll want to choose which version of Debian GNU/Linux you’re using from the drop-down list then add the link to your APT sources list, retrieve and install the key provided by the project to sign packages, then use APT to install the version of PostgreSQL you wish to install. Below this paragraph you will find a sequence of commands that correspond to what I just wrote and an additional set of...