Postgres Create user, modify user password, CREATE DATABASE __ Database

Reference: http://my.oschina.net/dddpeter/blog/116153

1. Create a user

1	Sudo-s-U postgres

2

Psql

3	postgres# CREATE USER xxxx1 with PASSWORD ' xxxx ';

4	postgres# CREATE DATABASE xxxx2;

5	postgres# GRANT all privileges on the DATABASE xxxx2 to xxxx1;

2. Change the password

Alter user postgres with password ' foobar ';

3. Create a Database

1	Createdb--encoding=utf8--owner=foo--template=template_postgis-ufoo

Parameter:--encoding=utf8 sets the character set of the database

--owner=foo to set the owner of the database

--tmplate=template_postgis set up a template to build a library that supports spatial data operations

--ufoo creating a database with Foo user identity

4. Pgsql command line querying all databases 0

\l Querying all databases (l is lowercase in l)

\l+ querying all databases and displaying detailed information