История страницы

sudo -u postgres -i
-bash-4.2$ psql
psql (9.2.15)
Type "help" for help.

postgres=# CREATE USER jiradbuser PASSWORD 'jiradbpassword';
GRANT ALL ON SCHEMA public TO jiradbuser;
GRANT ALL ON ALL TABLES IN SCHEMA public TO jiradbuser;
CREATE DATABASE jiradb WITH ENCODING='UTF8' 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0 OWNER=jiradbuser CONNECTION LIMIT=-1;
\q