Adding new users to postgres

http://www.cyberciti.biz/faq/howto-add-postgresql-user-account/

Access postgres with database you want to share,
do

CREATE USER new_user WITH PASSWORD 'password'; 

and then

GRANT ALL PRIVILEGES ON DATABASE database to new_user;