Skip to content

Instantly share code, notes, and snippets.

@simonthompson99

simonthompson99/create-indx-db.sql

Last active January 15, 2021 11:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save simonthompson99/f677953ba3c01631d3fc6e6e9e634b98 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save simonthompson99/f677953ba3c01631d3fc6e6e9e634b98 to your computer and use it in GitHub Desktop.
Download ZIP
[Create new Indx Db] Create new database on index and grant priviliges to cdt_user, needs [login details from Confluence](https://cnfl.extge.co.uk/display/CDT/_Logins) #sql #database #workflow #genomics_england
Raw
create-indx-db.sql
/* use user:password for superuser on https://cnfl.extge.co.uk/display/CDT/_Logins */
psql metrics -h localhost -p 5441 -U postgres
create database <db_name>;
grant all privileges on database <db_name> to cdt_user;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment