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.
sudo port install postgresql81 +server
will install postgresql
sudo gem install postgres -- --with-pgsql-include-dir=/opt/local/include/postgresql81 --with-pgsql-lib-dir=/opt/local/lib/postgresql81
Will do a gem install
Start your server automatically by doing:
sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql81-server.plist
sudo launchctl start org.macports.postgresql81-server
Create a folder for your dbs
mkdir /opt/local/var/db/pgsql/data
Add pgsql to your path (I use textmate)
mate ~/.profile
My path looks like that:
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"
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:
postmaster -D /opt/local/var/db/pgsql/data
or
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.
Comments