Versions Compared

Old Version 10

changes.mady.by.user Chun Kang

Saved on

compared with

New Version 11

changes.mady.by.user Chun Kang

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Below is a common script can create a database in PostgreSQL

Code Block
sudo -u postgres psql -c "CREATE USER your_user_id with password 'your_password' superuser;"
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

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';

create database mydb with encoding='utf8' template=template0;
create user myuser with encrypted password 'mypass';
grant all privileges on database mydb to myuser;


You can also do above directly by adding -c parameter:

Code Block
sudo -u postgres psql -c "CREATE USER your_user_id with password 'your_password' superuser;"
Code Block
sudo -u postgres psql -c 'create database confluence with owner your_user_id;'


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

...