docs:mac:builds:postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
docs:mac:builds:postgresql [2008/06/10 00:32] billhdocs:mac:builds:postgresql [2012/04/25 23:05] (current) – [PostgreSQL] billh
Line 13: Line 13:
 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 
  
 +(to shut down the server)
 +/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)
Line 48: Line 49:
 ===== External Links ===== ===== External Links =====
   * http://www.postgresql.org/docs/8.3/interactive/postgres-user.html   * http://www.postgresql.org/docs/8.3/interactive/postgres-user.html
- 
  • docs/mac/builds/postgresql.1213079520.txt.gz
  • Last modified: 2008/08/03 00:25
  • (external edit)