Skip to content

Instantly share code, notes, and snippets.

@hoangong

hoangong/init.sql

Last active January 6, 2019 00:33
Show Gist options
  • Save hoangong/71704a528059c6856c18ae33896c0894 to your computer and use it in GitHub Desktop.
Save hoangong/71704a528059c6856c18ae33896c0894 to your computer and use it in GitHub Desktop.
Download ZIP
init postgres user and grant permission #postgres
Raw
init.sql
sudo -u postgres psql postgres
CREATE USER testuser WITH PASSWORD '123123';
CREATE DATABASE testdb;
GRANT ALL PRIVILEGES ON DATABASE testdb to testuser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment