[plug] Postgresql help && RH6.2
Colin Rothnie
colinr at tiwest.com.au
Wed Jul 26 17:03:30 WST 2000
James
I won't comment on the rights or wrongs of giving the root user postgres
privleges. However, once you have done everything Anthony describes, you
need to issue the createdb command to create a new database to use. You
need a database in order to start psql.
-------------- example --------------
$ createdb test
CREATE DATABASE <= this is postgresql's response
$ psql test
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test=#
---------------- end example --------------
Best of luck with it. RH 6.2 comes with an "old" version of Postgresql that
lacks many of the fancy things in the latest version. If you find that
Postgresql is lacking some of the things you need, then check out the latest
version from http://www.postgresql.org . It is available as a set of RPM
files.
Cheers
Colin Rothnie
More information about the plug
mailing list