The following is a quick guide to install postgres 8.2 on Ubuntu 7.04, but it might also work for older version of postgres and Ubuntu, and other Debian based distros.

Firstly, enter the following command to install postgres, enter the password on prompt.



This installs both server and client postgres on your machine, but the server is more relevant in this article.

Secondly, we need to reset the 'postgres' user password, which is the admin account for the postgres server:

Login as the root:



Then login to postgres without needing a password



Now login to the postgres template database:



Type in



to quit.

The password for the postgres account in the database has been updated, now we need to do the same for unix user 'postgres':

Clear the password for postgres first,



Then update the password



Now enter the same password that you used previously.

You should now be able to login to postgres using the 'postgres' account:



A welcome message should display:



The database should be empty, and you are ready to start creating new databases and tables.