Re: [HACKERS] Re: HISTORY for 6.5.2
Marc G. Fournier <scrappy@hub.org>
From: The Hermit Hacker <scrappy@hub.org>
To: Michael Simms <grim@argh.demon.co.uk>
Cc: Yu Cao <yucao@falcon.kla-tencor.com>, "pgsql-hackers@postgreSQL.org" <pgsql-hackers@postgresql.org>
Date: 1999-09-21T01:44:04Z
Lists: pgsql-hackers
On Tue, 21 Sep 1999, Michael Simms wrote:
> I would have to say that if you 'started out with theintention of writing
> a corba front-and' then I dont think you can really speak for newbies.
>
> When I started using postgresql I had vaguely heard of odbc and I had
> a couple of example queries of SQL.
>
> If I had had to go to template1 and create database whatever; and THEN
> go use it, I would have been fairly confused.
Why? How did you learn about the createdb or createuser commands in the
first place?
Section 20 of the INSTALL file could read:
20. Briefly test that the backend will start and
run by running it from the command line.
a. Start the postmaster daemon running in the
background by typing
$ cd
$ nohup postmaster -i > pgserver.log 2>&1 &
b. Connect to the database by typing
$ psql template1
b. Create a database by typing
$ create database testdb;
c. Connect to the new database by typing:
template1=> \connect testdb
d. And run a sample query:
testdb=> SELECT datetime 'now';
e. Exit psql:
testdb=> \q
f. Remove the test database (unless you will
want to use it later for other tests):
testdb=> drop database testdb;
now the end user knows how to create and drop a database properly...
hell, add in a few extra steps for creating a new user and deleting
him...once ppl know the commands exist, they will use them and learn how
to better use them...
For 'newbies', they learn about createdb/createuser from the INSTALL
file...it doesn't take anything to teach them to do 'CREATE DATABASE' vs
'createdb', and it gives them the *proper* way to do it...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org