Just somewhere to keep my notes while I'm playing.

Tuesday, May 6, 2008

First Steps

I have set a unix password for postgres, and started /etc/init.d/postgresql

su - postgres
made a directory called: '/var/lib/pgsql/cddb_data' owned by postgres

run psql

CREATE USER timj WITH PASSWORD 'xxxxxxxx' ;
CREATE TABLESPACE ts_cddb_1 OWNER timj LOCATION '/var/lib/pgsql/cddb_data';
CREATE DATABASE cddb OWNER timj TABLESPACE ts_cddb_1;

This gives me all I need to pgAdminIII, and I have completed objectives 1, 2 and 3!

No comments: