Differences

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

--- docs:mac:builds:postgresql [2008/06/08 21:42] – created billh
+++ docs:mac:builds:postgresql [2012/04/25 23:05] (current) – [PostgreSQL] billh
@@ Line 9: / Line 9: @@
 sudo make install
-(untested from here down)
+sudo mkdir /usr/local/pgsql/data
+sudo chown postgres:postgres /usr/local/pgsql/data
-mkdir /usr/local/pgsql/data
+sudo su - postgres
-chown postgres /usr/local/pgsql/data
-su - postgres
 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
-/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
+(cd to or replace postgres.log with your desired logfile name and location)
+/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>
-FIXME - continue verifying install instructions
+===== 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 =====
+  * [[..:creating_startup_items]]
+===== External Links =====
+  * http://www.postgresql.org/docs/8.3/interactive/postgres-user.html