welcome: please sign in
location: Postgresql
[[Category:Cheatsheets]]
=Working with PostgreSQL=
Typically, management of postgresql happens as the postgres user, and so many shell commands must be happen in the context of that user.

  # su - postgres

==Create a new user==
Connect to the database:

  $ psql -d template1 -U postgres

Create a user
  # template1=# create user moodle with password 'xxxxxx';

Create a database
  # create database moodle;

Grant privileges
  # grant all privileges on database moodle to moodle;

Postgresql (last edited 2014-05-26 17:02:29 by meyersh)