Skip to content

Instantly share code, notes, and snippets.

@rounakdatta

rounakdatta/postgresHelper.md

Last active April 18, 2019 20:22
Show Gist options
  • Save rounakdatta/deadd37fdb257507ec1057b2b8ea155a to your computer and use it in GitHub Desktop.
Save rounakdatta/deadd37fdb257507ec1057b2b8ea155a to your computer and use it in GitHub Desktop.
Download ZIP
Setting up PostgreSQL on you Arch Linux
Raw
postgresHelper.md

Installing postgresql on your Arch Linux

Enter the postgres-located terminal

sudo -iu postgres

Initialize postgres database system

initdb -D /var/lib/postgres/data/

Create an user (go with your UNIX username for a cakewalk)

createuser --interactive

Create a new database

createdb foobar

Or delete it

dropdb foobar

Enter the particular database's (maybe foobar?) terminal

psql -d foobar

And there you go, you're now alone with

\help

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