For Mac

For Linux

Postgres For Mac Applications

For APT systems (Ubuntu, Debian, Mint, Etc)

Download Navicat Ess 15 for PostgreSQL for macOS 10.11 or later and enjoy it on your Mac. ‎. Navicat Premium named “Best Database Administration Solution” by Database Trends and Applications Magazine. Best-in-Class Database Management Tools. Navicat Essentials for PostgreSQL is a powerful database administration.

Mac Os Install Postgresql

1. PostgreSQL is integrated in Server.app available through the App Store in Mac OS X v10.8. One of the simplest ways is to install Postgres.app from the official site.
2. I was just having this exact issue. When I ran which psql it was pointing at the Postgres client tools installed with Lion: /usr/bin/psql. Using a hint from Frank Wiles I ran ps auxw grep post to confirm that postgres was running and that it was running on the right port, that also showed me the postgres.app path.

For Arch Linux

For YUM installations (Fedora / Red Hat / CentOS / Scientific Linux)

(Example used is for PostgreSQL 9.2 on CentOS 6.4 x64)

1. Head over to PostgreSQL Yum Repository
2. Select the version of PostgreSQL that you want to install and then your OS, version and architecture.

3. Download the RPM for your platform (using the link from step 2)

   curl -O http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-centos92-9.2-6.noarch.rpm

4. Install the RPM

   rpm -ivh pgdg-centos92-9.2-6.noarch.rpm

5. Do a quick search which will show you available packages for postgres

   yum list postgres*

Note: It will probably list older versions as well, make sure to select proper version that you want to install and all the packages are of same version i.e server, client, contrib (not always necessary but better to be safe, right?)

Postgresql On Mac

1. Install Packages as per choice

   yum install postgresql92-server.x86_64 postgresql92-contrib.x86_64 postgresql92-devel.x86_64

For Windows