Postgres Basics on Ubuntu 8.10

sudo apt-get install postgresql postgresql-client postgresql-contrib

Changing the User Password
sudo -u postgres psql postgres
ALTER USER postgres WITH ENCRYPTED PASSWORD ‘<***password***>’;

Creating a New DB
sudo -u postgres createdb dev

Setting up PgAdmin III
Don’t know exactly what this is good for, better performance?
sudo -u postgres psql < /usr/share/postgresql/8.3/contrib/adminpack.sqll

Installing PgAdmin III
sudo aptitude install pgadmin3

Leave a Reply

Your email address will not be published. Required fields are marked *