Last active
January 27, 2020 13:38
-
-
Save kmaksimovv/557eabde7af556ca68037089e1684306 to your computer and use it in GitHub Desktop.
postgress_setup_ubuntu
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sudo apt-get update | |
| sudo apt-get install postgresql postgresql-contrib | |
| sudo -u postgres psql | |
| create user username with password 'password'; | |
| create database vscale_db; | |
| grant all privileges on database vscale_db to username; | |
| \q | |
| CREATE USER dmosk WITH PASSWORD 'myPassword'; | |
| GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "dmosk"; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment