sebastianwebber

-- Tested on PostgreSQL 9.4
--  More details on  http://www.postgresql.org/docs/9.4/static/functions-info.html
--               and http://www.postgresql.org/docs/9.4/static/view-pg-tables.html
--               and http://www.postgresql.org/docs/9.4/static/view-pg-roles.html

SELECT
  schemaname,
  tablename,
  rolname,
  has_table_privilege(rolname, tablename, 'SELECT') as can_select,

sebastianwebber

SELECT 
  'ALTER TABLE ' || 
  schema.nspname || '.' || class.relname
  || ' DROP CONSTRAINT IF EXISTS ' || 
  cons.conname || ';'  
FROM pg_constraint AS cons
JOIN pg_class AS class on class.oid = cons.conrelid
JOIN pg_namespace AS schema on schema.oid = cons.connamespace
WHERE schema.nspname = 'schema'
  AND class.relname = 'tabela';

sebastianwebber

[Unit]
Description=RHQ Storage Node
After=network.target
PartOf=rhq-server.service

[Service]

Type=forking

ExecStart=/opt/rhq-server-4.13.1/bin/rhqctl start --storage

sebastianwebber

[Unit]
Description=RHQ Server
Requires=rhq-storage.service
After=rhq-storage.service

[Service]

Type=forking
PIDFile=/opt/rhq-server-4.13.1/bin/internal/rhq-server.pid

sebastianwebber

[Unit]
Description=RHQ Agent
After=network.target

[Service]

Type=forking
PIDFile=/opt/rhq-agent/bin/rhq-agent.pid

ExecStart=/opt/rhq-server-4.13.1/bin/rhqctl start --agent

sebastianwebber

#!/bin/bash
yum install python-setuptools python-psutil python-psycopg2 git gcc make postgresql93-devel  -y
export PATH="/usr/pgsql-9.3/bin:$PATH"
mkdir /opt/resources
cd /opt/resources
git clone https://github.com/julmon/pg_activity.git 
cd pg_activity/
python setup.py install --with-man

sebastianwebber

:set bg=dark
:set nu
:set tabstop=4
:set shiftwidth=4
:set softtabstop=4
:set expandtab
:set ic
:set nowrap

sebastianwebber

Instalação do Oracle 11gR2 no OEL6

instalar vnc

yum install tigervnc-server xterm

ajustar configurações

sebastianwebber

JBoss/Wildfly server.log REGEX sheet cheat

Summary

'(WARN|ERROR)[ ]{1,}\[[\.a-z0-9A-Z]{1,}\]'

egrep sample:

egrep '(WARN|ERROR)[ ]{1,}\[[\.a-z0-9A-Z]{1,}\]' -o server.log

sebastianwebber

PostgreSQL Tools SETUP

Tested on el7 system.

Software recomendado:

• htop
• atop
• pg_activity
• pg_view