Differences

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

--- docs:mac:builds:postgresql [2008/06/09 00:10] – billh
+++ docs:mac:builds:postgresql [2012/04/25 23:05] (current) – [PostgreSQL] billh
@@ Line 13: / Line 13: @@
 sudo su - postgres
 /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/psql test
+(to shut down the server)
+/usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data -m fast
 </code>
+===== Clients =====
+  * psql (command line, included with PostgreSQL)
+  * [[http://www.pgadmin.org/|pgAdmin]] (GUI)
+===== Mac OS X Startup Item =====
+Postgres source code (at least as of 8.3.1) contains a startup script package for OS X.  Go to <pg build dir>/contrib/start-scripts/osx, and run this:
+<code>
+sudo /bin/sh ./install.sh
+</code>
+Your /etc/hostconfig file will also be modified to include the line below.  You can set it to -NO- if you don't want Postgres to load when your computer starts up:
+<code>
+POSTGRESQL=-YES-
+</code>
+You can now manually control the server with these:
+<code>
+sudo /Library/StartupItems/PostgreSQL/PostgreSQL start
+sudo /Library/StartupItems/PostgreSQL/PostgreSQL stop
+sudo /Library/StartupItems/PostgreSQL/PostgreSQL restart
+</code>
 ===== See Also =====
@@ Line 25: / Line 49: @@
 ===== External Links =====
   * http://www.postgresql.org/docs/8.3/interactive/postgres-user.html