Create database (PostgreSQL)

PostgreSQL

CREATE DATABASE "scratch"
 WITH OWNER "postgres"
 ENCODING 'UTF8'
 LC_COLLATE = 'en_US.UTF-8'
 LC_CTYPE = 'en_US.UTF-8';

CREATE DATABASE "scratch"
 WITH OWNER "postgres"
 ENCODING 'UTF8';

https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html

CREATE DATABASE "confluence"
 WITH OWNER "confluenceuser"
 ENCODING 'UTF8'
 LC_COLLATE = 'en_US.UTF-8'
 LC_CTYPE = 'en_US.UTF-8';

Output:

 CREATE DATABASE
or
 ERROR:  role "confluenceuser" does not exist
or
ERROR:  new collation (en_US.UTF-8) is incompatible with the collation of the template database (C.UTF-8)
HINT:  Use the same collation as in the template database, or use template0 as template.
or
 ERROR:  invalid locale name: "en_US.UTF-8"

Solution:

CREATE DATABASE "confluence"
 WITH OWNER "confluenceuser"
 ENCODING 'UTF8'
 LC_COLLATE = 'en_US.UTF-8'
 LC_CTYPE = 'en_US.UTF-8'
 TEMPLATE template0;

Output:

CREATE DATABASE

Related terms

• Connect to a database
• Show databases
• Create database
• Delete database
• Create user
• List users
• List databases
• List tables: show tables
• GRANT
• Create user
• GRANT ALL PRIVILEGES ON DATABASE confluence TO confluenceuser;

See also

• PostgreSQL: pg_dump, pg_restore, pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB, Adminer, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs, postgresql.conf, pg_hba.conf, $HOME/.pg_service.conf, Create database (PostgreSQL), Create user, createdb, GRANT, pg_stat, PostgreSQL VACUUM, EXPLAIN, pg stat activity, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL), EXPLAIN ANALYZE, Bitmap scan, EXPLAIN VERBOSE, EXPLAIN VERBOSE (PostgresSQL), WAL, ALTER USER, CREATE ROLE, CREATE USER, \du, show users, \l, The Statistics Collector, pganalyze, cron.schedule, Master, pg_tables, PostgreSQL replication, CREATE, SET, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users, catalogs
• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306, /etc/mysql/

https://stackoverflow.com/questions/18870775/how-to-change-the-template-database-collection-coding