This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |
| docs:mac:builds:postgresql [2012/04/24 23:35] – billh | docs:mac:builds:postgresql [2012/04/25 23:05] (current) – [PostgreSQL] billh |
|---|
| sudo su - postgres | sudo su - postgres |
| /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data | /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data |
| (cd to or replace logfile with your desired logfile name) | (cd to or replace postgres.log with your desired logfile name and location) |
| /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 & | /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data > /usr/local/pgsql/log/postgres.log 2>&1 & |
| /usr/local/pgsql/bin/createdb test | /usr/local/pgsql/bin/createdb test |
| /usr/local/pgsql/bin/psql test | /usr/local/pgsql/bin/psql test |
| /usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data -m fast | /usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data -m fast |
| </code> | </code> |
| |
| ===== Clients ===== | ===== Clients ===== |
| * psql (command line, included with PostgreSQL) | * psql (command line, included with PostgreSQL) |