I’m working on a Rails project and I need to make sure that our code is compatible with PostgreSQL. I never installed/used before and since I’m lazy and rely on other people knowledge, I decided to install Postgresql using MacPort.
It was actually simpler than I expected. I simply followed this post and almost everything went ok.
<code>sudo port install postgresql81 +server </code>
will install postgresql
<code>sudo gem install postgres -- --with-pgsql-include-dir=/opt/local/include/postgresql81 --with-pgsql-lib-dir=/opt/local/lib/postgresql81 </code>
Will do a gem install
Start your server automatically by doing:
<code>sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql81-server.plist sudo launchctl start org.macports.postgresql81-server </code>
Create a folder for your dbs
Add pgsql to your path (I use textmate)
<code>mate ~/.profile </code>
My path looks like that:
<code>export PATH=/opt/local/bin:/opt/local/sbin:/opt/local/apache2/bin:/opt/local/lib/postgresql81/bin/:$PATH export PGDATA="/opt/local/var/db/pgsql/data" </code>
restart your shell (or open a new tab) and type
initdb -D /opt/local/var/db/pgsql/data
Success. You can now start the database server using:
<code>postmaster -D /opt/local/var/db/pgsql/data </code>
pg_ctl -D /opt/local/var/db/pgsql/data -l logfile start
Now, create your db: $ createdb test -E utf8 or drop your newly created db: $ dropdb test
That’s it, it was easy.