Postgres SQL

Install PostgreSQL client on mac using Homebrew

> brew install postgresql

DPay Credentials

(see dpay's config.yml)

Connect using psql

> psql --host=tardis.dev.pci.irdeto.com --port=5433 --dbname=postgres --username=dbmaster --password

Dump Database

> pg_dump --host=localhost --port=5432 --dbname=TardisDB --username=dbmaster --password >db_dump.sql

Import DB Dump

> psql --host=localhost --port=5432 --dbname=TardisDB --username=dbmaster --password < db_dump.sql

Create User

> CREATE User <username> WITH PASSWORD 'password';

> SELECT * FROM pg_user;

> DROP USER <username>;

Alter User's Password

> ALTER USER <username> WITH PASSWORD 'password';

Create Database

> CREATE DATABASE "dbname";

> CREATE DATABASE "dbname" WITH OWNER = "provisioner";

> GRANT ALL PRIVILEGES on DATABASE <dbname> TO <user>;

Common Commands