Tag Archives: postgresql

Using PostgreSQL With Ruby on Rails on OS X

Following on from my last post for getting PostgreSQL up and running nicely on Mac OS X, my next task was getting it playing nicely with ruby on rails - I’m off on a rails course next week so I’m … Continue reading

Posted in postgresql, ruby | Tagged , , , | 2 Comments

Install PostgreSQL on Mac OS X Leopard

This type of guide is all over the internet, but I’m too lazy to search for one every time I want to do this. So here’s a brief overview of how I got PostgreSQL set-up nicely on Mac OS 10.5… … Continue reading

Posted in mac, postgresql | Tagged , , , | 2 Comments

Install PostgreSQL on Ubuntu 8.04

Following up from my old guide to installing PostgreSQL (for Ubuntu 7.10), I thought i’d better do an update for the latest releases… This quick walk-through are my notes for installing the PostgreSQL database server and the PgAdmin administration application … Continue reading

Posted in linux, noteworthy, postgresql | Tagged , , | 70 Comments

Install phpPgAdmin on Ubuntu 7.10

Update: These instructions have been tested and work fine in the latest version of Ubuntu (8.04, Hardy Heron). phpPgAdmin is a web based GUI for administrating a PostgreSQL database server. Here’s some quick notes on getting it installed easily on … Continue reading

Posted in linux, postgresql | Tagged , , , , , | 13 Comments

Creating New Accounts in PostgreSQL

Getting a new account set up on PostgreSQL is a simple process… Create our new user: $ sudo su postgres -c createuser daz Then you have to give this new user role a name (I called it daz), and then … Continue reading

Posted in linux, postgresql | Tagged , , | 10 Comments

Install PostgreSQL on Ubuntu 7.10

If you are using the latest version of Ubuntu (8.04 - Hardy Heron), you might find these slightly updated instructions useful. This quick walk-through are my notes for installing the PostgreSQL database server and the PgAdmin administration application on Ubuntu … Continue reading

Posted in linux, noteworthy, postgresql | Tagged , , , , | 63 Comments