Active4 years, 4 months ago

Postgresql Client Download
Mac Install Postgresql

How can I start a PostgreSQL database and connect with a client in terminal?

I've tried this after installing postgreSQL with brew.

This is a quick guide for installing PostgreSQL (Postgres for short) on a Mac with Homebrew, and starting and stopping it with Lunchy.If you've just forked a Ruby on Rails project that requires Postgres, this tutorial will get you up and running in no time. PG Commander is a client for everyone working with PostgreSQL databases. Display tables and views in a gorgeous user interface. Filter Table Rows by searching all columns, or combine filters for complex queries. SQLPro for Postgres is a sequel pro like database application for editing and viewing PostgreSQL databases on mac os x.

Results in this:

Then I try to start database with:

Which gives:

coffee.isGoodcoffee.isGood

2 Answers

You must create a data directory first and input its name after -D. Say if the data directory you created is /usr/local/bin/psql, then your init command will be

TavoloPerUnoTavoloPerUno

From the PostgreSQL pg_ctl documentation:

-D datadir

--pgdata datadir

Specifies the file system location of the database configuration files. If this is omitted, the environment variable PGDATA is used.

You are specifying your pgsql executable as your data directory.

Politank-ZPolitank-Z

Postgresql Client Download

2,8092 gold badges16 silver badges26 bronze badges

Mac Install Postgresql

Not the answer you're looking for? Browse other questions tagged postgresqlosx-mavericks or ask your own question.

Postgres Database Client For Mac