Difference between revisions of "Create database (PostgreSQL)"

From wikieduonline
Jump to navigation Jump to search
Line 5: Line 5:
  
 
[[PostgreSQL]]
 
[[PostgreSQL]]
  CREATE DATABASE "scratch"
+
  CREATE DATABASE "yournewdbname";
 +
 
 +
  CREATE DATABASE "yournewdbname"
 
   WITH OWNER "postgres"
 
   WITH OWNER "postgres"
 
   ENCODING '[[UTF8]]'
 
   ENCODING '[[UTF8]]'

Revision as of 13:25, 1 August 2022



PostgreSQL

 CREATE DATABASE "yournewdbname";
CREATE DATABASE "yournewdbname"
 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"
 Soluction:  locale-gen en_US.UTF-8

Solution: [1]

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


Createdb command

sudo su - postgres
createdb -E UNICODE -l C -T template0 YOUR_DB_NAME
(no output)

Related terms

See also

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