...
Code Block |
---|
sudo -u postgres psql -c 'create database confluence with owner your_user_id;' |
You can do above as following:
Code Block |
---|
sudo -u postgres psql
create database mydb;
create user myuser with encrypted password 'mypass';
grant all privileges on database mydb to myuser; |
If you want to encode in UTF8, you need to change teamplate0 in UTF8 first
...