wiki:Postgres_Training

Version 1 (modified by Daniel Kahn Gillmor, 9 years ago) (diff)

--

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