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.
Getting-Started with Latest PostgreSQL on Mac OS X:PostgreSQL Quick-Start Mac
Run the pgAdmin3 DB UI
Start the PostgreSQL Server:
Right-Click >> Connect
Insert the “postgres” User Pass!
How-to Reset PostgreSQL Pass on Mac OS X:PostgreSQL Troubleshoot Mac
Start Managing the Database Instances: