User:Bourke/postgresql

Initial Setup (Ubuntu Lucid 10.04, guest or host)

Ubuntu Community PostgreSQL Article

here the output of the db setup stage

 Setting up postgresql-8.4 (8.4.8-0ubuntu0.10.04) ...
 Creating new cluster (configuration: /etc/postgresql/8.4/main, data: /var/lib/postgresql/8.4/main)...
 Moving configuration file /var/lib/postgresql/8.4/main/postgresql.conf to /etc/postgresql/8.4/main...
 Moving configuration file /var/lib/postgresql/8.4/main/pg_hba.conf to /etc/postgresql/8.4/main...
 Moving configuration file /var/lib/postgresql/8.4/main/pg_ident.conf to /etc/postgresql/8.4/main...
 Configuring postgresql.conf to use port 5432...
 update-alternatives: using /usr/share/postgresql/8.4/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode.
  * Starting PostgreSQL 8.4 database server                               [ OK ]

upgrade zu postgres 9 auf 10.04

not quite correct, careful