[Courses] [Postgresql] Installing PostgreSQL and Assignments

[Liz Young]

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