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 | {}
        
        postgres=# 
        

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

pgAdmin site