with docker
Connection via tcp
create users
via postgres
user. mydb's owner will be postgres
.
sudo -u postgres psql
create database mydb;
create user myuser with encrypted password 'mypass';
grant all privileges on database mydb to myuser;
Create new db & new owner
CREATE DATABASE dbname OWNER rolename;
db's timezone
ALTER DATABASE exsampledb SET timezone TO 'Asia/Tokyo';