Basic with Postgresql

For psql command line, We'll start with


>>> psql


Create User


psql::CREATE USER joe;
psql::ALTER ROLE joe PASSWORD 'secret_password';


Or


psql::CREATE USER username WITH PASSWORD 'xxxxx';


Or


Create an account where the user can create db;
psql::CREATE USER username WITH PASSWORD 'xxxxx' CREATEDB;


Give him a right on superuser


psql::ALTER ROLE joe WITH CREATEDB;
psql::ALTER ROLE joe WITH SUPERUSER;


Create Database


psql::CREATE DATEBASE mydb;


Or


psql::CREATE DATABASE dbname OWNER rolename;


Grant all available privileges to user


psql::GRANT ALL PRIVILEGES ON mydb TO joe;


psql::GRANT admins TO joe;

Comments

Post a Comment

Popular posts from this blog

Return Code 127

Exit codes and kill-job signals The exit code from a batch job is a standard Unix termination status, the same sort of number you get in a shell script from checking the " $? " variable after executing a command. Typically, exit code 0 (zero) means successful completion. Codes 1-127 are typically generated by your job itself calling  exit()  with a non-zero value to terminate itself and indicate an error. In BaBar we don't make very much use of this. The most common such value you might see is 64, which is the value used by Framework to say that its event loop is being stopped before all the requested data have been read, typically because time ran out. In recent BaBar releases you might also see 125, which we use as a code for a generic "severe error"; the job log should contain a message stating what the error was. Exit codes in the range 129-255 represent jobs terminated by Unix " signals ". Each type of signal has a number, and what's r
Read more