How-to Run the PostgreSQL 9.x Server on Mac OS X after Installation Visual-Guide

PostgreSQL 9.X Quick-Start for Mac OS X

The Tutorial Shows You Step-by-Step How-to Getting-Started with PostgreSQL 9.X Database on Mac 10.9 Mavericks OS X.

As with every annual release, PostgreSQL 9.x includes many New Features to make working with PostgreSQL easier, more flexible and more fun for application developers, administrators and architects.

The New PostgreSQL Features include:

• Additional JSON constructor and extractor methods
• Automatically updatable VIEWs
• Parallel pg_dump to speed backups of large databases
• LATERAL JOINs

Further, PostgreSQL 9.4’s User-Defined Background Workers allow developers to write task managers, request handlers, parallel processors, queuing tools and other helper applications to enable PostgreSQL as a workload coordinator.

One example of this already released is Mongres, a background worker which accepts MongoDB queries, interprets them and passes them on to PostgreSQL.

1. Getting-Started with Latest PostgreSQL on Mac OS X:

   PostgreSQL Quick-Start Mac

   Setup PostgreSQL Mac.

2. Run the pgAdmin3 DB UI

3. Start the PostgreSQL Server:

   Right-Click >> Connect
   

4. Authorize:

   
   Insert the “postgres” User Pass!

   How-to Reset PostgreSQL Pass on Mac OS X:

   PostgreSQL Troubleshoot Mac

   Troubleshooting PostgreSQL Mac.

5. Start Managing the Database Instances:

   

Tags: Database, How-to, Mac Os X, PostgreSQL, postgresql 9.3, postgresql mac os x, run postgresql server mac os x, Tutorial, Visual-Guide