PostgreSQL Installation in Ubuntu 8

I've gotten postgreSQL installed on my VPS. I decided on it over mysql primarily because some of the tools (namely trac) work better with it. Here is the process I followed:

• Install Postgre
  
  
  
  • sudo apt-get install postgresql
  
  
  • I chose not to install pgadmin3 as this is running on a remote VPS; I will have no ability to use the graphic command line client. Also, its 68.5 meg size was a little hefty. I will do my administration via command line and dbvisualizer.
  
  
  
  


• Set postgres linux user password
  
  
  
  • sudo passwd postgres
  
  
  
  


• Set postgres user password
  
  
  
  • sudo -u postgres psql postgres
  
  
  • \password postgres
  
  
  
  


• Create a database
  
  
  
  • CREATE DATABASE [name];
  
  
  • list databases: \l
    
  • connect to database: \c [name]
  
  
  
  


• Create a table
  
  
  
  • CREATE TABLE [table_name] (id SERIAL);
  
  
  • describe table: \d [table_name]
  
  
  
  

This couldn't be easier to get up and running. The server is not yet accepting remote connections. I will be working on that next and posting instructions.