[Courses] [Postgresql] Installing PostgreSQL and Assignments

[Figaro]

Hello, all.
sorry not to answer sooner.
What I did, subsequent to the quoted original emeil:
#:passwd postgres
#:su postgres
#:createdb test
#:psql
#\c test
Everything looked good so:
test=#:\q
Then I went on to
#:su postgres
#create user beaumarchais
#:SQL: CREATE USER beaumarchais WITH PASSWORD 'something'
#:SQL: GRANT UPDATE ON table-name to beaumarchais
#:SQL: GRANT SELECT ON table-name to beaumarchais
#:SQL: GRANT INSERT ON table-name to beaumarchais
#:SQL: GRANT RULE ON table-name to beaumarchais
#:\q
Reading doc
Thank you
matthew

Liz Young wrote:
> Hi Matthew,
> 
> Were you able to create the db yet? If not, see below. 
> 
> On Tuesday 27 November 2007 10:47:00 am Figaro wrote:
>> Well issuing:
>> apogee:/home/beaumarchais#postgres returns: command not found
> 
> Try "su - postgres":
> apogee:/home/beaumarchais# su - postgres
> Enter the root password and you should see the prompt below:
> postgres@:apogee~$
> 
>> Okay, so what does one look for?
>> apogee:/home/beaumarchais#pg seems to work, but not certain.
> 
> Create the db by running "createdb test":
> postgres@:apogee~$ createdb test
> and connect to it by running "psql test":
> postgres@:apogee~$ psql test
> 
> HTH,
> -Liz
> _______________________________________________
> Courses mailing list
> Courses at linuxchix.org
> http://mailman.linuxchix.org/mailman/listinfo/courses
>