sebawebber

-- tested in PostgreSQL 8.4.4
DROP VIEW IF EXISTS vw_all_table_locks CASCADE;
CREATE VIEW vw_all_table_locks AS
SELECT 
  pg_namespace.nspname as schemaname,
  pg_class.relname as tablename,
  pg_locks.mode as lock_type,
  age(now(),pg_stat_activity.query_start) AS time_running 
FROM pg_class
JOIN pg_locks on pg_locks.relation = pg_class.oid

sebawebber

dropdb -U postgres -d lab3

sebawebber

/var/log/pgsql/pgsql.log {
missingok
rotate 7
nomail
sharedscripts
daily
dateext
create 0660 root root

postrotate

sebawebber

[Unit]
Description=WildFly Domain Controller
After=network.target

[Service]
Type=simple
User=jboss
Group=jboss
ExecStart=/opt/wildfly-8.2.0.Final/bin/domain.sh -bmanagement=0.0.0.0

sebawebber

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

sebawebber

Habilitar SSL no PostgreSQL

Execute os procedimentos abaixo para habilitar SSL no seu servidor PostgreSQL.

1. Crie um diretório para armazenar as configurações (opcional)

mkdir certificados
cd certificados

sebawebber

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

sebawebber

[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

sebawebber

[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

sebawebber

[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