Edite o arquivo pg_hba.conf para liberar acesso com qualquer senha: #vi /etc/postgresql/8.3/main/pg_hba.conf altere a linha: host all all 127.0.0.1/32 md5 para: host all all 127.0.0.1/32 trust essa linha permite que haja conexão…
Tag: postgresql
Comando para monitorar as querys do postgres em tempo real
watch “psql -h localhost -U postgres UMABASE -c ‘SELECT datname,procpid,current_query FROM pg_stat_activity;’|grep -v IDLE|grep -v ‘SELECT datname,procpid,current_query FROM pg_stat_activity;’ | grep -v ^\( | grep -v ‘datname | procpid ‘ | grep…