Skip to content

Instantly share code, notes, and snippets.

@the-teacher
Created October 16, 2015 08:18
Show Gist options
  • Save the-teacher/505ff06a525286afdcd4 to your computer and use it in GitHub Desktop.
Save the-teacher/505ff06a525286afdcd4 to your computer and use it in GitHub Desktop.
sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev postgresql-server-dev-9.1 pgadmin3 -y
sudo -u postgres psql postgres
CREATE ROLE "ADMIN_NAME" PASSWORD 'qwerty' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
\q
sudo /etc/init.d/postgresql restart
psql postgres ADMIN_NAME
SELECT version();
SELECT datname FROM pg_database;
\q
@hakushu-publishing
Copy link

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment