[Courses] [Postgresql] Oops!

Michelle Murrain michelle at murrain.net
Mon Nov 26 01:44:50 UTC 2007


Michelle Murrain wrote:

> So, first, configure, then "make" using gmake - this is the compile 
> step. Then install - this puts all of the Then you need to add a new 
> user, called postgres, who will be the admin user for the server. Create 
> a directory for the data that is owned by the postgres user. Then 
> initiate the database system (which creates the system tables). Start up 
> PG, create a database called 'test' and then use the client to interact 
> with that database.

What I should have said was:

So, first, configure, then "make" using gmake - this is the compile 
step. Then install - this puts all of the files in the places they need 
to go - the libraries, executables, etc. Then you need to add a new 
user, called postgres, who will be the admin user for the server. Create 
a directory for the data that is owned by the postgres user. Then 
initiate the database system (which creates the system tables). Start up 
PG, create a database called 'test' and then use the client to interact 
with that database.

-- 
Michelle Murrain
Coordinator, Nonprofit Open Source Initiative
http://nosi.net

Skype: pearlbear
AIM: pearlbear0


More information about the Courses mailing list