PostgreSQL Notes

Post tags: | linux | pgagent | postgresql | sqltabs |

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 | {}

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 Installation

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

SQL Tabs site


pgAdmin site