wiki:Postgres_Training

Installing postgres

root# aptitude install postgresql

Setting up a user and a database

root# adduser --disabled-password --gecos='Master Chef,,,,' masterchef
root# su - postgres
postgres$ createuser -S -D -R masterchef
postgres$ createdb -O masterchef dinnerparty

connecting to the database

masterchef$ psql dinnerparty
Last modified 7 years ago Last modified on Dec 3, 2010, 2:32:03 PM