Initial Postgres Setup for Ubuntu

After installing postgresql, here are the first few things I usually do. I'm usually running Ubuntu, but these would be necessary for any postgres install.

1. Create database users
   $ sudo su - postgres        # become the postgres user
$ createuser -P lance       # I'm usually a super user
$ exit                      # exit out of the postgres user
$ createuser account1 ...   # Create the standard accounts

   
2. Setup conf files
   $ sudo vi /etc/postgresql/8.2/main/pg_hba.conf
$ sudo vi /etc/postgresql/8.2/main/postgresql.conf

   
3. Move Data to separate partition (/data)
   $ sudo /etc/init.d/postgresql-8.2 stop
$ sudo mv /var/lib/postgresql/8.2 /data/postgresql/8.2
$ sudo ln -fs /data/postgresql/8.2/main /etc/postgresql/8.2/main/pgdata
$ sudo /etc/init.d/postgresql-8.2 start

   
4. Setup admin pack
   $ sudo -u postgres psql < /usr/share/postgresql/8.2/contrib/adminpack.sql