Difference between revisions of "Postgresql"
From John Freier
(Created page with "== OSX == The Postgres app live here on OSX /Library/PostgreSQL/11 Start sudo -u postgres ./bin/pg_ctl -D ./data start Stop sudo -u postgres ./bin/pg_ctl -D ./data sta...") |
|||
| Line 1: | Line 1: | ||
| + | == Test Database Connection == | ||
| + | This is a way to test the database connection. | ||
| + | ./pg_isready -h localhost -p 5432 | ||
| + | |||
| + | == Application Structure == | ||
| + | Log location | ||
| + | ./data/log/ | ||
| + | |||
== OSX == | == OSX == | ||
The Postgres app live here on OSX | The Postgres app live here on OSX | ||
| Line 7: | Line 15: | ||
Stop | Stop | ||
| − | sudo -u postgres ./bin/pg_ctl -D ./data | + | sudo -u postgres ./bin/pg_ctl -D ./data stop |
FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com. | FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com. | ||
Revision as of 14:31, 10 September 2019
Test Database Connection
This is a way to test the database connection.
./pg_isready -h localhost -p 5432
Application Structure
Log location
./data/log/
OSX
The Postgres app live here on OSX
/Library/PostgreSQL/11
Start
sudo -u postgres ./bin/pg_ctl -D ./data start
Stop
sudo -u postgres ./bin/pg_ctl -D ./data stop
FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com.
