posgresql 345 Bytes
Newer Older
Mario Chirinos Colunga's avatar
Mario Chirinos Colunga committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
sudo su - postgres
psql





CREATE USER geoint WITH PASSWORD 'gepoint';



CREATE DATABASE m3db;
ALTER ROLE geoint SET client_encoding TO 'utf8';
ALTER ROLE geoint SET default_transaction_isolation TO 'read committed';
ALTER ROLE geoint SET timezone TO 'UTC';
GRANT ALL PRIVILEGES ON DATABASE m3db TO geoint;

DROP DATABASE [ IF EXISTS ] name