roles/pleroma/templates/setup_db.psql.j2
changeset 63 56531bbfd074
parent 60 48a3a65119d5
child 66 652a236229c2
equal deleted inserted replaced
62:63586cf10d46 63:56531bbfd074
     1 CREATE USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}' CREATEDB;
     1 CREATE USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}';
     2 -- in case someone runs this second time accidentally
     2 CREATE DATABASE {{pleroma_user}} OWNER {{pleroma_user}};
     3 ALTER USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}' CREATEDB;
       
     4 CREATE DATABASE {{pleroma_user}};
       
     5 ALTER DATABASE {{pleroma_user}} OWNER TO {{pleroma_user}};
       
     6 \c {{pleroma_user}};
     3 \c {{pleroma_user}};
     7 --Extensions made by ecto.migrate that need superuser access
     4 --Extensions made by ecto.migrate that need superuser access
     8 CREATE EXTENSION IF NOT EXISTS citext;
     5 CREATE EXTENSION IF NOT EXISTS citext;
     9 CREATE EXTENSION IF NOT EXISTS pg_trgm;
     6 CREATE EXTENSION IF NOT EXISTS pg_trgm;
       
     7 CREATE EXTENSION IF NOT EXISTS "uuid-ossp";