Installing PostgreSQL on Lion

On January 30, 2012, Posted by , In database administration,systems administration, By , With No Comments

Lion comes with a _postgres system account and PostgreSQL 9.0.4 client tools already installed. Lion Server includes PostgreSQL server, which replaces the MySQL server distributed with earlier versions of OS X. If you want to add PostgreSQL server to a regular Lion installation the easiest way to do this is…

Using Ruby with Postgres on Ubuntu 10.04 LTS

Installation of PostgreSQL on Ubuntu is straightforward, see http://library.linode.com/databases/postgresql/ubuntu-10.04-lucid To create a simple database with its own user use the command line: appenv=myapptst psql <<EOF create user ${appenv} createdb password ‘*****’; EOF createdb –username=postgres –owner ${appenv} ${appenv} To access the database from Rails use pg gem install pg Entries in…

pgLoader

On August 28, 2010, Posted by , In database administration, By , , With No Comments

One of the weaknesses of PostgreSQL compared to Oracle is the lack of a strong bulk loader utility like sqlldr. Natively Postgres offers only the COPY command, which does not include suppport for a bad file and reject log. EnterpriseDB have acknowledged the need for a better tool but it…