$ sudo -u postgres createuser -W dbuser
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
Password:

$ sudo -u postgres createdb testdb -O dbuser
		
		

新建数据库

		
CREATE DATABASE woodart
  WITH ENCODING='UTF8'
       OWNER=woodart;
       
		

		
CREATE DATABASE mydb ENCODING 'UTF8' TEMPLATE template0 OWNER dbuser TABLESPACE myspace;			
		
		

			
dropdb mydb			
			
			

			
DROP DATABASE mydb