tonekk/Postgres CheatSheet.md

## Postgres CheatSheet.md

      
    Raw
  

              Postgres CheatSheet.md
            
          
    Postgres CheatSheet

Create root user


Start postgres
psql template1
CREATE USER root WITH SUPERUSER;

Or

sudo -u -i postgres
createuser --interactive root

Change root password


psql
ALTER USER "root" WITH PASSWORD 'new_password';

Create database

root~# createdb db_name
Allow remote connection


vim /etc/postgresql/9.3/main/pg_hba.conf
Insert line host    all         all         192.168.101.20/24    trust
Change listen in postgresql.conf

http://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/