Creating SSH Keys with ssh-keygen and ssh-copy-id

Testado com Postgres 9.6.7
Fonte original:
https://github.com/pgexperts/pgx_scripts/blob/master/indexes/unused_indexes.sql

WITH
		table_scans AS (
			SELECT
...

O plugin caches, por motivo desconhecido, causa um erro ao inicializar a aplicação com grails 2.2.4.

Remover os caches corrige o problema:

rm -rf ~/.grails/.slcache/

PROBLEMA

sudo service postgresql start
* Starting PostgreSQL 9.3 database server
* Error: Config owner (usuario:1000) and data owner (postgres:116) do not match, and config owner is not root

EXPLICAÇÃO

Algum arquivo do postg...

PASSOS

• No link http://www.firebirdsql.org/en/jdbc-driver/ baixe o "Jaybird-X.Y.ZJDK_A.B.zip" da versão do Java que você utiliza na sua máquina
• Descompacte o ZIP e salve o arquivo "jaybird-full...

SELECT a.table_name, a.column_name, a.constraint_name, c.owner, 
   -- referenced pk
   c.r_owner, c_pk.table_name r_table_name, c_pk.constraint_name r_pk
FROM all_cons_columns a
JOIN all_constraints c ON a.owner = c.owner
...

SELECT
    c.conname nomeForeignKey,
    c.conrelid::pg_catalog.regclass tabelaOrigem,
    pg_catalog.pg_get_constraintdef(c.oid, TRUE) AS definicaoForeignKey
FROM pg_catalog.pg_constraint c
    JOIN pg_catalog.pg_class r O...

ssh -vvv -o LogLevel=DEBUG3 <usuario>@<ip>