Wednesday, November 7, 2007

How to Install PostgreSQL

http://www.supriyadisw.net/2007/02/postgresql-on-ubuntu-linux

Or just do this:

sudo apt-get install postgresql-8.2
sudo -u postgres psql template1
template1=# ALTER USER postgres WITH PASSWORD 'secret';
template1=# \q
sudo -u postgres createdb mydatabase
sudo gedit /etc/postgresql/8.2/main/pg_hba.conf
- I chose METHOD 'password' for IPv4 local connections

sudo /etc/init.d/postgresql-8.2 restart

No comments: