sudo -u postgres psql -c 'create database newid;'

If you want to encode in UTF8, you need to change teamplate0 in UTF8 first

sudo -u postgres psql
update pg_database set datallowconn = TRUE where datname = 'template0';
\c template0
update pg_database set datistemplate = FALSE where datname = 'template1';
drop database template1;
create database template1 with template = template0 encoding = 'UTF8';
update pg_database set datistemplate = TRUE where datname = 'template1';
\c template1
update pg_database set datallowconn = FALSE where datname = 'template0';
sudo -u postgres psql -c "create database newid with encoding='utf8' template=template0;"
CREATE DATABASE db_name
 OWNER =  role_name
 TEMPLATE = template
 ENCODING = encoding
 LC_COLLATE = collate
 LC_CTYPE = ctype
 TABLESPACE = tablespace_name
 CONNECTION LIMIT = max_concurrent_connection


WITH ENCODING='UTF8'

Once you create user successfully, you can try to check by

psql -h localhost -U <your_username>

To see the database list

\list

To see the user list

\du
  • No labels