Install PostgreSQL client on mac using Homebrew
> brew install postgresql
DPay Credentials
Username | dbmaster |
---|---|
password | (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
Command | Description |
---|---|
\l \list \l+ | List databases List with additional information |
\dt | Llist all tables in the current database |
\d \d+ | List all tables, views and sequesnces |
\connect database_name | Connect to the database |
select usename from pg_user | List users |