PostgreSQL Notes
Login as postgres using sudo
sudo su - postgres
postgres@ivie:~$ psql
psql (9.4.6)
Type "help" for help.
postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
postgres | Superuser, Create role, Create DB, Replication | {}
postgres=#
- PostgreSQL packages for Debian and Ubuntu
- How to Install PostgreSQL 9.3 on Debian 7 Wheezy
- PostgreSQL 9.3.5 Documentation
- docs - SELECT, TABLE, WITH – retrieve rows from a table or view
digitalocean tutorial How To Use Roles
How To Use Roles and Manage Grant Permissions in PostgreSQL on a VPS
Heroku - Efficient Use of PostgreSQL Indexes
pgagent
pgAgent Installation
pgAgent runs as a daemon on Unix systems, and a service on Windows systems. In the majority of cases it will run on the database server itself - it is for this reason that pgAgent is not automatically setup when pgAdmin is installed.
Daemon installation on Unix
SQL Tabs
SQL Tabs - Rich SQL console for Postgresql