[Courses] [Postgresql] Installing PostgreSQL and Assignments
Figaro
ynegorp at charter.net
Mon Dec 3 18:22:25 UTC 2007
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
>
More information about the Courses
mailing list